DB2 Version 10.1 for Linux, UNIX, and Windows

sqlxphrl API - Roll back an indoubt transaction

Rolls back an indoubt transaction (that is, a transaction that has been prepared). If the operation succeeds, the transaction's state becomes heuristically rolled back.

Scope

This API only affects the node on which it is issued.

Authorization

None

Required connection

Database

API include file

sqlxa.h

API and data structure syntax

extern int SQL_API_FN sqlxphrl(
   int exe_type,
   SQLXA_XID *pTransId,
   struct sqlca *pSqlca
   );

sqlxphrl API parameters

exe_type
Input. If EXE_THIS_NODE is specified, the operation is executed only at this node.
pTransId
Input. XA identifier of the transaction to be heuristically rolled back.
pSqlca
Output. A pointer to the sqlca structure.

Usage notes

Only transactions with a status of prepared or idle can be rolled back. Once heuristically rolled back, the database manager remembers the state of the transaction until the sqlxhfrg API is called.