Option DSP. Database Structures with Plans and Packages
The Database Structures (ADB21DS) panel displays a structured list of objects in the database that you have selected. To display this panel with plans and packages that are dependent on the table spaces, tables, views, indexes, aliases, and synonyms, select option DSP on the System Catalog (ADB21) panel and enter the database name in the Name field.
The following figure shows an example of this panel with plans and packages. For an example without plans and packages displayed, see Option DS. Database Structures.
DB2 Admin --------------- DB2X Database Structures --------- Row 1 to 35 of 72
Command ===> Scroll ===> PAGE
Line commands: S - Show object DSN - Data sets
PSID/
Sel Type Object Name Qualifier DBID ISOBID OBID Note
* * * * * * *
--- ------ -----------------------> -------- ------ ------ ------ -------------
D----- PJMDBPLN---------------- 375 0 0
S PJS1 PJMDBPLN 375 2 1
T PJS1T1 MARINO 375 0 3
Y PJS1T1Y1 MARINO 0 0 0
K PLISQL PLISQL 0 0 0
K PLISQL PLISQL3 0 0 0
K PLISQL3 PLISQL3 0 0 0
P PLISQLP2 0 0 0
Y PJS1T1Y2 MARINO 0 0 0
K PLISQL PLISQL 0 0 0
K PLISQL PLISQL3 0 0 0
K PLISQL3 PLISQL3 0 0 0
P PLISQLP2 0 0 0
CHK PJCHK1 375 0 20
P PLISQLPL 0 0 0
T PJS1T2 MARINO 375 0 7
ALI PJS1T2A1 MARINO 0 0 0
K PLISQL PLISQL 0 0 0
K PLISQL PLISQL3 0 0 0
K PLISQL3 PLISQL3 0 0 0
P PLISQLP2 0 0 0
X PJS1T2X1 MARINO 375 14 13
MQT PJMMQT1 MARINO 0 0 0
K PLISQL PLISQL 0 0 0
K PLISQL PLISQL3 0 0 0
K PLISQL3 PLISQL3 0 0 0
P PLISQLPM 0 0 0
V PJS1T2V1 MARINO 0 0 0
K PLISQL PLISQL 0 0 0
K PLISQL PLISQL3 0 0 0
K PLISQL3 PLISQL3 0 0 0
P PLISQLP2 0 0 0
P PLISQLP3 0 0 0
V PJS1T2V2 MARINO 0 0 0
T X.F WONG 375 0 17
On this panel, plans (P) and packages (K) are indented under the object upon which they are dependent. To eliminate repetitiveness in the display, a dependency on a table is not shown if it is already reported under a view, alias, synonym, or index for the table. Likewise, a dependency for a table space is not shown if it is already reported under a table.
For a description of the panel columns, see Option DS. Database Structures.