Option DSP. Database Structures with Plans and Packages
When you select option DSP, the Database Structures panel shows plans and packages that are dependent on the table spaces, tables, views, indexes, aliases, and synonyms.
Select option DSP on the System Catalog panel to display the Database Structures panel, as shown in the following figure, that includes showing the plans and packages that are dependent on the table spaces, tables, views, indexes, aliases, and synonyms.
In the Database Structures 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.
You
must enter a value in the Name field prior to selecting the DSP option.
Otherwise, you will receive the message, Invalid for this
option
.
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