DB2 Version 9.7 for Linux, UNIX, and Windows

sqlxphcm API - Commit an indoubt transaction

Commits an indoubt transaction (that is, a transaction that is prepared to be committed). If the operation succeeds, the transaction's state becomes heuristically committed.

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 sqlxphcm(
   int exe_type,
   SQLXA_XID *pTransId,
   struct sqlca *pSqlca
   );

sqlxphcm 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 committed.
pSqlca: Output. A pointer to the sqlca structure.

Usage notes

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