Field name
|
Data type
|
Description
|
_Startup-AiBuffs
|
INTEGER
|
Number of after-image buffers
|
_Startup-AiName
|
CHARACTER
|
Value of the After-image Filename (-a) startup parameter
|
_Startup-Alternate_Buffs
|
INTEGER
|
Value of the Buffers in Alternate Buffer pool (-B2) startup parameter
|
_Startup-APWBuffs
|
INTEGER
|
Value of the Page Writer Scan (-pwscan) parameter
|
_Startup-APWMaxWrites
|
INTEGER
|
Value of the Page Writer Maximum Buffers (-pwwmax) startup parameter
|
_Startup-APWQTime
|
INTEGER
|
Value of the Page Writer Queue Delay (-pwqdelay) startup parameter
|
_Startup-APWSTime
|
INTEGER
|
Value of the Page Writer Scan Delay (-pwsdelay) parameter
|
_Startup-BiBuffs
|
INTEGER
|
Number of before-image buffers
|
_Startup-BiDelay
|
INTEGER
|
Delay of before-image flush (-mf)
|
_Startup-BiIO
|
INTEGER
|
Before-image file I/O (-r, -R)
|
_Startup-BiName
|
CHARACTER
|
Before-image filename (-g)
|
_Startup-BiTrunc
|
INTEGER
|
Before-image truncate interval (-G)
|
_Startup-Buffs
|
INTEGER
|
Number of database buffers (-B)
|
_Startup-CrashProt
|
INTEGER
|
No crash protection (-i)
|
_Startup-Directio
|
INTEGER
|
Direct I/O data transfer (-directio)—field is set to 1 when -directio is specified
|
_Startup-LGovernor
|
INTEGER
|
Value (in percentage) of the lock table that a tenant can occupy (-LGovernor)
|
_Startup-LockTable
|
INTEGER
|
Maximum size of the locking table
|
_Startup-LRU-Skips
|
INTEGER
|
Number of times a buffer in the buffer pool is accessed before being placed on the end of the LRU chain (-lruskips)
|
_Startup-LRU2-Skips
|
INTEGER
|
Number of times a buffer in the alternate buffer pool is accessed before being placed on the end of the LRU chain (-lru2skips)
|
_Startup-MaxClients
|
INTEGER
|
Value of the Maximum Clients per Server (-Ma) startup parameter
|
_Startup-MaxServers
|
INTEGER
|
Value of the Maximum Servers (-Mn) startup parameter
|
_Startup-MaxUsers
|
INTEGER
|
Value of the Maximum Users (-n) startup parameter
|
_Startup-MemOverflow
|
INT64
|
Value of the Shared Memory Overflow (-Mxs) startup parameter
|
_Startup-nGovernor
|
INTEGER
|
Number of users that may login for a tenant (-nGovernor)
|
_Startup-NmsgWait
|
INTEGER
|
Number of seconds a server waits for a remote network message before checking for other events such as a database shutdown or forced disconnect of a remote client (-Nmsgwait)
|
_Startup-Prefetch-Delay
|
LOGICAL
|
If set, enable a delay when sending the first network message for queries with prefetch capabilities (-prefetchDelay)
|
_Startup-Prefetch-Factor
|
INTEGER
|
Percentage of a network message required to contain prefetched data before sending the message to a waiting remote client (-prefetchFactor)
|
_Startup-Prefetch-Num- Recs
|
INTEGER
|
Number of records placed in a network message before it is sent to a remote client(-prefetchNumRecs)
|
_Startup-Prefetch-Priority
|
INTEGER
|
Number of records to add to the network message of an in-process prefetch query without additional polling, utilizing a "pollskip" (-prefetchPriority)
|
_Startup-Spin
|
INTEGER
|
Number of spinlock tries before time-out occurs (-spin)
|