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:
  1. The system option, Show all catalog table columns, affects which columns ZDT/Db2 displays when you use the Object List utility.
  2. 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
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

Related tasks

Related references