dspmqtrn (display incomplete transactions)

Display in-doubt and heuristically completed transactions.

Purpose

You can use the dspmqtrn command to display details of transactions. The transactions that can be displayed include transactions that are coordinated by both the IBM® MQ Appliance and external transaction managers.

Syntax

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

Parameters

-e
Specifies that details of externally coordinated, in-doubt transactions are displayed.
These transactions are transactions for which the IBM MQ Appliance has been asked to prepare to commit, but has not yet been informed of the transaction outcome.
-h
Specifies that details of externally coordinated, heuristically completed transactions are displayed.
These transactions are transactions that are resolved by the rsvmqtrn command, but that the external transaction coordinator has yet to acknowledge with an xa-forget command.
-i
Specifies that details of internally coordinated, in-doubt transactions are displayed.
These transactions are transactions for which each resource manager has been asked to prepare to commit, but the IBM MQ Appliance has yet to inform the resource managers of the transaction outcome.
-a
Specifies that a list of all transactions known to the queue manager are displayed.
The returned data includes transaction details for all transactions known to the queue manager. If a transaction is currently associated with an IBM MQ Appliance application connection, information related to that application connection is also returned.
-q
Specifies that all the data from the -a parameter and a list of up to 100 unique objects updated within the transaction are displayed.
If more than 100 objects are updated in the same transaction, only the first 100 distinct objects are listed for each transaction.
Specifying this parameter on its own is the same as specifying -a -q.
-m QMgrName
Specifies the name of the queue manager for which to display transactions.
The default value is the default queue manager.

Usage notes

  • This command must be run from the IBM MQ administration mode. If the system is in the IBM MQ administration mode the prompt includes mqa(mqcli)#. To enter the IBM MQ administration mode, enter mqcli on the command line. To exit the IBM MQ administration mode, enter exit on the command line.
  • If you do not specify -e, -h, or -i, details of both internally and externally coordinated in-doubt transactions are displayed. Details of externally coordinated, heuristically completed transactions are not displayed.
  • Not all of the fields are appropriate for all transactions. When the fields are not meaningful, they are displayed as blank.
  • For more information about this command in IBM MQ, see dspmqtrn in the IBM MQ documentation.

Examples

  • The following command shows externally coordinated, in-doubt transactions for the queue manager QM1: 
    dspmqtrn -e -m QM1

Related commands