System catalog panels

The main system catalog panels are described in this reference information.

The System Catalog (ADB21) panel
Use the System Catalog (ADB21) panel to search for Db2 objects or authorizations in the Db2 catalog. To display this panel, select option 1 on the DB2 Administration Menu (ADB2) panel.
Option A. Aliases
Use the Aliases panel to display information about the aliases in the Db2 catalog.
Option C. Columns
The Columns panel displays the columns in the Db2 catalog.
Option D. Databases
The Databases (ADB21D) panel displays the databases in the Db2 catalog.
Option DS. Database Structures
When you select option DS, the Database Structures panel displays a structured list of objects in the database that you have selected but does not display plans and packages.
Option DSP. Database Structures with Plans and Packages
When you select option DSP, the Database Structures panel shows plans and packages that are dependent on the table spaces, tables, views, indexes, aliases, and synonyms.
Option E. User-Defined Data Types
Use the Data Types panel to display information about the data types in the Db2 catalog.
Option F. Functions
Use the Functions panel to display information about the functions in the Db2 catalog.
Option G. Storage Groups
The Storage Groups panel displays the storage groups in the Db2 catalog.
Option GV. Global Variables
Use the Global Variables panel to display information about the global variables in the Db2 catalog.
Option H. Schemas
The Schemas (ADB21H) panel displays the schemas in the Db2 catalog.
Option J. Triggers
Use the Triggers panel to display information about the triggers in the Db2 catalog.
Option K. Packages
The Packages (ADB21K) panel displays the packages in the Db2 catalog.
Option L. Collections
The Collections (ADB21L) panel displays the collections that are recorded in the Db2 catalog. A collection is a group of associated packages.
Option N. Constraints
The Constraints panel displays the constraints on a table in the Db2 catalog.
Option O. Stored Procedures
Use the Stored Procedures panel to display information about the stored procedures in the Db2 catalog.
Option P. Plans
The Application Plans (ADB21P) panel displays the application plans in the Db2 catalog.
Option PDC. DB2 Pending Definition Changes
Use the DB2 Pending Definition Changes panel to display information about the definition changes that are pending in the Db2 catalog.
Option Q. Sequences
The Sequence Objects panel displays the sequences in the Db2 catalog.
Option RS. REST Services
The REST Services (ADB21RS) panel displays information about Db2 REST services.
Option S. Table Spaces
The Table Spaces (ADB21S) panel displays the table spaces in the Db2 catalog.
Option T. Tables, Views, and Aliases
The Tables, Views, and Aliases (ADB21T) panel displays the tables, views, and aliases in the Db2 catalog.
Option TR. Trusted Contexts
To display trusted contexts choose the TR option on the System Catalog panel.
Option V. Views
The Views (ADB21VV) panel displays information about views, including whether the view uses multiple tables in different databases or table spaces. Alternatively, you can see information about views on the Tables, Views, and Aliases (ADB21T) panel. However, that panel does not show whether multiple databases or table spaces are used by the view.
Option X. Indexes
The Indexes (ADBADB25C21X) panel displays the indexes in the Db2 catalog.
Option XCU. Index Cleanup
Use the Index Cleanup panel to display information about index cleanup activities in the Db2 catalog.
Option Y. Synonyms
The Synonyms panel displays the synonyms in the Db2 catalog.
Option AO. Authorization options
Use the System Catalog (ADB21) panel - Authorization options to manage authorizations for objects in the Db2 catalog.

Parent topic: Db2 Admin Tool panels