SYSKEYTARGETS_HIST catalog table
The SYSKEYTARGETS_HIST table contains rows from the SYSKEYTARGETS table. The schema is SYSIBM.
Whenever rows are added or changed in SYSKEYTARGETS, the rows are also written to this table. Rows in this table can be inserted, updated, and deleted.
| Column name | Data type | Description | Use |
|---|---|---|---|
| IXNAME | VARCHAR(128)
NOT NULL |
Name of the index. | G |
| IXSCHEMA | VARCHAR(128)
NOT NULL |
Qualifier of the index. | G |
| KEYSEQ | SMALLINT
NOT NULL |
Numeric position of the key-target in the index. | G |
| TYPESCHEMA | VARCHAR(128)
NOT NULL |
Schema of the data type. | G |
| TYPENAME | VARCHAR(128)
NOT NULL |
Name of the data type. | G |
| DATATYPEID | INTEGER
NOT NULL |
The internal ID of the data type. The DATATYPEID value corresponds to one of the SQLTYPE values in SQLTYPE and SQLLEN. However, the DATATYPEID value is not a reliable indicator of the nullability of the column. A column with an even DATATYPEID value might allow nulls, and a column with an odd DATATYPEID value might not allow nulls. To determine the nullability of the column, use the NULLS column value. |
G |
| SOURCETYPEID | INTEGER
NOT NULL |
For a built-in data type, this field contains 0. For a distinct type, this field contains the internal ID of the built-in type on which the distinct type is based. | G |
| LENGTH | SMALLINT
NOT NULL |
The length attribute of the key-target or its precision
for a decimal key-target. The number does not include the internal
prefixes that are used to record the actual length and null states,
when applicable.
|
G |
| LENGTH2 | INTEGER
NOT NULL |
The maximum length of the data that is retrieved
from the column. Possible values include the following values:
|
G |
| SCALE | SMALLINT
NOT NULL |
The
scale of decimal data or number of fractional second digits of timestamp
or timestamp with time zone data. Otherwise the value is 0. If the column is a timestamp type, the LENGTH is 10 and the SCALE is 0, the number of fractional second digits is 6. |
G |
| NULLS | CHAR(1)
NOT NULL |
Whether the key can contain null values:
|
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 |
| STATSTIME | TIMESTAMP
NOT NULL WITH DEFAULT |
|
G |
| CARDF | FLOAT
NOT NULL WITH DEFAULT -1 |
The estimated number of distinct values for the key-target. The value is -2 if the index is a node ID index. For an XML value index, the statistic is collected for the second key target (the DOCID column). For all other key targets of the XML value index, a value of -2 is set. | G |
| HIGH2KEY | VARCHAR(2000)
NOT NULL WITH DEFAULT FOR BIT DATA |
The second highest key-value. | G |
| LOW2KEY | VARCHAR(2000)
NOT NULL WITH DEFAULT FOR BIT DATA |
The second lowest key-value. | G |
| STATS_FORMAT | CHAR(1)
NOT NULL WITH DEFAULT |
The type of statistics that are gathered:
|
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.