CAI TOOL - CIARPT03 SQL CODE 471- and DSNT408I SQLCODE = -501

Products

• ACF2 - z/OS

Issue/Introduction

CIARPT03 report gets sqlcode 471 as shown below:

Sysid     Application Name          Application Version       Load Date         
--------  ------------------------  ------------------------  ----------        
COD       CA ACF2                   Release 16.0              2021-06-03        
CAS4100E SQLCODE =           471-                                               
CAS4101E Text:     CAISEC.CIA_FILTER_MATCH 00E79001                             
CAS4102E Cursor Name: OPEN ACF2MatchCUR 

DB2 WLM gets a  -501 error as shown below: 
 

+ DSNT408I SQLCODE = -501, ERROR:  THE CURSOR IDENTIFIED IN 
+          STATEMENT IS NOT OPEN                            
+ DSNT418I SQLSTATE   = 24501 SQLSTATE RETURN CODE          
+ DSNT415I SQLERRP    = DSNXERT SQL PROCEDURE DETECTING ERRO
+ DSNT416I SQLERRD    = -315  0  0  -1  0  0 SQL DIAGNOSTIC  

 

Environment

Release : 16.0

Component : CA ACF2 for z/OS

Resolution

Re-link the load modules from step 4 of Implement the CIA Repository in DB2 as shown below and run CIARPT03:

4. Link the DB2 modules into functions. For the service functions to operate properly, link the DB2 modules, DSNRLI and DSNTIAR, into the service functions in the target DB2 subsystem with the security repository.

a. Edit the CIA4LNK1 job in library CAI.CAX1JCL0. Modify the job to conform to your installation standards and direct it to the target DB2        subsystem.
b. Submit the job. The job runs and completes.
c. Verify the output of the job. The modules are now linked.
d. Sites that previously installed the CIA Feature, run the CIA4DB2D job, which is located in your ESM job that is listed in the above table. This job deletes the previous CIA application and repository definitions and brings CIA application entities up to date

* Step 5 bind job is not required after re-linking the load modules.