SERVERDBSTATISTICS 

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