SYSPLANDEP catalog table

The SYSPLANDEP table records the dependencies of plans on tables, views, aliases, synonyms, table spaces, indexes, functions, and stored procedures. The schema is SYSIBM.

Table 1. SYSIBM.SYSPLANDEP table column descriptions
Column name Data type Description Use
BNAME
VARCHAR(128)
NOT NULL
 The name of an object the plan depends on. G
BCREATOR
VARCHAR(128)
NOT NULL
 If BNAME is a table space, its database. Otherwise, the schema of BNAME. If BNAME is a role, the value is blank. G
BTYPE
CHAR(1)
NOT NULL
 Type of object identified by BNAME:
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
V
View
 G
DNAME
VARCHAR(24)
NOT NULL
 Name of the plan. G
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