Response

The response indicates the type of action that

Log Master

takes when it encounters a given SQL code.

This item corresponds to the High-speed Apply 'Action' configuration parameter. The following table lists the available response values:

Response value	Log Master actions
IGNORE	Ignores the given error code Does not set a condition
WARN	Writes a message in the ALPPRINT output Sets a return code of 4
ROLLBACK	Writes a message in the ALPPRINT output Sets a return code of 4 Rolls back the current unit of work Skips all subsequent SQL statements in the current unit of work Warning Important If the SQL was generated by Log Master with a COMMIT FREQUENCY greater than 1, a unit of work in the SQL file could include multiple units of work from the original log data.
TERMINATE	Terminates execution with return code 12
ABORT	Writes a message in the ALPPRINT output Rolls back the current unit of work Terminates execution with return code 12

The following table shows the Log Master default SQL code responses for statement type ALL:

Condition	Default response
NEGATIVE	ABORT
POSITIVE	WARN
SQLWARN0	WARN
MULTIPLE	WARN

As it processes the SQL code responses that you specify, the High-speed Apply Engine distributed with Log Master creates the following ordered lists:

Inserts
Updates
Deletes
DDL

Each SQL code response appears in the appropriate list, or, if the statement type is ALL, in all lists. The last response in the list overrides any previous responses if you:

Override a default response
Define multiple responses for the same combination of statement type and condition

Response

BMC AMI Log Master for Db2 12.1

On this page