DATASTATISTICS

Definition

The system table DATASTATISTICS describes the current fill level of the database instance and the maximum fill level since the last time the database instance was started.

Structure

DATASTATISTICS

USABLESIZE

FIXED(20)

Data area available for data (KB)

USEDSIZE

FIXED(20)

Memory in data area that is actually used for data (KB)

USEDSIZEPERCENTAGE

FIXED(3)

Memory in data area that is actually used for data (%)

DATAFULL

CHAR(3)

Data area is full (YES | NO)

USEDSIZEONVOLUMES

FIXED(20)

Amount of data written to data area (KB)

USEDSIZENOTONVOLUMES

FIXED(20)

Amount of permanent data that has to be written to data area at next savepoint (KB)

USEDPERMANENTSIZE

FIXED(20)

Data area used for permanent data (KB)

USEDTEMPORARYSIZE

FIXED(20)

Data area (KB) used for temporary data

MAXUSEDSIZE

FIXED(20)

Maximum data area used for data at a savepoint (KB)

MAXUSEDPERMANENTSIZE

FIXED(20)

Maximum data area used for permanent data at a savepoint (KB)

MAXUSEDTEMPORARYSIZE

FIXED(20)

Maximum data area used for temporary data at a savepoint (KB)

INCREMENTALBACKUPSIZE

FIXED(20)

Amount of data that needs to be backed up in next incremental backup (KB)

LASTEMERGENCYHISTORYCLEANUP

TIMESTAMP

Time at which undo log files were last deleted due to lack of space in data area (according to history file)

CONVERTERVERSION

FIXED(10)

The converter data saved to the data area at the last savepoint is assigned a unique number (converter version). This number is stored in the restart information.

MAXTEMPORARYDATAPAGENUMBER

FIXED(10)

Highest page number available for temporary pages

MAXPERMANENTDATAPAGENUMBER

FIXED(10)

Highest page number available for permanent pages

MAXPERMANENTSTATICDATAPAGENUMBER

FIXED(10)

Highest page number available for permanent, static pages

See also:

Evaluating System Tables, DATASTATISTICS

DATASTATISTICSRESET