SYSPACKDEP catalog table
The SYSPACKDEP table records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, functions, and stored procedures. The schema is SYSIBM.
Access paths for SQL statements might depend on objects that Db2 does not actually use when it processes the selected access paths. Such dependencies are recorded in the SYSPACKDEP catalog table, but they are not shown in EXPLAIN output.
Column name | Data type | Description | Use |
---|---|---|---|
BNAME |
VARCHAR(128)
NOT NULL |
The name of an object that a package depends on. If BTYPE is W or Z, the value is the name of the table on which the period is defined. |
G |
BQUALIFIER |
VARCHAR(128)
NOT NULL |
The value of the column depends on the type of object:
|
G |
BTYPE |
CHAR(1)
NOT NULL |
Type of object identified by BNAME and BQUALIFIER:
|
G |
DLOCATION |
VARCHAR(128)
NOT NULL |
Always contains blanks | S |
DCOLLID |
VARCHAR(128)
NOT NULL |
Name of the package collection. | G |
DNAME |
VARCHAR(128)
NOT NULL |
Name of the package. | G |
DCONTOKEN |
CHAR(8)
NOT NULL FOR BIT DATA |
Consistency token for the package. This is either:
|
S |
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 |
DOWNER |
VARCHAR(128)
NOT NULL WITH DEFAULT |
Owner of the package: | G |
DTYPE |
CHAR(1)
NOT NULL WITH DEFAULT |
Type of package:
|
G |
DOWNERTYPE |
CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of owner of the package:
|
G |
COPYID |
INTEGER
NULLABLE |
The copy ID of the package. | G |