SYSLOBSTATS_HIST catalog table
The SYSLOBSTATS_HIST table contains rows from SYSIBM.SYSLOBSTATS. The schema is SYSIBM.
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 was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
If RUNSTATS or another utility with inline statistics updated the statistics, the date and time when the last utility invocation updated the statistics. The default value is '0001-01-01-00.00.00.000000'. The default value indicates that statistics were not collected. This column can be updated.