- -t transaction-identifier
<alphanumeric> ((16 characters))
Specifies the identifier of a transaction about which information is to be displayed. When this option is omitted, information about all transactions is displayed.
- -a
- Specifies that all transaction information is to be displayed.
- -c
- Specifies that the number of branches in a global transaction is to be displayed.
When this option is omitted, the command displays all transaction information (with some exceptions).
- -s server-name
<identifier> ((1-8))
Specifies the name of the front-end server or of a back-end server. If the front-end server name is specified, the command displays information about all global transactions managed by the front-end server. If a back-end server name is specified, the command displays information about all transactions branched from global transactions managed by the specified back-end server. When this option is omitted, the command displays information about all transactions managed by the specified unit.
-a option specified:
HOSTNAME: aa...a(bbccdd)
TRNGID TRNBID STATUS PID SVID B-SVID
eeeeffffgg...g eeeeffffhh...h jj...j(k,l) mm...m ii...i nn...n
PROGRAM TIME SYSINF
oo...o ppqqrr ss...s
S-PID=tt...t C-PID=uu...u(vv...v)
TMID=wwww XID=xx...x,yy...y ENVGRP=zzzz
- Explanation
When more than one transaction is to be displayed, this information is displayed for each such transaction. When -a is omitted, TIME, SYSINF, and S-PID through ENVGRP information are not displayed.
- aa...a
- Host name (up to 32 characters).
- bbccdd
- Time of pdls command execution (hour:minute:second).
- eeeeffffgg...g and eeeeffffhh...h
- Transaction identifier (16 characters)
- eeee
- HiRDB identifier (4 characters)
- ffff
- Unit identifier (4 characters)
- gg...g
- Global transaction number (8 decimal digits)
- hh...h
- Transaction branch number (8 decimal digits)
- ii...i
- Server name (up to 8 characters).
- jj...j
- Transaction status 1 (up to 16 characters):
- BEGINNING
- Engaged in transaction startup processing
- ACTIVE
- Executing
- SUSPEND
- Suspended
- IDLE
- Shifting to synchronization point processing
- PREPARE
- Engaged in commit (phase 1) processing
- READY
- Engaged in commit (phase 2) processing
- H_COMMIT
- Engaged in system-selected1 commit processing
- H_ROLLBACK
- Engaged in system-selected1 rollback processing
- COMMIT
- Engaged in commit processing
- ROLLBACK_ACTIVE
- Waiting for rollback processing
- ROLLBACK
- Engaged in rollback processing
- H_FORGETTING
- Engaged in system-selected1 transaction termination processing
- FORGETTING
- Engaged in transaction termination processing
1 In the event of an error, HiRDB selects a settlement method without waiting for an instruction from the user.
- k
- Transaction status 2
- u
- Accessing data by means of a database access process
- r
- Executing transaction recovery processing by means of a transaction recovery process
- p
- Waiting for transaction recovery processing by means of a transaction recovery process
- l
- Transaction status 3
- s
- Communicating (transferring a transaction settlement instruction between servers)
- r
- Waiting for communication (waiting to transfer a transaction settlement instruction between servers)
- w
- Synchronizing (synchronizing the transaction between the transaction manager and the server)
- n
- Not communicating (neither s nor r)
- mm...m
- Process ID (up to 10 decimal digits).
- If there is no process associated with executing the transaction, such as when the transaction is waiting for transaction recovery processing, 0 is displayed.
- nn...n
- Name of branch source server (up to 8 characters).
- If the local server issued the request, ******** is displayed.
- oo...o
- UAP identification information (up to 30 characters).
- The UAP identification name specified in PDCLTAPNAME in the client definition is displayed.
- If PDCLTAPNAME is undefined, Unknown is displayed.
- For a utility, the name of the utility command is displayed.
- This information may be left blank if the utility was running under a utility server process or if it was impossible to obtain the UAP identification information because of an error.
- ppqqrr
- Time the service request was accepted (hour:minute:second).
- ss...s
- Internal information used by the system (up to 32 characters).
- tt...t
- Process ID of the server that accepted transaction processing as part of the UAP or utility processing (up to 10 decimal digits).
- 0 may be displayed if the utility was running under a utility server process or if it was impossible to obtain the process ID because of an error.
- uu...u
- Process ID of the client (UAP or utility) that was connected to the server process (up to 10 decimal digits).
- This information is applicable only to the server process that was connected to the client. For a service process that was not connected to the client, 0 is displayed. 0 is also displayed if the version of the client library connected to the UAP is earlier than 04-00.
- vv...v
- IP address of the client (UAP or utility) that was connected to the server process (up to 15 characters).
- This information is applicable only to the server process that was connected to the client. For a service process that was not connected to the client, 0.0.0.0 is displayed. 0.0.0.0 is also displayed if the version of the client library connected to the UAP is earlier than 04-00.
- wwww
- OLTP identifier of the connected OLTP (up to 4 characters).1
- xx...x, yy...y
- Transaction identifier provided by OLTP (33 characters).1
- zzzz
- Environment variable group identifier provided by the OLTP system (four characters).1
- This information is displayed when the multi-connection facility is used. When the multi-connection facility is not used, **** is displayed.
- 1 This information is not output for a utility or if the connected client is not an application complying with X/Open.
-c option or -t and -c options specified:
HOSTNAME: aa...a(bbccdd)
TRNGID SVID B-SVNUM
eeeeffffgg...g hh...h ii...i
- Explanation
When more than one transaction is to be displayed, this information is displayed for each such transaction.
- aa...a
- Host name (up to 32 characters).
- bbccdd
- Time of pdls command execution (hour:minute:second).
- eeeeffffgg...g
- Transaction identifier (16 characters):
- eeee
- HiRDB identifier (4 characters)
- ffff
- Unit identifier (4 characters)
- gg...g
- Global transaction number (8 decimal digits)
- hh...h
- Server name (up to 8 characters).
- ii...i
- Number of transactions branched from the corresponding server (5 decimal digits).