SERVERDBSTATISTICS 
Definition
The statistics system table SERVERDBSTATISTICS contains information about the used space in the database instance.
Structure
SERVERDBSTATISTICS
SERVERDBSIZE |
FIXED(10) |
Database instance size in pages |
MAXDATAPAGENO |
FIXED(10) |
Highest page number of the database instance |
MAXPERM |
FIXED(10) |
Number of pages of the database instance that can be used for non-temporary objects |
MAXUSEDPAGES |
FIXED(10) |
Maximum number of used pages for a synchronization point (restart or savepoint) |
USEDPERM |
FIXED(10) |
Number of pages of the database instance used for non-temporary objects |
PCTUSEDPERM |
FIXED(10) |
Percentage of pages used for non-temporary objects |
USEDTMP |
FIXED(10) |
Number of database instance 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: database instance full NO: database instance not full |
USEDBLOCKS |
FIXED(10) |
Number of blocks on data volumes that are used by pages |
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 saved |
PCTLOGNOTSAVED |
FIXED(10) |
Percentage of log pages not yet saved |
LOGSINCEBACKUP |
FIXED(10) |
Number of log pages written since the last complete or incremental data backup |
LOGSEGMENTSIZE |
FIXED(10) |
Size of a log segment in pages |
SAVEPOINTS |
FIXED(10) |
Number of savepoints executed |
CHECKPOINTS |
FIXED(10) |
0 (the number of checkpoints is always set to 0.) |
The system table SERVERDBSTATISTICS exists only to enable compatibility with older database versions. Instead of the system table SERVERDBSTATISTICS, use the system tables DATASTATISTICS and LOGSTATISTICS.