Entering content frame

Object documentation SERVERDBSTATISTICS Locate the document in the library structure

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.

 

Leaving content frame