commit transaction, rollback transaction, and rollback

After RepAgent has submitted all of the commands in a transaction to the Replication Server, it sends either a commit transaction, rollback transaction, or rollback command.

Use this syntax for commit transaction, rollback transaction, and rollback:

distribute command_tags
{commit transaction |
 rollback transaction |
 rollback [from oqid] to] oqid}

Values are not used by commit transaction and rollback transaction.

The rollback subcommand, without the transaction keyword, requires specification of origin queue ID (oqid) values. The three possible forms of this subcommand are:

• rollback oqid – rolls back a single log record corresponding to the specified origin queue ID. This option supports the mini-rollback capability in DB2.

• rollback to oqid – rolls back all log records between the specified origin queue ID and the current log record.

• rollback from oqid1 to oqid2 – rolls back a sequence of log records whose origin queue IDs fall in the specified range.