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

Organization of this section
(1) Function
(2) Format
(3) Options
(4) Notes
(5) Output format

(1) Function

Displays server transaction status

(2) Format

pdls -d trn [-t transaction-identifier] [-{a|c}] [-s server-name] [-C [-H]]
[{-x host-name[,host-name]...|-u unit-identifier[,unit-identifier]...}]

(3) Options

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

(b) -{a|c}
-a
Specifies that all transaction information is to be displayed.
-c
Specifies that the number of transaction branches is to be displayed.

When this option is omitted, the command displays all transaction information (with some exceptions).

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

(d) -C

Specifies that the server transaction status is to be output in DAT format.

(e) -H

Specifies that a title line is to be output (applicable when the -C option is specified).

(f) -x host-name[,host-name]...

Specifies the names of hosts whose information is to be displayed.

If this option is specified together with the -s option, the -s option is effective and the -x option is ignored. If you specify multiple host names, there must be no spaces before or after a delimiter comma.

(g) -u unit-identifier[,unit-identifier]...

Specifies units whose information is to be displayed.

If this option is specified together with the -s option, the -s option is effective and the -u option is ignored. If you specify multiple unit names, there must be no spaces before or after a delimiter comma.

(4) Notes

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

(5) Output format

(a) -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
            READING-BLOCK-NO=DD...D

Explanation

When more than one transaction is to be displayed, this information is displayed for each such transaction. When -a is omitted, the information for PROGRAM, TIME, SYSINF, and S-PID through ENVGRP is 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-selected commit processing
H_ROLLBACK
Engaged in system-selected rollback processing
COMMIT
Engaged in commit processing
ROLLBACK_ACTIVE
Waiting for rollback processing
ROLLBACK
Engaged in rollback processing
H_FORGETTING
Engaged in system-selected transaction termination processing
FORGETTING
Engaged in transaction termination processing
Note: For H_COMMIT, H_ROLLBACK, and H_FORGETTING, HiRDB selects a settlement method in the event of an error 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.
There may be no information displayed if the utility was running under a utility server process or if the UAP identification information could not be obtained because of an error (in DAT format, the null element might be displayed). If single-byte spaces are specified at the end of PDCLTAPNAME, the value is displayed in DAT format with those single-byte spaces deleted.
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).
The value 0 is displayed in the following cases:
  • The server process is not connected to the client.
  • The client library connected to the UAP is earlier than version 04-00.
  • The server process is connected from a Type4 JDBC driver.
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.
wwww
OLTP identifier of the connected OLTP (up to 4 characters).
If the PDTMID client environment variable is omitted, **** is displayed.
xx...x, yy...y
Transaction identifier provided by OLTP or XDS (up to 33 characters).
zzzz
Environment variable group identifier provided by the OLTP system (four characters).
This information is displayed when the multi-connection facility is used. When the multi-connection facility is not used, **** is displayed.
DD...D:
Block number of the system log being imported (up to 8 characters).
This information is displayed only when system log import processing is underway during rollback processing (when data is output in DAT format, empty elements are displayed). For details about how to check whether rollback processing is in progress, see the HiRDB Version 9 System Operation Guide.
(b) When the -a -C -H option is specified

"EDIT-TIME","HOSTNAME","TRNGID","TRNBID","STATUS1","STATUS2","STATUS3","PID","SVID",
"B-SVID","PROGRAM","TIME","SYSINF","S-PID","C-PID","C-ADDR","TMID","XID","ENVGRP",
"XDS","NODE-ID","READING-BLOCK-NO"
"AA...A","aa...a","eeeeffffgg...g","eeeeffffhh...h","jj...j","k","l",mm...m,"ii...i",
"nn...n","oo...o","ppqqrr","ss...s",tt...t,uu...u,"vv...v","wwww","xx...x,yy...y","zzzz",
"BB...B","CCCC","DD...D"

Explanation
For explanations of aa...a through DD...D, see the information above for when the -a option is specified.
For the rules for output in DAT format, see 1.5.3 Rules for output of command execution results in DAT format.
One line displays information about one transaction.
AA...A:
Time the pdls command was executed, in the format YYYY/MM/DD hh:mm:ss (4-digit-year/month/date hour:minute:second)
(c) When the -c option is 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).
If the -s option is omitted, "********" is displayed.
ii...i
Number of transaction branches (5 decimal digits).
If the -s option is specified, the number of transaction branches with the same transaction identifier that are managed by the corresponding server is displayed. If the -s option is omitted, the number of transaction branches with the same transaction identifier that are managed by the corresponding unit is displayed.
(d) When the -c -C -H option is specified

"EDIT-TIME","HOSTNAME","TRNGID","SVID","B-SVNUM"
"jj...j","aa...a","eeeeffffgg...g","hh...h",ii...i

Explanation
For explanations of aa...a through ii...i, see the information above for when the -c option is specified.
For the rules for output in DAT format, see 1.5.3 Rules for output of command execution results in DAT format.
One line displays information about one transaction.
jj...j:
Time the pdls command was executed, in the format YYYY/MM/DD hh:mm:ss (4-digit-year/month/date hour:minute:second)