CAL2V203E Error processing database when executing DBVR.

Products

• CA 7 Workload Automation

Issue/Introduction

We run a  batch job that backs up the CA 7 database and executes CAL2DBVR to verify the database.  Lately, the job has been issuing the following error:

CAL2V203E Error processing database 'ddddddd'         SQLCODE = -124  PREPARE1        

 

 

Environment

Release : 12.1

Resolution

 

The SQLCODE   -124 indicates the following:   

An attempt was made to access a plan which was not found in the plan directory.  

Recent CA 7 maintenance may have been applied that added new plans.   Any  PTF that includes a program with a plan will require AL2DCA70 to be run as indicated in the holddata.   To correct the problem with the CAL2V203E Error processing database    'ddddddd'    SQLCODE = -124,  run the AL2DCA70 in the CAL2JCL library  to installed the new plan(s).   After  AL2DCA70 runs successfully to add the missing SQL plans needed by CA 7, rerun the failing  job again.