Displays server transaction status

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

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

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

The items from TRNGID (transaction identifier) to B-SVID (branch source server) and from PROGRAM (UAP identifier) to SYSINF (internal information used by the system) are separated by at least one single-byte space.

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 right-aligned decimal digits in AIX or HP-UX (IPF); up to five right-aligned decimal digits in any other OS if the value is 99999 or less, and up to 10 left-aligned decimal digits if the value is 100000 or more)

If the value is 100000 or more in any OS other than AIX or HP-UX (IPF), SVID (server name) and B-SVID (branch source server) are shifted to the right.

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 a server that accepted transaction processing as a part of UAP or utility processing (up to 10 right-aligned decimal digits in AIX or HP-UX (IPF); up to five right-aligned decimal digits in any other OS if the value is 99999 or less, and up to 10 left-aligned decimal digits if the value is 100000 or more)

In any OS other than AIX or HP-UX (IPF), if the value is 100000 or more, C-PID (process ID and IP address of the client (UAP or utility) that was connected to the server process) is shifted to the right.

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 left-aligned 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.

Output example

When a process ID of 100000 or more is subject to display in AIX or HP-UX (IPF):

HOSTNAME : HOST0001(152813) TRNGID TRNBID STATUS PID SVID B-SVID PRDBUNT001000005 PRDBUNT000010004 ACTIVE(u,n) 38095 SERVER01 ******** PROGRAM TIME SYSINF uap001 152659 p_f_sqa_csetup S-PID= 6888 C-PID=7063(10.1.0.1) ... Process ID is 99999 or less PRDBUNT001000006 PRDBUNT000010005 ACTIVE(u,n) 108221 SERVER01 ******** PROGRAM TIME SYSINF uap002 152755 p_f_sqa_csetup S-PID= 7022 C-PID=7068(10.1.0.1) ... Process ID is 100000 or more PRDBUNT001000007 PRDBUNT000010006 ACTIVE(u,n) 8101 SERVER01 ******** PROGRAM TIME SYSINF uap003 152810 p_f_sqa_csetup S-PID= 6887 C-PID=7069(10.1.0.1) ... Process ID is 99999 or less

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

The items from TRNGID (transaction identifier) to B-SVNUM (number of transaction branches) are separated by at least one single-byte space.

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)