CA JCLCheck message CAY6382E ERROR DURING "DB2" INTERFACE

Document ID : KB000025902
Last Modified Date : 14/02/2018
Show Technical Document Details

 

Question: 

Receiving one of the following errors trying to validate a JCL member with DB2 statements. This may happen after an operating system or CA JCLCheck upgrade.

CAY6382E ERROR DURING "DB2" INTERFACE, RC= "SQLCODE" REASON IS "FFFFFCCE"

CAY6382E ERROR DURING "DB2" INTERFACE, RC= "0000000C" REASON IS "00F30040"

CAY6382E ERROR DURING "DB2" INTERFACE, RC= "S806" REASON IS "PGM FETCH"

 

Answer:

  •   Install support for the DB2 interface by running a BIND and GRANT on PLAN(CAZ2JCAF). Plan name CAZ2JCAF is provided in the CA JCLCheck CAZ2DBRM library.  Refer to the CA JCLCheck Getting Started Guide (Optional) Install Support for DB2 Interface for the DB2 commands to BIND and GRANT using batch IKJEFT01 or online under SPUFI.

 

  • Add the IBM DB2 load library to the linklist or to the STEPLIB DD of the CA JCLCheck job.  CA JCLCheck needs to load the IBM DB2 DSNHLI2 and DSNALI modules from SDSNLOAD.

 

 

As always, please contact CA Technologies support for CA JCLCheck if you have further questions.