Conflict resolution

Based on the type of conflict, you can choose to:

• Ignore the conflict

• Defer resolution until the job is complete

• Stop apply processing until the conflict is resolved

• Retry an SQL statement that generates a time-related conflict (such as time out conditions or RI-related conflicts)

Conflict resolution rules determine how the High-speed Apply Engine responds when a conflict occurs during apply processing. You create conflict resolution rules by defining sets of Code and Action parameters for each conflict to which you want to respond.

The following sections of its configuration file control how High-speed Apply Engine handles conflict resolution:

• [AnyConflict] (AnyConflict parameters)

• [DeleteConflict] (DeleteConflict parameters)

• [DDLConflict] (DDLConflict parameters)

• [InsertConflict] (InsertConflict parameters)

• [UpdateConflict] (UpdateConflict parameters)

• [Conflict] (Conflict parameters)

• [ConflictFile] (ConflictFile parameters)

Consider these points regarding the configuration sections for conflict resolution:

• The rules in the [AnyConflict] section apply to all types of statements (INSERT, UPDATE, DELETE, or EXCHANGE statements, as well as data definition language (DDL) statements. A rule that is defined in one of the other conflict sections, such as the [InsertConflcit] section, takes precedence over rules in the [AnyConflict] section.

• If a statement does not start with INSERT, UPDATE, or DELETE, High-speed Apply Engine will use [DDLConflict] rules if they are defined. High-speed Apply Engine uses [DDLConflict] rules to process EXCHANGE statements.

• The [Conflict] section describes general processing options for conflict management, particularly for retry processing.

• The [ConflictFile] section defines the conflict file or files where High-speed Apply Engine writes output when the Action parameter of a conflict resolution rule is DeferStatement or DeferUR.

• High-speed Apply Engine tracks the number of conflicts that trigger a conflict resolution rule during an apply request and displays the results in message BMCAPT0222.

This section contains the following topics:

• Codes for conflict resolution (SQL codes)
• Format of conflict resolution rules