Global Index Interface

Control‑V uses the Global Index interface (CTDGID) module to retrieve information from DB2. The DB2 application plan for this module should be created from the CTDGID DBRM module included in the IOA SAMPLE library. The DB2 application plan should be authorized for users running the IOA application server and executing the CTVGICL utility.

The CTDGBBPL member in the CTD JCL library is a sample job for binding DBRM to a DB2 application plan and authorizing this plan to all users. An example of this job is shown in the following code:

Figure 64 CTDGBBPL Member Sample Job

//* BIND PLAN                                        

//DSNBIND EXEC PGM=IKJEFT01,DYNAMNBR=20              

//SYSTSPRT DD  SYSOUT=*                              

//SYSPRINT DD  SYSOUT=*                              

//SYSUDUMP DD  SYSOUT=*                              

//SYSTSIN  DD  *                                     

 DSN SYSTEM(DSN1)                                    

 BIND PLAN(CTDGIPL6) MEM(CTDGID)ACT(REP)ISOLATION(CS)-

   LIB('%ILPREFA%.SAMPLE')                           

 END                                                 

//* AUTHORIZATION TO ALL USERS                       

//DSNGRAN EXEC PGM=IKJEFT01,DYNAMNBR=20              

//DBRMLIB  DD DSN=IOAP.V900.SAMPLE,DISP=SHR          

//SYSTSPRT DD SYSOUT=*                               

//SYSPRINT DD SYSOUT=*                               

//SYSUDUMP DD SYSOUT=*                               

//SYSIN   DD *                                       

 GRANT EXECUTE ON PLAN CTDGIPL6 TO PUBLIC            

//SYSTSIN DD *                                       

 DSN SYSTEM(DSN1)                                    

 RUN PROGRAM(DSNTEP2) PLAN(DSNTEP61) -               

   LIB('DSN610.RUNLIB.LOAD')                         

 END                                                 

//