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                  |
|EventServerLogging Yes                   MirrorRead DB      Normal              |
|MirrorRead LOG     Normal                MirrorWrite DB     Sequential          |
|MirrorWrite LOG    Parallel              TxnGroupMax        40                  |
|MoveBatchSize      40                    MoveSizeThresh     500                 |
|StatusMsgCnt       10                    RestoreInterval    1,440               |
|UseLargeBuffers    Yes                   DisableScheds      No                  |
|AuditStorage       Yes                   3494SHAREd         No                  |
|TCPPort            1565                  HTTPPort           1564                |
|HTTPSPort          1543                  TCPWindowsize      0                   |
|TCPNoDelay         Yes                   CommMethod         TCPIP               |
|CommMethod         HTTP                  CommMethod         SNMP                |
|MsgInterval        1                     Enable3590Library  No                  |
|ShmPort            1510                  FileExit                               |
|UserExit                                 UseLargeTapeBlock  No                  |
|AcsAccessId                              AcsTimeoutX        1                   |
|AcsLockDrive       No                    SNMPSubagentPort   1521                |
|SNMPSubagentHost   9.115.45.21           SNMPHeartBeatInt   1                   |
|TECHost                                  TECPort            0                   |
|DiskMap            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           128                                                       |
|Language              AMENG                                                     |
|                                                                                |
+--------------------------------------------------------------------------------+

Related Commands

Table 184. 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 ]