SYSLOBSTATS_HIST catalog table

The SYSLOBSTATS_HIST table contains rows from SYSIBM.SYSLOBSTATS. The schema is SYSIBM.

Rows are added or changed in the SYSLOBSTATS_HIST catalog table when RUNSTATS collects history statistics. Rows in this table can also be inserted, updated, and deleted.

Table 1. SYSIBM.SYSLOBSTATS_HIST table column descriptions
Column name Data type Description Use
STATSTIME
TIMESTAMP
NOT NULL

Start of changeIf 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.End of change

 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