Collections panel

You use the Collections panel list to list collections in the Db2® catalog.

Panel and field definitions

The columns that are displayed include the SEL field and columns of SYSIBM.SYSPACKAGES.

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                     Collections
 Location:                                                          Format TABL

                              PKG
 SEL    COLLID              COUNT
        *                       *
 ----   #2--+----1----+--- ----#4
 ****  Top of data  ****
        DSNACCOR                1
        DSNAOCLI                9
        DSNASPCC               12
        DSNEDCL                 1
        DSNESPCS                1
        DSNESPRR                1
        DSNESPRR$$$$$$$$$$      1
        DSNHYCRD                1
        DSNJAR                  8
        DSNREXCS                1
        DSNREXRR                1
 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
Grant privileges panels Line command G
Privileges panels Line command P
Application Packages panel Line command PKG
Package List panel Line command PKL
Application Plans panel Line command PL
Revoke privileges panels Line command R
Display Row panel Line command ROW
(ISPF panel) Line command SQL
Sort Fields panel Primary command SORT

Related tasks

Related references