Option DS. Database Structures
The Database Structures (ADB21DS) panel displays a structured list of objects in the database that you have selected. To display this panel without plan and package information, select option DS on the System Catalog (ADB21) panel and enter the database name in the Name field.
The following figure shows an example of this panel without plans and packages. For an example with plans and packages displayed, see Option DSP. Database Structures with Plans and Packages.
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 object types are displayed on this 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.
Columns
This panel displays the following columns:
- Sel
- Input field where you can enter one of the line commands listed on the panel. Enter a question mark (?) on a row to view all valid line commands.
- Type
- Type of object, which can be one of the following types:
- 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.
- OBID
- Identifier for the object's internal descriptor.