Accessing Catalog Manager functions

To start Catalog Manager from the BMC Software Administrative Products for Db2 panel

1. On the Command line, type the number that corresponds to the 

   BMC AMI Catalog Manager for Db2

    option.

2. In the DB2 SSID field, type the SSID or group attach name to which you want to attach.

   Important

   You cannot specify the same SSID as the group SSID that is used for data sharing in a sysplex.

3. In the DB2 Catalog Access field, type the method to be used to attach to the Db2 subsystem:

   • DIRECT indicates that you attach directly to a real subsystem.

     If the Db2 SSID to which you are attaching uses an ASCII encoding scheme, you must use the DIRECT method.

   • INDIRECT indicates that you attach to an installed copy of the specified subsystem catalog.
4. In the Use Shared or Individual product ISPF APPLID field, specify one of the following types of ISPF Application IDs (APPLID):
   • To specify an APPLID for each Db2 subsystem, type S (shared).
   • To specify an APPLID for each product, type I (individual).

5. Press Enter.The Catalog Manager Primary Menu panel is displayed below.

    ACTPMAIX ----  BMC AMI Catalog Manager for Db2 13.01.00  Primary Menu  -------
    Command ===>                                                                   
                                                                                  
    Select Action and List information                                             
    Action       0 List          3 Grant          6 Log Maint                      
                 1 Search        4 Options        7 SQL                            
                 2 Create        5 DB2 Commands   8 About this release             
                                                                                  
    Obj type  TB                 Attached to DEMO                                  
    Qualifier M%.%                                                                 
                                                                       More:     +
    ACC      Accelerators      ACCPG    Acc Packages      ACCTB    Acc Tables      
    AL       Aliases           APO      Audit Policies    ARH      SP Hist Results
    ATS      SP Stat Alerts    ATW      SP Time Windows   BMCHOBJ  BMC Util HistObj
    BMCHSTEP BMC Util HistStep BMCUTIL  Display BMC Utils BP       Buffer Pool Priv
    CA       Column Auth       CD       Check Const Dep   CI       Collection IDs  
    CK       Check Constraints CL       Column Labels     CO       Columns         
    COLSTATS Column Stats      CP       Constraint Dep    CX       Trusted Context
    CXA      Trusted Ctxt Aut  CXT      Trusted Ctxt Attr C2       Check Const > V7
    DB       Databases         DISTSTAT Column Dist Stats DISUTIL  Display DB2 Util
    DM       DBRMs             DQ       Dyn Query         DS       Data Sets       
    DSU      Data Sets Unique  DT       Data Types        EN       Environments    
    FK       Foreign Keys      FN       Functions         FO       Function Options
    FP       Function Parms    FS       SQL Procedure Src IC       Image Copies    
    IL       IP Addr Loc(DDF)  IN       IP Names          IP       Index Partitions
    IS       Index Spaces      ISS      Index Space Stats IX       Indexes         
    IXC      Index Cleanup     INDEXSTA Index Stats       JB       Installed JAR Ob
    JC       Java Class        JP       JAR Build Option  JT       Java Paths      
    KC       Key Columns       KT       Key Targets       KTD      Key Tgt Dist    
    KTDH     Key Tgt Dist His  KTDS     Key Tgt Dist Stat KTH      Key Target Hist
    KTS      Key Target Stats  KU       Constraint Keycol LK       Limit Keys      
    LL       Logical Unit      LM       LUNAMEs and MODE  LO       Remote locations
    LS       SQL Mode Names    LU       LUNAMEs           LVL      Level Updates   
    MK       Column Masks      MQ       MQTs              NP       Native Procedure
    OB       Online Schema Chg OEV      Obj Events        OS       LOB Statistics  
    PA       Plan Auth         PDD      Pending DDL       PDISTSTA Part Dist Stats
    PG       Packages          PGC      Package Copies    PI       Packlist        
    PK       Primary Keys      PL       Plans             PM       Row Permissions
    PR       Procedures        PS       Packstmt          PSD      Packstmtdep     
    PT       Partitions        QRY      Queries           RD       Role Dep        
    RE       Referential Const RO       Object Roles      SC       Schemas         
    SE       Sequence ID Cols  SG       Storage Groups    SSR      SmartSwitch Rule
    SST      SmartSwitch Trk   ST       Strings           STATUS   IBM and BMC Util
    SU       System Privileges SVC      Services          SY       Synonyms        
    TABSTATS Table Stats       TB       Tables            TBP      Table Profiles  
    TC       Table Constraint  TN       Table Names       TP       Table Space Part
    TR       Triggers          TS       Table Spaces      TSS      Table Space Stat
    UA       User Auth         UN       User Names        US       Users           
    USN      US by names       UTL      Utilities         VAR      Variables       
    VW       Views             XC       Cabinet Copies    XR       XML Relationship

   The Catalog Manager Primary Menu panel is your starting point for accessing the many functions and features of Catalog Manager.

This section contains the following topics: