Description: Contains rows from 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.
Tablespace: SYSHIST
Indexes(Fields):
DSNHJX01(DBNAME.NAME.STATSTIME)
| Column name | Description | Data type |
|---|---|---|
| STATSTIME | Timestamp of RUNSTATS statistics update. | NOT NULL |
| FREESPACE | Number of pages of free space in the LOB table space. | NOT NULL |
| ORGRATIO | 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.00 indicates that the LOB table space is totally disorganized. An empty LOB table space will have a value of 100.00 | NOT NULL |
| DBNAME | Name of the database that contains the LOB table space named in NAME. | NOT NULL |
| NAME | Name of the LOB table space. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL WITH DEFAULT 'N' |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).