Replication Job Abends in PRE PROD System

book

Article ID: 196242

calendar_today

Updated On:

Products

CA Fast Recover for DB2 for z/OS CA Log Analyzer for DB2 for z/OS CA Quick Copy for DB2 for z/OS CA Database Management for DB2 for z/OS - Recovery Suite CA Merge/Modify for DB2 for z/OS CA Recovery Analyzer for DB2 for z/OS CA Log Analyzer SMF Audit Trace Option CA MM Backup and Recovery for DB2

Issue/Introduction

REPLICATION job abends in (PRE PROD).  The REPLICATION job reads data from one system  and applies changes in PRE PROD system.

The REPLICATION job abended while INSERTING a ROW in table  due to duplicate data issue. 

 

 

Environment

Release : 20.0

Component : CA Log Analyzer for DB2 for z/OS

Resolution

Log Analyzer does not and have a way to determine the log records
were created by the IBM load utility.
In the log it is a set of insert records followed by delete records
for the rows removed during INDEXVAL phase.
Therefore the output file contains insert records (for duplicate rows)
and the delete records are present later in the output.