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
Examples
Task 1
Display general information about all server options.
+--------------------------------------------------------------------------------+ |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:
Task 2
View the option settings for all options that begin with L.
+--------------------------------------------------------------------------------+ |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. |