Description: Contains one row for each unique constraint (primary key or unique key) created in DB2 for OS/390 Version 7 or later.

Tablespace: SYSOBJ

Indexes(Fields):
DSNCNX01(TBCREATOR.TBNAME.CONSTNAME)
DSNCNX02(IXOWNER IXNAME)

Column name Description Data type
CONSTNAME Name of the constraint.
VARCHAR(128)
NOT NULL
TBCREATOR Authorization ID of the owner of the table on which the constraint is defined.
VARCHAR(128)
NOT NULL
TBNAME Name of the table on which the constraint is defined.
VARCHAR(128)
NOT NULL
CREATOR Authorization ID under which the constraint was created.
VARCHAR(128)
NOT NULL
TYPE Type of constraint:
P
Primary key
U
Unique key
CHAR(1)
NOT NULL
IXOWNER Owner of the index enforcing the constraint or blank if index has not been created yet.
VARCHAR(128)
NOT NULL
IXNAME Name of the index enforcing the constraint or blank if index has not been created yet.
VARCHAR(128)
NOT NULL
CREATEDTS Time when the statement to create the constraint was executed.
TIMESTAMP
NOT NULL
IBMREQD A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
COLCOUNT Number of columns in the constraint.
SMALLINT
NOT NULL

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).