SYSKEYS catalog table

The SYSKEYS table contains one row for each column of an index key. The schema is SYSIBM.

Table 1. SYSIBM.SYSKEYS table column descriptions
Column name	Data type	Description	Use
IXNAME	VARCHAR(128) NOT NULL	Name of the index.	G
IXCREATOR	VARCHAR(128) NOT NULL	Schema or qualifier of the index.	G
COLNAME	VARCHAR(128) NOT NULL	Name of the column of the key.	G
COLNO	SMALLINT NOT NULL	Numeric position of the column in the table. For example, 4 (out of 10).	G
COLSEQ	SMALLINT NOT NULL	Numeric position of the column in the key for an index on columns. For example, 4 (out of 4). The value is meaningless for an expression-based index.	G
ORDERING	CHAR(1) NOT NULL	Order of the column in the key: blank Index is an expression-based index or the column is specified for the index using the INCLUDE clause A Ascending order D Descending order R Random order	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
PERIOD	CHAR(1) NOT NULL WITH DEFAULT	Indicates whether the column is the start or end column for the BUSINESS_TIME period: B The column is the start of the period BUSINESS_TIME. C Column is the end of period BUSINESS_TIME with an exclusive end point. I Column is the end of period BUSINESS_TIME with an inclusive end point. blank Column is not used as either the start or the end of a BUSINESS_TIME period, or the index is not used as an enforcing index.	G
CREATEDTS	TIMESTAMP(12) NOT NULL WITH DEFAULT	Time when the CREATE statement was executed for the index.	G