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.
|
FIXED(20) |
Data area available for data (KB) |
|
FIXED(20) |
Memory in data area that is actually used for data (KB) |
|
FIXED(3) |
Memory in data area that is actually used for data (%) |
|
CHAR(3) |
Data area is full (YES | NO) |
|
FIXED(20) |
Amount of data written to data area (KB) |
|
FIXED(20) |
Amount of permanent data that has to be written to data area at next savepoint (KB) |
|
FIXED(20) |
Data area used for permanent data (KB) |
|
FIXED(20) |
Data area (KB) used for temporary data |
|
FIXED(20) |
Maximum data area used for data at a savepoint (KB) |
|
FIXED(20) |
Maximum data area used for permanent data at a savepoint (KB) |
|
FIXED(20) |
Maximum data area used for temporary data at a savepoint (KB) |
|
FIXED(20) |
Amount of data that needs to be backed up in next incremental backup (KB) |
|
TIMESTAMP |
Time at which undo log files were last deleted due to lack of space in data area (according to history file) |
|
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. |
|
FIXED(10) |
Highest page number available for temporary pages |
|
FIXED(10) |
Highest page number available for permanent pages |
|
FIXED(10) |
Highest page number available for permanent, static pages |
|
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) |
|
FIXED(10) |
Amount of temporary converter data (KB) |
|
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) |
|
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
.