SYSKEYTARGETSTATS catalog table

The SYSKEYTARGETSTATS table contains partition statistics for selected key-targets. For each key-target, a row exists for each partition in the table.

Rows are inserted when RUNSTATS collects indexed key statistics or non-indexed key statistics for a partitioned table space. No row is inserted if the table space is nonpartitioned. Rows in this table can be inserted, updated, and deleted.

Important: Use care when issuing SQL statements or using tools to update statistics values in catalog tables. If such updates introduce invalid data, unpredictable results can occur, including abends for RUNSTATS and other utilities. If such problems occur, you can run the RUNSTATS utility and collect statistics at the table space level to resolve the problems, in most cases.
Table 1. SYSIBM.SYSKEYTARGETSTATS table column descriptions
Column name Data type Description Use
IXSCHEMA
VARCHAR(128)
NOT NULL
 The qualifier of the index. G
IXNAME
VARCHAR(128)
NOT NULL
 The name of the index. G
KEYSEQ
SMALLINT
NOT NULL
 Numeric position of the key-target in the index. G
HIGHKEY
VARCHAR(2000)
NOT NULL
WITH DEFAULT
FOR BIT DATA
 The highest key value. S
HIGH2KEY
VARCHAR(2000)
NOT NULL
WITH DEFAULT
FOR BIT DATA
 The second highest key-value. S
LOWKEY
VARCHAR(2000)
NOT NULL
WITH DEFAULT
FOR BIT DATA
 The lowest key value. S
LOW2KEY
VARCHAR(2000)
NOT NULL
WITH DEFAULT
FOR BIT DATA
 The second lowest key-value. S
PARTITION
SMALLINT
NOT NULL
 The partition number of the table space. G
—
VARCHAR(1000)
NOT NULL
WITH DEFAULT
FOR BIT DATA
 Internal use only. I
STATSTIME
TIMESTAMP
NOT NULL
WITH DEFAULT

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
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
STATS_FORMAT
CHAR(1)
NOT NULL
WITH DEFAULT
 The type of statistics that are gathered:
N
VARCHAR column statistical values are not padded
blank
Statistics have not been collects or VARCHAR column statistical values are padded
 G
CARDF
FLOAT
NOT NULL
WITH DEFAULT -1
 Number of distinct values for the key target. S