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.
Here are some useful additional information on these topics.
- 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
THREAD OPERATION ATTRIBUTES
ACcountrec : None None | TXid | TAsk | Uow
AUTHType : Userid Userid | Opid | Group | Sign | TErm
DRollback : Yes Yes | No
PLAN : IN85PLXY
- 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:
//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 *
BIND PLAN (IN85PLXY) -
ACQUIRE (USE) -
ACTION (REPLACE) -
EXPLAIN (YES) -
ISOLATION (CS) -
RELEASE (COMMIT) -
VALIDATE (RUN) -
//SYSIN DD *
GRANT EXECUTE ON PLAN IN85PLXY TO PUBLIC;
- See JCL sample above.
- 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.
- 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.
Open an issue with CA Support if you need assistance or if the problem persists.