SYSLOBSTATS catalog table
The SYSLOBSTATS table contains one row for each LOB table space. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| STATSTIME | TIMESTAMP
NOT NULL |
|
G |
| AVGSIZE | INTEGER
NOT NULL |
Average size of a LOB, measured in bytes, in the LOB table space. | S |
| FREESPACE | INTEGER
NOT NULL |
Number of kilobytes of available 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 |
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.