pdls [-d trn] (Display server transaction status)

Function

Displays server transaction status

Format

pdls -d trn [-t transaction-identifier] [-{a|c}] [-s server-name]

Options

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).

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.

Notes

  1. Return code 0 for the pdls -d trn command indicates normal termination, and return code 8 indicates abnormal termination.

Output format

-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).