A tabela SYSKEYTARGETS_HIST contém linhas da tabela SYSKEYTARGETS.
O esquema é SYSIBM.
Sempre que linhas são adicionadas ou alteradas em SYSKEYTARGETS, as linhas também são gravadas nesta tabela.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.
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. |
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.
- data type
- value of the LENGTH column
- INTEGER
- 4
- SMALLINT
- 2
- FLOAT
- 4 or 8
- CHAR
- The length of the string
- VARCHAR
- The maximum length of the string
- DECIMAL
- The precision of the number
- GRAPHIC
- The number of DBCS characters
- VARGRAPHIC
- The maximum number of DBCS characters
- DATE
- 4
- TIME
- 3
- TIMESTAMP WITHOUT TIME ZONE
- The integral part of ((p+1)/2) + 7 where p is the precision of the timestamp
- TIMESTAMP WITH TIME ZONE
- The integral part of ((p+1)/2) + 9 where p is the precision of the timestamp
- BIGINT
- 8
- BINARY
- The length of the string
- VARBINARY
- The maximum length of the string
- DECFLOAT
- 8 or 16
|
G |
| LENGTH2 |
INTEGER
NOT NULL |
The maximum length of the data that is retrieved from the column. Possible values include the following values:
- 0
- Not a ROWID column
- 40
- For a ROWID column, the length of the value that is returned
|
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:
- N
- No
- Y
- Yes
|
G |
| IBMREQD |
CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
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 |
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 is an updatable column. |
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:
- N
- VARCHAR column statistical values are not padded
- blank
- Statistics have not been collects or VARCHAR column statistical values are padded
|
G |
