![]() |
![]() |
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 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 Yes | |EventServer Yes MirrorRead DB Normal | |MirrorRead LOG Normal MirrorWrite DB Sequential | |MirrorWrite LOG Parallel VolumeHistory volhist.out | |Devconfig devcnfg.out TxnGroupMax 40 | |MoveBatchSize 40 MoveSizeThresh 500 | |StatusMsgCnt 1 RestoreInterval 1,440 | |UseLargeBuffers No DisableScheds No | |NOBUFPREfetch No AuditStorage Yes | |REQSYSauthoutfile Yes SELFTUNEBUFpool- No | | size | |SELFTUNETXNsize No DBPAGEShadow Yes | |DBPAGESHADOWFile dbpgshdw.bdt QueryAuth None | |LogWarnFullPerC- 90 ThroughPutDataT- 0 | | ent hreshold | |ThroughPutTimeT- 0 NOPREEMPT ( No ) | | hreshold | |Resource Timeout 10 | |ADSMGROUPname ADSMSERVER SECUREPipes No | |NPAUDITSuccess No NPAUDITFailure No | |NPBUFfersize 8192 TcpPort 1500 | |TCPWindowsize 64512 TCPNoDelay No | |HttpPort 1580 HttpsPort 1543 | |NamedPipeName \\.\PIPE\SERVER1 CommMethod TCPIP | |CommMethod NAMEDPIPE CommMethod HTTP | |Message Interval 1 FileExit | |FileTextExit UserExit | |MaxMemory 536870912 AcsAccessId | |AcsTimeoutX 1 AcsLockDrive No | |AcsQuickInit No SNMPSubagentPort 1521 | |SNMPSubagentHost 127.0.0.1 SNMPHeartBeatInt 5 | |TECHost TECPort 0 | |AffinityMask 0x0000 AssistVCRRecovery Yes | |AdRegister No AdUnRegister No | |AdSetDC AdComment | |SHAREDLIBIDLE No | | | | | +----------------------------------------------------------------------------------+
where:
Task 2
View the option settings for all options that begin with L.
+--------------------------------------------------------------------------------+ |Server Option Option Setting | |----------------- -------------------- | |LogPoolSize 256 | |Language AMENG | |LanAdapter 2 | +--------------------------------------------------------------------------------+
Related Commands
Table 199. Commands Related to QUERY OPTION
Command | Description |
---|---|
SETOPT | Updates a server option without stopping and restarting the server. |