dspmqtrn

Display in-doubt and heuristically completed transactions.

Purpose

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

Syntax

Read syntax diagramSkip visual syntax diagramdspmqtrn -e -h -i -a -q -m QMgrName

Optional parameters

-e
Requests details of externally coordinated, in-doubt transactions. Such transactions are those for which IBM WebSphere 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 you 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 WebSphere 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 you 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 WebSphere MQ application connection, information related to that IBM WebSphere 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.
-mQMgrName
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

Return code Description
0 Successful operation
26 Queue manager running as a standby instance.
36 Invalid arguments supplied
40 Queue manager not available
49 Queue manager stopping
58 Inconsistent use of installations detected
69 Storage not available
71 Unexpected error
72 Queue manager name error
102 No transactions found

Related commands

Command Description
rsvmqtrn Resolve transaction