SYSIBM.SYSLOBSTATS_HIST table
The SYSIBM.SYSLOBSTATS_HIST table contains rows from SYSIBM.SYSLOBSTATS.
Rows are added or changed in this table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.
| Column name | Data type | Description | Use |
|---|---|---|---|
| STATSTIME | TIMESTAMP
NOT NULL |
|
G |
| FREESPACE | INTEGER
NOT NULL |
Number of pages of free space in the LOB table space. | S |
| ORGRATIO | DECIMAL(5,2)
NOT NULL |
The percentage of organization in
the LOB table space. A value of '100' indicates perfect organization
of the LOB table space. A value of '1' indicates that the LOB table
space is disorganized. A value of '0' indicates that the LOB table space is totally disorganized. |
S |
| DBNAME | VARCHAR(24)
NOT NULL |
Name of the database that contains the LOB table space named in NAME. | G |
| NAME | VARCHAR(24)
NOT NULL |
Name of the LOB table space. | G |
| IBMREQD | CHAR(1)
NOT NULL WITH DEFAULT 'N' |
A value of Y indicates that the row came from the
basic machine-readable material (MRM) tape. For all other values,
see Release
dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
If RUNSTATS updated the statistics, the date
and time when the last invocation of RUNSTATS updated the statistics. The default value is
'0001-01-01-00.00.00.000000'. The default value indicates that statistics were not collected.
This is an updatable column.