Provides a list of transactions that are indoubt between DRDA® requesters and DRDA servers. If DRDA commit protocols are being used, lists indoubt transactions between DRDA sync point managers.
None
Instance
A forget option is not supported. Once the indoubt transaction is committed or rolled back, the transaction is automatically forgotten.
A blank space must separate the command letter from its argument.
Before a transaction is committed or rolled back, the transaction data is displayed, and the user is asked to confirm the action.
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 a commit. The second phase commits or rolls back the transactions. If a coordinator or participant becomes unavailable after the first phase, the distributed transactions are indoubt.
Before issuing the LIST DRDA INDOUBT TRANSACTIONS command, the application process must be connected to the DB2® sync point manager (SPM) instance. Use the spm_name database manager configuration parameter as the dbalias on the CONNECT statement.
TCP/IP connections, using the SPM to coordinate commits, use DRDA two-phase commit protocols.