Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Startup (_Startup)
 
Startup (_Startup)
The _Startup VST displays the values of the database startup parameters that were used.
Note: Starting in OpenEdge Release 11.5, this VST is no longer updated. Use the _DbParams VST. See Database startup parameters file status (_DbParams).
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)