DATASTATISTICS 
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
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.