Description: Contains one or more rows for every local application plan bound with a package list. Each row represents a unique entry in the plan's package list.
Tablespace: SYSPKAGE
Indexes(Fields):
DSNKLX01(LOCATION.COLLID.NAME)
DSNKLX02(PLANNAME.SEQNO.LOCATION.COLLID.NAME)
| Column name | Description | Data type |
|---|---|---|
| PLANNAME | Name of the application plan. | NOT NULL |
| SEQNO | Sequence number of the entry in the package list. | NOT NULL |
| LOCATION | Location of the package. Blank if this is local. An asterisk (*) indicates location to be determined at run time. | NOT NULL |
| COLLID | Collection name for the package. An asterisk (*) indicates that the collection name is determined at run time. | NOT NULL |
| NAME | Name of the package. An asterisk (*) indicates an entire collection. | NOT NULL |
| TIMESTAMP | Timestamp indicating when the row was created. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).