Use
This table contains information on the serverdb usage
Structure
SERVERDBSTATISTICS
SERVERDBSIZE |
FIXED (10) |
Serverdb size in pages |
MAXDATAPAGENO |
FIXED (10) |
Largest page number of the SERVERDB |
MAXPERM |
FIXED (10) |
Number of pages of the serverdb that can be used for non-temporary objects |
USEDPERM |
FIXED (10) |
Number of pages of the SERVERDB used for non-temporary objects |
PCTUSEDPERM |
FIXED (10) |
Percentage of pages used for non-temporary objects |
USEDTMP |
FIXED (10) |
Number of serverdb pages used for temporary objects |
PCTUSEDTMP |
FIXED (10) |
Percentage of pages used for temporary objects |
UNUSED |
FIXED (10) |
Number of unused pages |
PCTUNUSED |
FIXED (10) |
Percentage share of unused pages |
UPDATEDPERM |
FIXED (10) |
Number of modified pages for permanent objects |
SERVERDBFULL |
CHAR ( 3) |
YES: serverdb full NO: serverdb not full |
LOGSIZE |
FIXED (10) |
Size of the log area in pages |
USEDLOG |
FIXED (10) |
Number of log pages used |
PCTUSEDLOG |
FIXED (10) |
Percentage of log pages used |
PCTLOGNOTSAVED |
FIXED (10) |
Number of log pages not backed up |
PCTLOGNOTSAVED |
FIXED (10) |
Percentage of log pages not backed up |
LOGSINCEBACKUP |
FIXED (10) |
Number of log pages written since the last complete or incremental data backup |
RESERVEDREDO |
FIXED (10) |
Number of pages in the data devspace reserved for recovery |
LOGSEGMENTSIZE |
FIXED (10) |
Size of a log segment in pages |
SAVEPOINTS |
FIXED (10) |
Number of savepoints executed |
CHECKPOINTS |
FIXED (10) |
Number of checkpoints executed |
Integration
Statistics system tables