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       600               IdleTimeOut       5                         |
|BufPoolSize       1024              LogPoolSize       128                       |
|DateFormat        1 (mm/dd/yyyy)    TimeFormat        1 (hh:mm:ss)              |
|NumberFormat      1 (1,000.00)      MessageFormat     2                         |
|Language          AMENG             MaxSessions       999                       |
|ExpInterval       1                 ExpQuiet          No                        |
|EventServerLoggi- No                MirrorRead DB     Normal                    |
| ng                                                                             |
|MirrorRead LOG    Normal            MirrorWrite DB    Sequential                |
|MirrorWrite LOG   Parallel          Devconfig         'tsmv4.devcnfg'           |
|TxnGroupMax       40                MoveBatchSize     40                        |
|MoveSizeThresh    500               StatusMsgCnt      10                        |
|RestoreInterval   1,440             UseLargeBuffers   Yes                       |
|DisableScheds     No                AuditStorage      Yes                       |
|REQSYSauthoutfile Yes               SELFTUNEBUFpools- No                        |
|                                     ize                                        |
|SELFTUNETXNsize   No                DBPAGEShadow      Yes                       |
|DBPAGESHADOWFile  DBPGSHDW.BDT                                                  |
|CommOpenTimeOut   20                TcpPort           1507                      |
|TcpName           TCPIP350          HttpTcpPort       1582                      |
|TECHost                             TECPort           0                         |
|IcsPort           1506              IcsSname          *NONE*                    |
|PDMPort           1515              PDMName           DMES                      |
|PDMConnect        TCP               TAPEIOBufs        1                         |
|UserExit                            FileExit          FILEEXIT.V41(APPEN        |
|                                                       D)                       |
|FileTextExit                        HttpIcsPort       1582                      |
|MsgSuppress       *NONE*            LuName            *NONE*                    |
|Iucv              *NONE*            RouteCode         11                        |
|MsgHilight        *NONE*            MPThreading       Yes                       |
|FIXediobufsize    16,777,216        TCPBufsize        32,768                    |
|HPDTenable        Yes               HPDTstorage       ECSA                      |
|HPDTbuffer#       6                 HPDTexpand#       2                         |
+--------------------------------------------------------------------------------+

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                                                     |
|                                                                                |
+--------------------------------------------------------------------------------+

Related Commands

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