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
Start of change
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
End of change

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.
Start of changeNo. TablesEnd of change
Start of changeThe number of tables that are defined in this schema.End of change
Start of changeNo. IndexsEnd of change
Start of changeThe number of indexes that are defined in this schema.End of change
Start of changeNo. ViewsEnd of change
Start of changeThe number of views that are defined in this schema.End of change
Start of changeNo. AliassEnd of change
Start of changeThe number of aliases that are defined in this schema.End of change
Start of changeNo. TypesEnd of change
The number of distinct data types that are defined in this schema.
Start of changeNo. FuncsEnd of change
The number of user-defined functions and implicitly-defined functions that are defined in this schema.
Start of changeNo. ProcsEnd of change
The number of stored procedures that are defined in this schema.
Start of changeNo. TrigEnd of change
The number of table triggers that are defined in this schema.
Start of changeNo. SeqsEnd of change
The number of sequences that are defined in this schema.
Start of changeNo. VarsEnd of change
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.