Log Apply Utility

The Log Apply batch utility is a component of . You can use Log Apply with a load file to replicate table updates to an identical table.
caladb2
The Log Apply batch utility is a component of
CA Log Analyzer™ for DB2 for z/OS
. You can use Log Apply with a
CA Log Analyzer™ for DB2 for z/OS
load file to replicate table updates to an identical table.
We recommend using Log Apply when you are replicating multiple changes to a target table. Log Apply manages the SQL statements in the load file to minimize the number of PREPARE functions that are performed. Each SQL statement processes one action for one table. The alternate method for replicating table changes consists of generating individual REDO and UNDO SQL statements, which requires a PREPARE for each statement. Individual SQL statements are more appropriate when you are applying a small number of changes to one or more tables.
Do not use Log Apply to load table transaction records into an audit table (also referred to as data warehousing). Typically, when populating an audit table or data warehouse, you include URID information for each record in your load file. Log Apply does not support URID information.