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.
The following figure shows the Database Structures panel
with plans and packages displayed.