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

Related tasks

Related references