IBM Books

Administrative API Reference

sqlxphrl - 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

One of the following:

Required Connection

Database

Version

sqlxa.h

C API Syntax 



/* File: sqlxa.h */
/* API: Roll Back an Indoubt Transaction */
/* ... */
extern int SQL_API_FN sqlxphrl(
   int                  exe_type,
   SQLXA_XID            *pTransId,
   struct sqlca         *pSqlca
   );
/* ... */

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. For more information about this structure, see SQLCA.

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 sqlxhfrg - Forget Transaction Status is issued.

For information about the SQLXA_XID structure, see SQLXA-XID.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]