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
──────────────────────────────────────────────────────────────────────────────
FM/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 FM/Db2 displays when you use the Object List utility.
- You can also customize which columns FM/Db2 displays when you use the Object List utility. For details, see the File Manager 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 |