Execution of CA 7 database verification CAL2DBVR Utility to identify any record discrepancies found in the CA 7 database
Article ID: 9952
Updated On:
Products
Issue/Introduction
CAL2DBVR is a database verification utility that examines relationships between tables in the CA 7 database for inconsistencies.
The JCL to run CAL2DBVR utility is located in member CA07N610 in your CA 7 HLQ.JCLLIB library.
CAL2DBVR can execute daily outside of CA 7 while CA7ONL STC is active with existing parms PARM='TRIG,RQMT,SCHD,XREF'. This will report on any database record discrepancies found in the database.
Environment
Release: 12.0 & 12.1
Component: CA 7
Resolution
If the daily execution of CAL2DBVR using PARM='TRIG,RQMT,SCHD,XREF' ends in RC4 or RC8, it will report any discrepancies/errors found in the database in the DBVOUT DD of the CAL2DBVR job output.
In order to correct and delete any record discrepancies found in the database, add these 3 additional parms in BOLD to the PARM statement in the CAL2DBVR JCL and execute the job during a maintenance change window when CA7ONL STC is down.
PARM='TRIG,SCHD,RQMT,XREF,UPDT,DELR,DELT'
The UPDT, DELR, and DELT parms will cause the CAL2DBVR program to correct and delete any record discrepancies that were reported in the DBVOUT DD of the daily execution of CAL2DBVR job output.
Additional Information
Please reference Techdoc link below for detailed information on the CAL2DBVR Utility.
Feedback
