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
──────────────────────────────────────────────────────────────────────────────
ZDT/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:
- 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 |
|---|---|
| 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 |