CA InterTest for CICS - DB2 Implementation and SQLCODE -805 or -818.

Document ID : KB000023695
Last Modified Date : 19/10/2018
Show Technical Document Details
Introduction:

Summary:

This document provides some hints and tips if you would like to use CA InterTest for CICS to monitor DB2 applications. It also includes an JCL sample and how to resolve SQL error codes -805 and -818.

 

Instructions:

Here are some useful additional information on these topics.

  1. Although the recommended name is IN85PLAN for release 8.5, you can use another DB2 PLAN name if necessary. You need to change the name in the CSDDB2 job before submitting it:

DEFINE DB2ENTRY(IN85DB2E) GROUP(INT85065) PLAN(IN85PLXY)

Please check the definition when your CICS is up and running via:
CEDA V DB2ENTRY(IN85DB2E) GR(INT85065)
 
It should look like (CTS 3.2 in this case):
 
CEDA  View DB2Entry( IN85DB2E )                                        
 DB2Entry       : IN85DB2E                                              
 Group          : INT85065                                             
 DEscription    : INTERTEST 8.0 DB2 ENTRY                              
THREAD SELECTION ATTRIBUTES                                            
 TRansid        :                                                      
THREAD OPERATION ATTRIBUTES                                            
 ACcountrec     : None               None | TXid | TAsk | Uow          
 AUTHId         :                                                       
 AUTHType       : Userid             Userid | Opid | Group | Sign | TErm
                                     | TX                              
 DRollback      : Yes                Yes | No                          
 PLAN           : IN85PLXY                                             
  1. The following sample JCL is going to BIND the InterTest PLAN for DB2 version 8.1.0 and higher, running in New Function Mode, and it grantss access to the PLAN:
…jobcard…
//BIND EXEC PGM=IKJEFT01                                           
//STEPLIB  DD DISP=SHR,DSN=your.DB2810.SDSNEXIT                  
//         DD DISP=SHR,DSN=your.DB2810.SDSNLOAD                  
//DBRMLIB  DD DISP=SHR,DSN=your.INTERT85.CAIOPTN    
//SYSPRINT DD SYSOUT=*                                             
//SYSTSPRT DD SYSOUT=*                                             
//SYSUDUMP DD SYSOUT=*                                             
//SYSTSIN  DD *                                                     
 DSN SYSTEM(yourDB2system)                                                  
 BIND PLAN (IN85PLXY)   -                                          
  ACQUIRE (USE)         -                                          
  ACTION (REPLACE)      -                                           
  RETAIN                -                                          
  EXPLAIN (YES)         -                                          
  ISOLATION (CS)        -                                          
  RELEASE (COMMIT)      -                                          
  VALIDATE (RUN)        -                                          
  MEMBER(IN85FIDB,IN85AID8)                                        
  END                                                               
/*                                                                 
//SYSIN    DD *                           
GRANT EXECUTE ON PLAN IN85PLXY TO PUBLIC;
//   
 
  1. See JCL sample above.
 
  1. It is important to add the SDSNLOAD and/or SDSNEXIT library to your CICS DFHRPL concatenation. You will still get SQLCODE -805 at the CORE=LASTSQL command if the library is in the STEPLIB but not in the DFHRPL.
 
  1. You can check whether the XRMIO exit is running by the CA InterTest IGLU transaction. The following display is showing the expected result:

 
           CA INTERTEST/CA SYMDUMP FOR CICS           
              CICS GLOBAL USER EXIT LIST              
                                                      
EXIT NAME   PROGRAM     ENTRY NAME  ADDRESS     STATUS
                                                      
XDUREQ      IN25HOOK    IN25XDUR    80065EA8    STARTED
XMEOUT      IN25HOOK    IN25XMEO    80065EA8    STARTED
XPCFTCH     IN25HOOK    IN25XPCF    80065EA8    STARTED
XPCTA       IN25HOOK    IN25XPCT    80065EA8    STARTED
XRMIOUT     IN25RMIO    IN25RMIO    B8A61000    STARTED
 

If you still encounter an SQLCODE -805 or -818, please rebind the plan and check carefully the libraries being used at BIND as well as the DB2 and CA InterTest load libraries in your CICS JCL.

 

 

Additional Information:

Open an issue with CA Support if you need assistance or if the problem persists.

 

Instructions:
Please Update This Required Field