dspmqtrn (display incomplete transactions)

Display in-doubt and heuristically completed transactions.

Purpose

Use the dspmqtrn command to display details of transactions. This command includes transactions coordinated by IBM MQ and by an external transaction manager.

Syntax

Optional parameters

-e

Requests details of externally coordinated, in-doubt transactions. Such transactions are those for which IBM MQ has been asked to prepare to commit, but has not yet been informed of the transaction outcome.

-h

Requests details of externally coordinated transactions that were resolved by the rsvmqtrn command, and the external transaction coordinator has yet to acknowledge with an xa-forget command. This transaction state is termed heuristically completed by X/Open. Note: If we do not specify -e, -h, or -i, details of both internally and externally coordinated in-doubt transactions are displayed, but details of externally coordinated, heuristically completed transactions are not displayed.

-i

Requests details of internally coordinated, in-doubt transactions. Such transactions are those for which each resource manager has been asked to prepare to commit, but IBM MQ has yet to inform the resource managers of the transaction outcome.

Information about the state of the transaction in each of its participating resource managers is displayed. This information can help you assess the affects of failure in a particular resource manager. Note: If we do not specify -e or -i, details of both internally and externally coordinated in-doubt transactions are displayed.

-a

Requests a list of all transactions known to the queue manager . The returned data includes transaction details for all transactions known to the queue manager. If a transaction is currently associated with an IBM MQ application connection, information related to that IBM MQ application connection is also returned. The data returned by this command might typically be correlated with the output of a runmqsc DISPLAY CONN command, and the output fields have the same meaning as in that command.

Not all of the fields are appropriate for all transactions. When the fields are not meaningful, they are displayed as blank. For example: The UOWLOG value when the command is issued against a circular logging queue manager.

-q

Specifying this parameter on its own is the same as specifying -a -q.

Displays all the data from the -a parameter and a list of up to 100 unique objects updated within the transaction. If more than 100 objects are updated in the same transaction, only the first 100 distinct objects are listed for each transaction.

-m QMgrName

The name of the queue manager for which to display transactions. If you omit the name, the transaction of the default queue manager are displayed.

Return codes

Related commands