Administrator's Reference

QUERY OPTION (Query Server Options)

Use this command to display information about server options.

Change server options by editing the server options file or by issuing the SETOPT command. If you edit the server options file, you must restart the server before any changes take effect. Any changes you make by issuing the SETOPT command take effect immediately.

Privilege Class

Any administrator can issue this command.

Syntax

                   .-*----------.
>>-Query OPTion----+------------+------------------------------><
                   '-optionname-'
 

Parameters

optionname
Specifies the name of an option in the server options file. This parameter is optional. You can use wildcard characters to specify this name. All matching server options are displayed. If you do not specify this parameter, information on all options is displayed.

Examples

Task 1

Display general information about all server options.

Command:
query option

Output:
 

+--------------------------------------------------------------------------------+
|Server Option      Option Setting     Server Option       Option Setting        |
|-----------------  ----------------   ---------------     ---------------       |
| CommTimeOut        60                    IdleTimeOut        15                 |
|BufPoolSize        2048                  LogPoolSize        512                 |
|DateFormat         1 (mm/dd/yyyy)        TimeFormat         1 (hh:mm:ss)        |
|NumberFormat       1 (1,000.00)          MessageFormat      1                   |
|Language           AMENG                 MaxSessions        25                  |
|ExpInterval        24                    ExpQuiet           No                  |
|EventServerLoggi-  Yes                   MirrorRead DB      Normal              |
| ng                                                                             |
|MirrorRead LOG     Normal                MirrorWrite DB     Sequential          |
|MirrorWrite LOG    Parallel              VolumeHistory      volhist.out         |
|Devconfig          devcnfg.out           TxnGroupMax        40                  |
|MoveBatchSize      40                    MoveSizeThresh     500                 |
|StatusMsgCnt       10                    RestoreInterval    1,440               |
|UseLargeBuffers    Yes                   DisableScheds      No                  |
|AuditStorage       Yes                   REQSYSauthoutfile  Yes                 |
|SELFTUNEBUFpools-  No                    SELFTUNETXNsize    No                  |
| ize                                                                            |
|DBPAGEShadow       Yes                   DBPAGESHADOWFile   dbpgshdw.bdt        |
|ADSMGROUPname      adsmserver            SECUREPipes        No                  |
|NPAUDITSuccess     No                    NPAUDITFailure     No                  |
|NPBUFfersize       8192                  TcpPort            1500                |
|TCPWindowsize      8192                  TCPNoDelay         No                  |
|HttpPort           1580                  HttpsPort          1543                |
|IPXSocket          8522                  NetbiosBufferSize  32768               |
|NetbiosSessions    25                    IpxBufferSize      32768               |
|IPXProtocol        SPXII                 NamedPipeName      \\.\PIPE\ADSMPIPE   |
|CommMethod         TCPIP                 CommMethod         NAMEDPIPE           |
|CommMethod         HTTP                  Message Interval   1                   |
|FileExit                                 FileTextExit                           |
|UserExit                                 MaxMemory          536870912           |
|AcsAccessId                              AcsTimeoutX        1                   |
|AcsLockDrive       No                    AcsQuickInit       Yes                 |
|SNMPSubagentPort   1521                  SNMPSubagentHost   127.0.0.1           |
|SNMPHeartBeatInt   5                     TECHost                                |
|TECPort            0                     AffinityMask       0x0000              |
|AssistVCRRecovery  Yes                                                          |
|                                                                                |
|                                                                                |
+--------------------------------------------------------------------------------+

where:

Server Option
Specifies the name of the server option.

Option Setting
Specifies the current value of the server option.

Task 2

View the option settings for all options that begin with L.

Command:
query option l*

Output:
 

+--------------------------------------------------------------------------------+
|Server Option         Option Setting                                            |
|-----------------     --------------------                                      |
|LogPoolSize           256                                                       |
|Language              AMENG                                                     |
|LanAdapter            2                                                         |
+--------------------------------------------------------------------------------+

Related Commands

Table 182. Commands Related to QUERY OPTION

Command Description
SETOPT Updates a server option without stopping and restarting the server.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]