Object documentationDATASTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.DATASTATISTICS describes the current fill level of the database and the maximum fill level since the last time the database 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

USEDPERMANENTCONVERTERSIZE

FIXED(10)

Total amount of permanent converter data in the active converter (disregarding shadow storage data and the converter data which belongs to a snapshot) (KB)

USEDTEMPORARYCONVERTERSIZE

FIXED(10)

Amount of temporary converter data (KB)

USEDSNAPSHOTSIZE

FIXED(10)

Amount of permanent data and converter data which is addressed in the inactive snapshot converter only and for which there is no entry in the active converter (KB)

USEDSHADOWSIZE

FIXED(10)

Amount of shadow storage data which can be released at the next savepoint (KB)

The permanent data pages of the snapshot are not counted under the value USEDPERMANENTSIZE, but rather under USEDSNAPSHOTSIZE.

The permanent converter pages of the snapshot are not counted under the value USEDPERMANENTCONVERTERSIZE, but rather under USEDSNAPSHOTSIZE.

More Information

Evaluating System Tables, DATASTATISTICS

DATASTATISTICSRESET