Description: Records the dependencies of identity columns and sequences.
Tablespace: SYSSEQ2
Indexes(Fields):
DSNSRX01(DCREATOR.DNAME.DCOLNAME)
DSNSRX02(BSCHEMA.BNAME.DTYPE)
| Column name | Description | Data type |
|---|---|---|
| BSEQUENCEID | Internal identifier of the identity column or sequence. | NOT NULL |
| DCREATOR | The owner of the object that is dependent on this identity column or sequence. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
| DNAME | Name of the object that is dependent on this identity column or sequence. | NOT NULL |
| DCOLNAME | Name of the identity column. Blank for SQL function rows. | NOT NULL |
| DTYPE | The type of object that is dependent on this sequence: ; F
|
NOT NULL WITH DEFAULT 'I' |
| BSCHEMA | The schema name of the sequence, will be a string of length zero for an object created prior to Version 8. | NOT NULL WITH DEFAULT |
| BNAME | The sequence name (generated by DB2 for an identity column), will be a string of length zero for an object created prior to Version 8. | NOT NULL WITH DEFAULT |
| DSCHEMA | The qualifier of the object that is dependent on this sequence, will be a string of length zero for an object created prior to Version 8. | NOT NULL WITH DEFAULT |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).