When you select option DS, the Database Structures panel
displays a structured list of objects in the database that you have
selected but does not display plans and packages.
Select option DS on the System Catalog panel
to display the Database Structures panel, as
shown in the following figure. You must enter a value in the Name
field prior to selecting the DS option. Otherwise, you will receive
the following message: Invalid for this option.
The following object types are displayed on the Database
Structures panel:
Databases
Table spaces
Tables
Materialized query tables
Indexes
Aliases
Views on a table
Synonyms on a table
Triggers
Check conditions
Unique constraints
Referential constraints (parents)
Referential constraints (children)
Views on a view and authorizations are not included in this
display.
The following figure shows the Database Structures panel
without plans and packages displayed.Figure 1. Database Structures panel (ADB21DS) without
plans and packages displayed
DB2 Admin --------------- DB2X Database Structures --------- Row 1 to 35 of 35
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
Y PJS1T1Y2 MARINO 0 0 0
CHK PJCHK1 375 0 20
T PJS1T2 MARINO 375 0 7
ALI PJS1T2A1 MARINO 0 0 0
X PJS1T2X1 MARINO 375 14 13
MQT PJMMQT1 MARINO 0 0 0
V PJS1T2V1 MARINO 0 0 0
V PJS1T2V2 MARINO 0 0 0
T X.F WONG 375 0 17
S PJS2 PJMDBPLN 375 5 4
T PJS2T1 MARINO 375 0 6
ALI PJS2T1A1 MARINO 0 0 0
Y PJS2T1Y1 MARINO 0 0 0
Y PJS2T1YY MARINO 0 0 0
UC PJUCC5 0 0 0 Unique key
X PJS2T1X MARINO 375 21 19
S PJS3 PJMDBPLN 375 9 8
T PJS3T1 MARINO 375 0 10
Y PJS3T1Y1 MARINO 0 0 0
PAR PJS3T1FK 0 0 29
CHK PJCHKX 375 0 18
X PJS3T1X MARINO 375 26 25
X PJS3T1X1 MARINO 375 12 11
V PJS3T1V1 MARINO 0 0 0
V PJS3T1V2 MARINO 0 0 0
S PJS4 PJMDBPLN 375 16 15
S PJS5 PJMDBPLN 375 23 22 Partitioned
T PJS5T1 MARINO 375 0 24
CHR PJS3T1FK 0 0 29
UC C1 0 0 0 Primary key
X PJS5T1X MARINO 375 28 27
******************************* END OF DB2 DATA *******************************
The following columns are on this panel:
Sel
Input field where you enter line command S to show an object.
Type
Type of object, which is one of the following:
ALI
Alias.
CHK
Check constraint.
CHR
Referential constraint: parent to child.
D
Database.
J
Trigger.
K
Package (shown only for the DSP command).
MQT
Materialized query table (treated as a table when preceded by two blanks in the
Type field and as a view when preceded by three blanks).
P
Plan (shown only for the DSP command).
PAR
Referential constraint: child to parent.
S
Table space.
T
Table.
UC
Unique constraint.
V
View.
X
Index.
Y
Synonym.
Object Name
Name of the object.
Qualifier
Db2 qualifier for the
object, if relevant.
DBID
Internal identifier of the database.
PSID/ISOBID
Internal identifier of the table space page set descriptor or index page set descriptor.