Defining aliases to access the product tables

Before you can transmit data to BMC AMI zAdviser, you must define aliases for the product tables. 

To define aliases to access the product tables

Use the following procedure to define the aliases:

1. In an ISPF editor, edit the DB2ssid1 member located in userhlq.UBMCCNTL, where ssid is your Db2 subsystem ID.
2. On the Command line, enter Find 'AINCDFPE'
   • If 'AINCDFPE' is found, proceed to Step 8.
   • If 'AINCDFPE' is not found, proceed to the next step.
3. On the Command line, enter Find 'END OF SET VARIABLES'

4. Before the previous //*---------------------- line, insert the following section: 

   //*------------------------------------------------------------------*
   //* AIN for Db2                                                       
   //*    Alias Creator                                                  
   // SET DINALCR=AIN131                                                 
   //*    PACKAGE COLLECTION ID                                          
   //* VSET DINCLID=AIN131_D_MAIN                                        
   //*    AIN Plan                                                       
   // SET DINZPLAN=AINZ131
5. On the Command line, enter Find 'SUPPLIED WORKLIST' LAST

6. Replicate the product upgrade member block. The following figure is a sample, so your line numbers might vary: 

   RR     //*********************************************************************
   000567 //* RUN UTLCDFPE SUPPLIED WORKLIST                                    *
   000568 //*********************************************************************
   000569 //UTLCDFPE EXEC JCLINST,COND=(4,LT),                                   
   000570 //             INITMEM=UTLCDFPE,                                       
   000571 //             INSTDSN=RTEHLQ.BMCINST                          
   000572 //E1 EXPORT SYMLIST=(DVIPLAN)                                          
   000573 //S1 SET    DVIPLAN=AINID1                                             
   000574 //EXECWL.UTILPARM DD *,SYMBOLS=JCLONLY                                 
   000575   INSTALL BMCADMIN                                                     
   000576   PLAN AINID1                                                          
   000577   LINES 60 STATS NOSQLCOMP                                             
   000578   IGNOREDUPCREATE                                                      
   RR     //*

7. In the replicated block, identify the supplied worklist member name. For example, in the following sample, UTLCDFPE is the supplied worklist member name. Replace the three occurrences of this worklist member name with AINCDFPE, as shown in the following example: 

   000566 //*********************************************************************
   000567 //* RUN UTLCDFPE SUPPLIED WORKLIST                                    *
   000568 //*********************************************************************
   000569 //UTLCDFPE EXEC JCLINST,COND=(4,LT),                                   
   000570 //             INITMEM=UTLCDFPE,                                       
   000571 //             INSTDSN=RTEHLQ.BMCINST                          
   000572 //E1 EXPORT SYMLIST=(DVIPLAN)                                          
   000573 //S1 SET    DVIPLAN=AINID1                                             
   000574 //EXECWL.UTILPARM DD *,SYMBOLS=JCLONLY                                 
   000575   INSTALL BMCADMIN                                                     
   000576   PLAN AINID1                                                          
   000577   LINES 60 STATS NOSQLCOMP                                             
   000578   IGNOREDUPCREATE                                                      
   000579 //*                                                                    
   '''''' //*********************************************************************
   '''''' //* RUN AINCDFPE SUPPLIED WORKLIST                                    *
   '''''' //*********************************************************************
   '''''' //AINCDFPE EXEC JCLINST,COND=(4,LT),                                   
   '''''' //             INITMEM=AINCDFPE,                                       
   '''''' //             INSTDSN=RTEHLQ.BMCINST                          
   '''''' //E1 EXPORT SYMLIST=(DVIPLAN)                                          
   '''''' //S1 SET    DVIPLAN=AINID1                                             
   '''''' //EXECWL.UTILPARM DD *,SYMBOLS=JCLONLY                                 
   ''''''   INSTALL BMCADMIN                                                     
   ''''''   PLAN AINID1                                                          
   ''''''   LINES 60 STATS NOSQLCOMP                                             
   ''''''   IGNOREDUPCREATE                                                      
   '''''' //*                  
8. Save the JCL and then submit it.