Log Analyzer - REDO SQL - Limitations and Usages

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

1. If there are any limitations or restrictions while using this REDO SQL output format for generating INSERT / UPDATE / DELETE SQLs with image copy on a specific interval.

This is to make sure the same process can be carried out for larger sized tables. 

2. Is there any limitations for the COMPRESS YES tablespace while extracting the DMLs through log analyzer.

 

Environment

Release : 20.0

Resolution

   To answer question 1
on limitations on REDO SQL.

Always ensure the datasets you create have enough space allocated to hold the data 
generated. 

Depending on the options selected you could need more execution time 
and more space to hold the data generated.

The various options are listed here for UNDO REDO SQL. 

UNDO-REDO SQL