Skip to Content

Default language.

Response

The response indicates the type of action that BMC AMI Log Master takes when it encounters a given SQL code.

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

Related topic

Handling-SQL-codes-with-EXECSQL

Response value

BMC AMI 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 BMC AMI 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 BMC AMI 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 BMC AMI 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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Log Master for Db2 13.1