Replication Job Abends in PRE PROD System

Products

• Log Analyzer for DB2 for z/OS

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.