Option Y. Synonyms

The Synonyms (ADB21Y) panel displays information from the Db2® catalog about synonyms. To display this panel, select option Y on the System Catalog (ADB21) panel.

The following figure shows an example of this panel:

Figure 1. Synonyms (ADB21Y) panel

 DB2 Admin -------------------- DB2X Synonyms -------------------- Row 17 of 47 
 Command ===>                                                  Scroll ===> PAGE 
                                                                                
  Line commands:                                                                 
  T - Table  CRE - Create synonym  DROP - Drop synonym  I - Interpretation      
  CREAL - Create alias  D - Database  REP - Report   ALT - Redefine synonym
  ? - Show all line commands     
                                                                                                                                                                
 Select  Synonym            Owner    Table/View         Table/View     Created By
                                     Name               Schema                   
          *                  *        *                  *             *         
 ------- ------------------ -------- ------------------ ------------- --------  
         DEMO_UNICODE       DSCGDB2  DEMO_UNICODE       DSN8810       ISTJE     
         DEPT               DSCGDB2  DEPT               DSN8810       ISTJE     
         EMP                DSCGDB2  EMP                DSN8810       ISTJE     
         EMPPROJACT         DSCGDB2  EMPPROJACT         DSN8810       ISTJE     
         PROJ               DSCGDB2  PROJ               DSN8810       ISTJE     
         PROJACT            DSCGDB2  PROJACT            DSN8810       ISTJE     
         TCONA              DSCGDB2  TCONA              DSN8810       ISTJE     
         TDSPTXT            DSCGDB2  TDSPTXT            DSN8810       ISTJE     
         TOPTVAL            DSCGDB2  TOPTVAL            DSN8810       ISTJE     
         VACT               DSCGDB2  VACT               DSN8810       ISTJE     
         VASTRDE1           DSCGDB2  VASTRDE1           DSN8810       ISTJE     
         VASTRDE2           DSCGDB2  VASTRDE2           DSN8810       ISTJE  
         VCONA              DSCGDB2  VCONA              DSN8810       ISTJE  
         VDEPMG1            DSCGDB2  VDEPMG1            DSN8810       ISTJE  
         VDEPT              DSCGDB2  VDEPT              DSN8810       ISTJE  
         VDSPTXT            DSCGDB2  VDSPTXT            DSN8810       ISTJE  
         VEMP               DSCGDB2  VEMP               DSN8810       ISTJE  
         VEMPDPT1           DSCGDB2  VEMPDPT1           DSN8810       ISTJE  
         VEMPLP             DSCGDB2  VEMPLP             DSN8810       ISTJE  
         VEMPPROJACT        DSCGDB2  VEMPPROJACT        DSN8810       ISTJE  
         VFORPLA            DSCGDB2  VFORPLA            DSN8810       ISTJE  
         VHDEPT             DSCGDB2  VHDEPT             DSN8810       ISTJE  
         VOPTVAL            DSCGDB2  VOPTVAL            DSN8810       ISTJE  
         VPHONE             DSCGDB2  VPHONE             DSN8810       ISTJE  
         VPROJ              DSCGDB2  VPROJ              DSN8810       ISTJE  
         VPROJACT           DSCGDB2  VPROJACT           DSN8810       ISTJE  
         VPROJRE1           DSCGDB2  VPROJRE1           DSN8810       ISTJE  
         VPSTRDE1           DSCGDB2  VPSTRDE1           DSN8810       ISTJE  
         VPSTRDE2           DSCGDB2  VPSTRDE2           DSN8810       ISTJE  
         VSTAFAC1           DSCGDB2  VSTAFAC1           DSN8810       ISTJE  
         VSTAFAC2           DSCGDB2  VSTAFAC2           DSN8810       ISTJE  
 ******************************* END OF DB2 DATA *******************************

Columns

This panel displays the following columns:

Select: 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.
Synonym: Synonym for the table or view.
Owner: Authorization ID of the owner of the synonym.
Table/View Name: Name of the table or view.
Table/View Schema: The schema of the table or view.
Created By: Primary authorization ID of the user who created the synonym.