Option L. Collections
The Collections (ADB21L) panel displays information from the Db2® catalog about collections. A collection is a group of associated packages. To display this panel, select option L on the System Catalog (ADB21) panel.
The following figure shows an example of this panel:
DB2 Admin ------------------ DB2X Collections -------------------- Row 1 of 27
Command ===> Scroll ===> PAGE
Line commands:
K - Packages in collection PL - Package lists P - Local plans CL - Clean up
A - Authorizations GR - Grant SQ - SQL in packages in collection
? - Show all line commands
Number of
S Collection Packages
* *
---- -----------------> -----------
ADBL 6
ADBL21 11
ADBL31 7
ADBV3 3
ADB21 1
DSNEDCL 1
DSNESPCS 1
DSNESPRR 1
DSNHYCRDRDRDABRAGG 1
DSNREXCS 1
DSNREXRR 1
DSNREXRS 1
DSNREXUR 1
DSNREXX 1
DSNTEP2 1
******************************* END OF DB2 DATA *******************************
Columns
This panel displays the following columns:
- S
- Input field where you can enter one of the line commands listed on the panel. Enter a question mark (?) on a row to view all valid line commands.
- Collection
- The name of the package collection.
- Number of Packages
- The number of packages in the collection.