DBPedias

All your database knowledge are belong to you

DB2 zOS

SYSIBM.SYSPACKDEP (V8)

Description: Records the dependencies of packages on local tables, views, synonyms, table spaces, indexes, aliases, functions, and stored procedures.

Tablespace: SYSPKAGE

Indexes(Fields):
DSNKDX01(DLOCATION.DCOLLID.DNAME.DCONTOKEN)
DSNKDX02(BQUALIFIER.BNAME.BTYPE)
DSNKDX03(BQUALIFIER.BNAME.BTYPE.DTYPE)

Column name Description Data type
BNAME The name of an object that a package depends on.
NOT NULL
BQUALIFIER 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 user-defined function, a cast function, a stored procedure, or a sequence (BTYPE is F, O, or Q), the value is the schema name.
  • Otherwise, the value is the authorization ID of the owner of BNAME.

NOT NULL
BTYPE Type of object identified by BNAME and BQUALIFIER: ; A
Alias
F
User-defined function or cast function
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

NOT NULL
DLOCATION Always contains blanks
NOT NULL
DCOLLID Name of the package collection.
NOT NULL
DNAME Name of the package.
NOT NULL
DCONTOKEN 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.

NOT NULL WITH
DEFAULT
FOR BIT DATA
IBMREQD A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
NOT NULL
DOWNER Owner of the package.
NOT NULL WITH
DEFAULT
DTYPE Type of package: ; T
Trigger package
blank
Not a trigger package

NOT NULL WITH
DEFAULT

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).

Retrieved from "http://dbpedias.com/w/index.php?title=DB2_zOS:SYSIBM.SYSPACKDEP_(V8)&oldid=21998"