SHOW TRANSACTION

SHOW TRANSACTION

Displays information about currently active transactions.

Format

SHOW TRANSACTION

Command Qualifiers

Defaults

/BACKEND

/NOBACKEND (D)

/CLUSTER

/NOCLUSTER

/FACILITY

/FACILITY="*"

/FRONTEND

/NOFRONTEND (D)

/FULL

/NOFULL

/IDENTIFICATION=process-id

/NOIDENTIFICATION

/NODE[=node-lisft]

/NODE=default-node-list

/OUTPUT[=file-spec]

/OUTPUT=stdout

/ROUTER

/NOROUTER (D)

Description

The SHOW TRANSACTION command displays transaction information, such the transaction ID, facility, transaction state, frontend user, start time and router node.

Qualifiers

/BACKEND /NOBACKEND (D)

Specifies that information should be listed for transactions in a backend node. If none of /BACKEND, /FRONTEND or /ROUTER are specified, then information for all of them are displayed. If either /FRONTEND or /ROUTER are specified, then the default (/NOBACKEND) inhibits display of backend transaction information.

The ``Invocation'' field of SHOW TRANSACTION /BACKEND /FULL shows the following information:

Table 6–24 Transaction Invocation Types

Type

Meaning

 

 

ORIGINAL

Original transaction

REPLAY

Replayed transaction

RECOVERY

Shadow recovery transaction

 

 

/CLUSTER /NOCLUSTER (D)

Specifies that the command is executed on all the nodes in the cluster.

If neither /NODE nor /CLUSTER is specified then the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered then the command is executed only on the node where the command was issued.

6–168RTR Command Line Interface

Page 244
Image 244
Compaq AA-Q88CE-TE manual Show Transaction, Transaction Invocation Types