ROLLBACK-PTC-TRANSACTION

This statement rolls back a PTC transaction.

Scope of validity

DBH administration

See also

The COMMIT-PTC-TRANSACTION administration statement on "COMMIT-PTC-TRANSACTION"

Function

The ROLLBACK-PTC-TRANSACTION statement rolls back a user's PTC transaction. A PTC transaction is a distributed transaction that has the status “prepared to commit” (see the “ Core manual”).

The functional description of the COMMIT-PTC-TRANSACTION administration statement tells you when it may be necessary to manually roll back or commit PTC transactions.

This statement is only relevant to PTC transactions. If no PTC transactions are active in the DBH, the statement is rejected. It is also rejected if the DBH was loaded without transaction management.

If a user does not have any transaction in the PTC status, then a message is output.

You should exercise careful consideration before using the ROLLBACK-PTC-TRANSACTION administration statement; it can destroy the logical consistency of the transaction.

ROLLBACK-PTC-TRANSACTION

USER = <user-identification>

Operands

USER = <user-identification>

Identifies the user whose PTC transaction is to be rolled back. The identification must be unique. You must specify all the relevant partial qualifications (see section “Syntax for the identification of users”).

Administration command in ISP format and at the CALL DML interface

The RPTC administration command corresponds to the ROLLBACK-PTC-TRANSACTION administration statement here.

RPTC,user-identification