Option H. Schemas

The Schemas (ADB21H) panel displays the schemas in the Db2 catalog.

To display the Schemas (ADB21H) panel, on the System Catalog (ADB21) panel, select option H.

Figure 1. Schemas (ADB21H) panel

ADB21H in                       DC1A Schemas               Row 1 to 9 of 1,000 
                                                                               
Line commands:                                                                 
 T - Tables  X - Indexes  V - Views  AL - Aliases                              
 E - Types    F - Functions  J - Triggers  O - Procedures  A - Auth            
 GR - Grant  GEN - Generate DDL  REP - Report  Q - Sequences  GV - Variables   
 ? - Show all line commands                                                          
                                                                               
                No.    No.    No.    No.   No.   No.   No.   No.   No.   No.   
S   Schema   Tables Indexs  Views Aliass Types Funcs Procs  Trig  Seqs  Vars   
    *             *      *      *      *     *     *     *     *     *     *   
--- -------> ------ ------ ------ ------ ----- ----- ----- ----- ----- -----   
     HLO ISP      1      0      0      1     0     0     0     0     0     0   
     TSEVG        1      0      0      0     0     0     0     0     0     0   
    ##T          10     10      0      0     0     0     0     0     0     0   
    #AD6867S      2      2      0      0     0     0     0     0     0     0   
    #ASUIVPY      2      2      0      0     0     0     0     0     0     0   
    #DB2IVP0      3      3      0      0     0     0     0     0     0     0   
    #DB2IVPA     12     13      0      0     0     0     0     0     1     0   
    #DB2IVPR      2      1      0      0     0     0     0     0     0     0   
    #DB2IVPW      2      1      0      0     0     0     0     0     0     0

Panel columns

This panel includes the following columns:

S: An input field where you can enter one of the line commands that are listed on the panel.
Schema: The schema of the objects.
No. Tables: The number of tables that are defined in this schema.
No. Indexs: The number of indexes that are defined in this schema.
No. Views: The number of views that are defined in this schema.
No. Aliass: The number of aliases that are defined in this schema.
No. Types: The number of distinct data types that are defined in this schema.
No. Funcs: The number of user-defined functions and implicitly-defined functions that are defined in this schema.
No. Procs: The number of stored procedures that are defined in this schema.
No. Trig: The number of table triggers that are defined in this schema.
No. Seqs: The number of sequences that are defined in this schema.
No. Vars: The number of variables that are defined in this schema.

Panel line commands

The following line commands are valid on this panel:

T: Display the tables in the schema.
X: Display the indexes in the schema.
V: Display the views in the schema.
AL: Display the aliases in the schema.
E: Display the data types in the schema.
F: Display the functions in the schema.
J: Display the triggers in the schema.
O: Display the procedures in the schema.
A: Display schema authorizations.
GR: Grant privileges on the schema.
GEN: Generate DDL for the schema. The number of objects processed by GEN might not match the number of objects displayed. For example, functions with CAST_FUNCTION=Y are not processed by GEN.
REP: Generate a report from the Db2 catalog.
Q: Display the sequences in the schema.
GV: Display the global variables in the schema.
CP: Set copy privileges.