show transaction

show transaction XID

Shows a list of messages that were sent or received within the specified transaction. This command returns information on transactions in prepared, ended, and roll back states only. Transactions in a suspended or active state are not included.

show transaction (description of output fields)
Heading Description
State Transaction state:
  • A active
  • E ended
  • R rollback only
  • P prepared
  • S suspended

Suspended transactions can be rolled back, but cannot be rolled forward (committed).

Remaining time before timeout The seconds remaining before the TX timeout is reached. For example, 3 sec.

This field is only applicable for transactions in State ENDSUCCESS or ROLLBACKONLY.

Messages to be consumed
Message ID The message ID of the message. null indicates the message ID could not be obtained or was disabled. If track_message_ids is not enabled, this field displays Disabled.
Type The destination type to which the message was sent:
  • Q queue
  • T topic
Destination The destination name to which the message was sent. null indicates that destination could not be found.
Consumer ID The consumer ID of the Consumer that is consuming the message. Zero indicates that the consumer is offline.
Messages to be produced
Message ID The message ID of the message. null indicates the message ID could not be obtained or was disabled. If track_message_ids is not enabled, this field displays Disabled.
Type The destination type to which the message was sent:
  • Q queue
  • T topic
Destination The destination name to which the message was sent. null indicates that destination could not be found.
JMSTimestamp The timestamp indicating the time at which the message was created.