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.

Table 1. SYSIBM.SYSPACKDEP table column descriptions
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: If BNAME identifies a table space (BTYPE is R), the value is the name of its database. If BNAME identifies a table on which a period is defined (BTYPE is W or Z), the value is the qualifier of that table. If BNAME identifies user-defined function, a cast function, a stored procedure, or a sequence (BTYPE is F, O, or Q), the value is the schema name. If BNAME identifies a role, the value is blank. Otherwise, the value is the schema of BNAME.	G
BTYPE	CHAR(1) NOT NULL	Type of object identified by BNAME and BQUALIFIER: A Alias E INSTEAD OF trigger F User-defined function or cast function H Global variable G Global temporary table I Index M Materialized query table O Stored procedure P Partitioned table space if it is defined as LARGE or with the DSSIZE parm Q Sequence object R Table space S Synonym T Table U User-defined type, which is a distinct type or an array type. V View W SYSTEM_TIME period Z BUSINESS_TIME period 0 (zero) Sequence alias	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: The level as specified by the LEVEL option when the package's program was precompiled The timestamp indicating when the package's program was precompiled, in an internal format.	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: F Compiled SQL scalar function N Native SQL routine package O Original copy of a package P Previous copy of a package R Reserved for IBM® use T Trigger package for a basic trigger blank Not a trigger package or a native SQL routine package 1 Trigger package for an advanced trigger	G
DOWNERTYPE	CHAR(1) NOT NULL WITH DEFAULT	Indicates the type of owner of the package: blank Authorization ID L Role	G
COPYID	INTEGER NULLABLE	The copy ID of the package.	G