IBM Books

Administrative API Reference

SQLXA-RECOVER

Used by the transaction APIs to return information about indoubt transactions (see Appendix B. Transaction APIs).

Table 79. Fields in the SQLXA-RECOVER Structure
Field Name Data Type Description
TIMESTAMP INTEGER Time stamp when the transaction entered the prepared (indoubt) state. This is the number of seconds the local time zone is displaced from Coordinated Universal Time.
XID CHAR(140) XA identifier assigned by the transaction manager to uniquely identify a global transaction.
DBALIAS CHAR(16) Alias of the database where the indoubt transaction is found.
APPLID CHAR(30) Application identifier assigned by the database manager for this transaction.
SEQUENCE_NO CHAR(4) The sequence number assigned by the database manager as an extension to the APPLID.
AUTH_ID CHAR(8) ID of the user who ran the transaction.
LOG_FULL CHAR(1) Indicates whether this transaction caused a log full condition.
CONNECTED CHAR(1) Indicates whether an application is connected.
INDOUBT_STATUS CHAR(1) Possible values are listed below.
ORIGINATOR CHAR(1) Indicates whether the transaction was originated by XA or by DB2 in a partitioned database environment.
RESERVED CHAR(9) The first byte is used to indicate the type of indoubt transaction: 0 indicates RM, and 1 indicates TM.

Possible values for LOGFULL (defined in sqlxa) are:

SQLXA_TRUE
True

SQLXA_FALSE
False.

Possible values for CONNECTED (defined in sqlxa) are:

SQLXA_TRUE
True. The transaction is undergoing normal syncpoint processing, and is waiting for the second phase of the two-phase commit.

SQLXA_FALSE
False. The transaction was left indoubt by an earlier failure, and is now waiting for re-sync from a transaction manager.

Possible values for INDOUBT_STATUS (defined in sqlxa) are:

SQLXA_TS_PREP
Prepared

SQLXA_TS_HCOM
Heuristically committed

SQLXA_TS_HROL
Heuristically rolled back

SQLXA_TS_MACK
Missing commit acknowledgement

SQLXA_TS_END
Idle.

Language Syntax

C Structure 



/* File: sqlxa.h */
/* Structure: SQLXA-RECOVER */
/* ... */
typedef struct sqlxa_recover_t
{
  unsigned long  timestamp;
  SQLXA_XID      xid;
  _SQLOLDCHAR    dbalias[SQLXA_DBNAME_SZ];
  _SQLOLDCHAR    applid[SQLXA_APPLID_SZ];
  _SQLOLDCHAR    sequence_no[SQLXA_SEQ_SZ];
  _SQLOLDCHAR    auth_id[SQLXA_USERID_SZ];
  char           log_full;
  char           connected;
  char           indoubt_status;
  char           originator;
  char           reserved[8];
} SQLXA_RECOVER;
/* ... */

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

[ DB2 List of Books | Search the DB2 Books ]