Administrative API Reference

sqlcspqy - List DRDA Indoubt Transactions

Provides a list of transactions that are indoubt between partner LUs connected by LU 6.2 protocols.

Authorization

sysadm

Required Connection

Instance

Version

sqlxa.h

C API Syntax

/* File: sqlxa.h */ /* API: List DRDA Indoubt Transactions */ /* ... */ extern int SQL_API_FN sqlcspqy(SQLCSPQY_INDOUBT **indoubt_data, sqlint32 *indoubt_count, struct sqlca *sqlca); /* ... */

API Parameters

indoubt_data

Output. A pointer to the returned array.

indoubt_count

Output. The number of elements in the returned array.

pSqlca

Output. A pointer to the sqlca structure. For more information about this structure, see SQLCA.

Usage Notes

DRDA indoubt transactions occur when communication is lost between coordinators and participants in distributed units of work.

A distributed unit of work lets a user or application read and update data at multiple locations within a single unit of work. Such work requires a two-phase commit.

The first phase requests all the participants to prepare for commit. The second phase commits or rolls back the transactions. If a coordinator or participant becomes unavailable after the first phase then the distributed transactions are indoubt.

Before issuing LIST DRDA INDOUBT TRANSACTIONS, the application process must be connected to the Sync Point Manager (SPM) instance. Use the SPM_NAME as the dbalias on the CONNECT statement (see the SQL Reference for more information about using CONNECT). SPM_NAME is a database manager configuration parameter.