Databases panel
You use the Databases panel to list database object types in the Db2® catalog.
Panel and field definitions
The columns that are displayed include the SEL field and columns of SYSIBM.SYSDATABASE.
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) Databases
Location: Format TABL
GROUP+
SEL NAME CREATOR STGROUP BPOOL DBID CREATEDBY TYPEEX MEMBER
* * * * * * * *
---- #1--+--- #2--+--- #3--+----1- #4--+--- ----#5 #7--+---- #20-+--- #11-+-
**** Top of data ****
ABC SHRIKE2 DDDDDDDDDDD BP0 270 SHRIKE2
DSN8D81A CJUNELL DSN8G810 BP0 259 CJUNELL
DSN8D81P CJUNELL DSN8G810 BP0 260 CJUNELL
DSNATPDB CJUNELL SYSDEFLT BP0 257 CJUNELL
DSNDB04 SYSIBM SYSDEFLT BP0 4 SYSIBM
DSNDB06 SYSIBM 6 SYSIBM
DSNDB07 CJUNELL SYSDEFLT BP0 7 CJUNELL WORKFILE
DSNRGFDB CJUNELL SYSDEFLT BP0 258 CJUNELL
DSNRLST CJUNELL SYSDEFLT BP0 256 CJUNELL
FUNTBDB SHRIKES SYSDEFLT BP8K0 271 SHRIKES
JLV3D81A SHRIKES JLV3G810 BP0 266 SHRIKES
Command ===> Scroll PAGE
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Note:
- The system option, Show all catalog table columns, affects which columns ZDT/Db2 displays when you use the Object List utility.
- You can also customize which columns ZDT/Db2 displays when you use the Object List utility. For details, see the Z Data Tools Customization Guide.
To view other columns on this panel, press the Right function key (F11).
For
a complete list of columns, refer to Db2® catalog
tables
in the DB2 for z/OS SQL Reference relevant
to your version of Db2®.
- SEL
- Line command area. For a list of the line commands you can use on this panel, see Object list line commands.
Parent panels
Child panels
To display this panel… | Use/do this |
---|---|
Alter Database panel | Line command A |
Create Database panel | Line command CR |
Create Table Space panel | Line command CRS |
See Drop panels | Line command DR |
Database Structure panel | Line command DS |
Grant privileges panels | Line command G |
Generate SQL From Db2 Catalog panel | Line command GEN |
Details panels | Line command I |
Recovery Information panel | Line command ICS |
Privileges panels | Line command P |
Revoke privileges panels | Line command R |
Display Row panel | Line command ROW |
Table Spaces panel | Line command S |
Tables, Views and Aliases panel | Line command T |
Indexes panel | Line command X |
Sort Fields panel | Primary command SORT |