Reliable Transaction Router
System Manager's Manual

The following examples show two backend partitions.

RTR> SHOW PARTITION/BACKEND Partition name Facility State RTR$DEFAULT_PARTITION_16777217 RTR$DEFAULT_FACILITY active RTR$DEFAULT_PARTITION_16777218 RTR$DEFAULT_FACILITY active RTR> SHOW PARTITION/BACKEND/FULL Partition name: RTR$DEFAULT_PARTITION_16777217 Facility: RTR$DEFAULT_FACILITY State: active Low Bound: "aaaa" High Bound: "mmmm" Active Servers: 0 Free Servers: 1 Transaction presentation: active Last Rcvy BE: Txns Active: 0 Txns Rcvrd: 0 Failover policy: fail_to_standby Key range ID: 16777217 Partition name: RTR$DEFAULT_PARTITION_16777218 Facility: RTR$DEFAULT_FACILITY State: active Low Bound: "nnnn" High Bound: "zzzz" Active Servers: 0 Free Servers: 1 Transaction presentation: active Last Rcvy BE: Txns Active: 0 Txns Rcvrd: 0 Failover policy: fail_to_standby Key range ID: 16777218


RTR> SHOW PARTITION/BACKEND Partition name Facility State RTR$DEFAULT_PARTITION_16777217 RTR$DEFAULT_FACILITY active RTR$DEFAULT_PARTITION_16777218 RTR$DEFAULT_FACILITY active RTR> SHOW PARTITION/BACKEND/FULL Partition name: RTR$DEFAULT_PARTITION_16777217 Facility: RTR$DEFAULT_FACILITY State: active Low Bound: "aaaa" High Bound: "mmmm" Active Servers: 0 Free Servers: 1 Transaction presentation: active Last Rcvy BE: Txns Active: 0 Txns Rcvrd: 0 Failover policy: fail_to_standby Key range ID: 16777217 Partition name: RTR$DEFAULT_PARTITION_16777218 Facility: RTR$DEFAULT_FACILITY State: active Low Bound: "nnnn" High Bound: "zzzz" Active Servers: 0 Free Servers: 1 Transaction presentation: active Last Rcvy BE: Txns Active: 0 Txns Rcvrd: 0 Failover policy: fail_to_standby Key range ID: 16777218

SHOW PROCESS

The SHOW PROCESS command displays information about processes that use RTR.

Format

SHOW PROCESS

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/COUNTER[=counter-name]	/NOCOUNTER
/FULL	/NOFULL
/IDENTIFICATION=process-id	/NOIDENTIFICATION
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout

Description

The SHOW PROCESS command displays information about the processes using RTR.

Qualifiers

/CLUSTER

/NOCLUSTER (D)
Specifies that the command is executed on all the nodes in the cluster.
If neither /NODE nor /CLUSTER is specified, the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered, the command is executed only on the node where the command was issued.

Note
In environments that do not support remote command capability, the /CLUSTER qualifier causes the relevant command to be executed on the local node only. See Section 1.4 for more information.

/COUNTER[=counter-name]

/NOCOUNTER (D)
Specifies that the process counters are also to be displayed. counter-name is the name of the counter to be displayed. If counter-name is omitted, all counters will be displayed. counter-name may contain wild card characters.
/IDENTIFICATION=process-id

/NOIDENTIFICATION (D)
Specifies the process about which information is required. The default (/NOIDENTIFICATION) displays all processes using RTR.
/FULL

/NOFULL (D)
Equivalent to specifying /COUNTER.
/NODE[=node-list]

/NODE=default-node (D)
Specifies that the command is executed on all nodes specified in node-list . If node-list is omitted, the command is executed only on the node where the command was issued.
/OUTPUT[=filespec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file filespec . If /OUTPUT or filespec is omitted, the standard or default output is used.

Examples

RTR> SHOW PROCESS Processes: Process-id Process Name 326

SHOW REQUESTER

See SHOW CLIENT. The SHOW REQUESTER command has been replaced by SHOW CLIENT and is retained for compatibility reasons only.

SHOW RESOURCE_MANAGER (SHOW RM)

The SHOW RESOURCE_MANAGER command displays resource manager (RM) instance information.
This command is available only on UNIX and Windows NT systems.

Format

SHOW RESOURCE_MANAGER [resource_name]
SHOW RM [resource_name]

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/FULL	/NOFULL
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout

Description

The SHOW RESOURCE_MANAGER command displays information for registered RMs. This command shows information for one or more RMs registered with the current TM.

Note
This command is available only on UNIX and Windows NT systems.

Refer to Appendix C, XA Support for support information about XA.

Parameters

resource_name
Specifies the name of the resource manager instance you want to display. resource_name may contain wildcards (* and %), in which case all matching resources are displayed. If resource_name is omitted, all configured resources are displayed.

Qualifiers

/CLUSTER

/NOCLUSTER (D)
Specifies that the command is executed on all the nodes in the cluster.
If neither /NODE nor /CLUSTER is specified, the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered, the command is executed only on the node where the command was issued.

Note
In environments that do not support remote command capability, the /CLUSTER qualifier causes the relevant command to be executed on the local node only. See Section 1.4 for more information.

/FULL

/NOFULL (D)
Displays additional information for facilities that reference a particular RM. If no rmi_name is included, displays information for all RMs.
/NODE[=node-list]

/NODE=default-node (D)
Specifies that the command is executed on all nodes specified in node-list . If node-list is omitted, the command is executed only on the node where the command was issued.
/OUTPUT[=filespec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file filespec . If /OUTPUT or filespec is omitted, the standard or default output is used.

Related commands

REGISTER RESOURCE_MANAGER
UNREGISTER RESOURCE_MANAGER

Examples


RTR> SHOW RM rmi_0 /full Resource Manager: RMI Name : rm_0 RMID : 0 XA Switch : msqlsrvxal Library path : .\xadll.dll The facility associated with this RM: xatest

SHOW RTR

The SHOW RTR command displays the configuration and status of RTR.

Format

SHOW RTR

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/COUNTER[=counter-name]	/NOCOUNTER
/FULL	/NOFULL
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout
/STATUS	/NOSTATUS
/VERSION	/NOVERSION

Description

The SHOW RTR command displays the configuration and status of RTR.

Qualifiers

/CLUSTER

/NOCLUSTER (D)
Specifies that the command is executed on all the nodes in the cluster.
If neither /NODE nor /CLUSTER is specified, the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered, the command is executed only on the node where the command was issued.

Note
In environments that do not support remote command capability, the /CLUSTER qualifier causes the relevant command to be executed on the local node only. See Section 1.4 for more information.

/COUNTER[=counter-name]

/NOCOUNTER (D)
Specifies that the per-node counters are also to be displayed. Counter-name is the name of the counter to be displayed. If counter-name is omitted, all counters will be displayed. Counter-name may contain wild card characters.
/FULL

/NOFULL (D)
Equivalent to specifying /COUNTER/STATUS.
/NODE[=node-list]

/NODE=default-node (D)
Specifies that the command is executed on all nodes specified in node-list . If node-list is omitted, the command is executed only on the node where the command was issued.
/OUTPUT[=filespec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file filespec . If /OUTPUT or filespec is omitted, the standard or default output is used.
/STATUS (D)

/NOSTATUS
Displays the current status of RTR (started, stopped and so on).
/VERSION

/NOVERSION (D)
Displays the RTR version.

Related commands

STOP RTR
START RTR

Example


RTR> SHOW RTR (1) RTR running on node baby.home.dec.com in group: develpr (2)

Shows the state and configuration of RTR.
Shows RTR has been started in group mode for group develpr .

SHOW SEGMENT

The SHOW SEGMENT command displays the type and size of routing key segments.

Format

SHOW SEGMENT

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/FACILITY[=facility-name]	/FACILITY="*"
/FULL	/NOFULL
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout

Description

The SHOW SEGMENT command displays the routing key segment definitions.
The routing key definition is common to all servers in a facility.
The routing key specifies the data within a message sent from clients used to route the message to a particular key range server.
The position, length and data type of each key segment is displayed.

Qualifiers

/CLUSTER

/NOCLUSTER (D)
Specifies that the command is executed on all the nodes in the cluster.
If neither /NODE nor /CLUSTER is specified, the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered, the command is executed only on the node where the command was issued.

Note
In environments that do not support remote command capability, the /CLUSTER qualifier causes the relevant command to be executed on the local node only. See Section 1.4 for more information.

/FACILITY

/FACILITY="*" (D)
Specifies the facility name for which information should be displayed.
By default, information is displayed for all facilities.
/NODE[=node-list]

/NODE=default-node (D)
Specifies that the command is executed on all nodes specified in node-list . If node-list is omitted, the command is executed only on the node where the command was issued.
/OUTPUT[=filespec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file filespec . If /OUTPUT or filespec is omitted, the standard or default output is used.

Examples


RTR> SHOW SEGMENT (1) Facility Data Type Length Offset RTR$DEFAULT_FACILITY UNSIGNED 1 0 (2) TEST_FAC SIGNED 4 10

Shows the routing key segments for all facilities.
Shows the facility name, the routing key data type, key length and offset for each facility.

SHOW SERVER

The SHOW SERVER command displays information about server channels.

Format

SHOW SERVER

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/FACILITY[=facility-name]	/FACILITY="*"
/FULL	/NOFULL
/IDENTIFICATION=process-id	/NOIDENTIFICATION
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout

Description

The SHOW SERVER command displays information about server channels.
Information such as PID, key range, state, event mask, event name and partition ID can be displayed.
The State: field of the SHOW SERVER command can display the following values:

Table 7-22 Key-Range States
State Meaning

wt_tr_ok Server is waiting for routers to accept it

wt_quorum Server is waiting for backend to be quorate

lcl_rec Local recovery

lcl_rec_fail Primary server waiting for access to a restart journal

lcl_rec_icpl Getting next journal to recover from

lcl_rec_cpl Processed all journals for local recovery

shd_rec Shadow recovery

shd_rec_fail Shadow server waiting for access to a restart journal

shd_rec_icpl Shadow getting next journal to recover from

shd_rec_cpl Processed all journals for shadow recovery

catchup Secondary is catching up with primary

standby Server is declared as standby

active Server is active

pri_act Server is active as primary shadow

sec_act Server is active as secondary shadow

remember Primary is running without shadow secondary

The Flags: field of the SHOW SERVER command can display the following values:

Table 7-23 Server Flags
FLAG Meaning

BEC Backend callout

EXA Explicit accept

EXP Explicit prepare

NCC No concurrent

NSB No standby

SHD Shadow

SRV Server

TRC Router callout

**Table 7-22 Key-Range States**
State	Meaning
wt_tr_ok	Server is waiting for routers to accept it
wt_quorum	Server is waiting for backend to be quorate
lcl_rec	Local recovery
lcl_rec_fail	Primary server waiting for access to a restart journal
lcl_rec_icpl	Getting next journal to recover from
lcl_rec_cpl	Processed all journals for local recovery
shd_rec	Shadow recovery
shd_rec_fail	Shadow server waiting for access to a restart journal
shd_rec_icpl	Shadow getting next journal to recover from
shd_rec_cpl	Processed all journals for shadow recovery
catchup	Secondary is catching up with primary
standby	Server is declared as standby
active	Server is active
pri_act	Server is active as primary shadow
sec_act	Server is active as secondary shadow
remember	Primary is running without shadow secondary

**Table 7-23 Server Flags**
FLAG	Meaning
BEC	Backend callout
EXA	Explicit accept
EXP	Explicit prepare
NCC	No concurrent
NSB	No standby
SHD	Shadow
SRV	Server
TRC	Router callout

Qualifiers

/CLUSTER

/NOCLUSTER (D)
Specifies that the command is executed on all the nodes in the cluster.
If neither /NODE nor /CLUSTER is specified, the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered, the command is executed only on the node where the command was issued.

Note
In environments that do not support remote command capability, the /CLUSTER qualifier causes the relevant command to be executed on the local node only. See Section 1.4 for more information.

/IDENTIFICATION=process-id

/NOIDENTIFICATION (D)
Specifies the PID of the process for which information should be displayed. The default (/NOIDENTIFICATION) displays information for all servers.
/FACILITY

/FACILITY="*" (D)
Specifies the facility name for which information should be displayed.
By default, information is displayed for all facilities.
/FULL

/NOFULL (D)
Specifies a detailed listing of server information.
/NODE[=node-list]

/NODE=default-node (D)
Specifies that the command is executed on all nodes specified in node-list . If node-list is omitted, the command is executed only on the node where the command was issued.
/OUTPUT[=filespec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file filespec . If /OUTPUT or filespec is omitted, the standard or default output is used.

Examples


RTR> SHOW SERVER Servers: Process-id Facility Channel Flags State 20828 RTR$DEFAULT_FACILITY 589825 SRV active 20828 RTR$DEFAULT_FACILITY 655362 SRV active RTR> SHOW SERVER/FULL Servers on node NODEA in group "groupa" at Tue Jul 18 15:00:17 2000 Process-id: 27C3EEAE Configuration:- Facility: RTR$DEFAULT_FACILITY Channel: 803667970 Flags: SRV State: active Low Bound: 0 High Bound 4294967295 rcpnam: "RTR$DEFAULT_CHANNEL" User Events: 0 RTR Events: 0 Partition name: RTR$DEFAULT_PARTITION_167777217

RTR> SHOW SERVER 
Servers: 
 
Process-id   Facility                     Channel   Flags     State 
20828        RTR$DEFAULT_FACILITY         589825    SRV       active 
20828        RTR$DEFAULT_FACILITY         655362    SRV       active 
 
RTR> SHOW SERVER/FULL 
 
Servers on node NODEA in group "groupa" at Tue Jul 18 15:00:17 2000 
 
Process-id:              27C3EEAE     
 
Configuration:- 
 
Facility:    RTR$DEFAULT_FACILITY 
Channel:                803667970      Flags:                           SRV 
State:                     active      Low Bound:                         0 
High Bound             4294967295      rcpnam:        "RTR$DEFAULT_CHANNEL" 
User Events:                    0      RTR Events:                        0 
Partition name:                             RTR$DEFAULT_PARTITION_167777217

SHOW TRANSACTION

The SHOW TRANSACTION command displays information about currently active transactions.

Format

SHOW TRANSACTION [transaction-id]

Command Qualifiers	Defaults
/BACKEND	/NOBACKEND
/BEFORE[=date]	today
/CLUSTER	/NOCLUSTER
/FACILITY[=facility-name]	/FACILITY="*"
/FRONTEND	/NOFRONTEND
/FULL=keyword	/NOFULL
/IDENTIFICATION=process-id	/NOIDENTIFICATION
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout
/PARTITION=partition_name	None
/ROUTER	/NOROUTER
/SINCE[=date]	today
/STATE=current_state	None
/USER=username	All users

Description

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

Parameters

transaction-id
Specifies a particular transaction or transactions whose transaction state you want to display. If no transaction_id is specified, all transactions (*) that satisfy the specifying qualifiers are processed by the command.

Qualifiers

/BACKEND

/NOBACKEND (D)
Specifies that information should be listed for transactions in a backend node. If neither /BACKEND, /FRONTEND nor /ROUTER are specified, information for all of them is displayed. If either /FRONTEND or /ROUTER is specified, the default (/NOBACKEND) inhibits display of backend transaction information.
The Invocation field of SHOW TRANSACTION /BACKEND /FULL shows the following information:

Table 7-24 Transaction Invocation Types
Type Meaning

ORIGINAL Original transaction

REPLAY Replayed transaction

RECOVERY Shadow recovery transaction

WaitOnExcept Transaction is pending manual intervention

/BEFORE[=date]
Selects only those transactions whose timestamp is before the specified date. Default is the current date.
/CLUSTER

/NOCLUSTER (D)
Specifies that the command is executed on all the nodes in the cluster.
If neither /NODE nor /CLUSTER is specified, the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered, the command is executed only on the node where the command was issued.

Note
In environments that do not support remote command capability, the /CLUSTER qualifier causes the relevant command to be executed on the local node only. See Section 1.4 for more information.

/FACILITY

/FACILITY="*" (D)
Specifies the facility name for which information should be displayed.
By default, information is displayed for all facilities.
/FRONTEND

/NOFRONTEND (D)
Specifies that information should be listed for transactions in a frontend node. If neither /BACKEND, /FRONTEND nor /ROUTER are specified, information for all of them is displayed. If either /BACKEND or /ROUTER is specified, the default (/NOFRONTEND) inhibits display of frontend transaction information.
/FULL=keyword

/NOFULL (D)
Produces a detailed listing of transaction information. keyword can be either STANDARD or WIDE. STANDARD is the default value and provides the display seen in versions of RTR prior to Version 4.0. WIDE supports display field values of more than 36 character without truncation.
/IDENTIFICATION=process-id

/NOIDENTIFICATION (D)
Specifies the PID of the process for which information is displayed. The default (/NOIDENTIFICATION) displays information for all processes.
/NODE[=node-list]

/NODE=default-node (D)
Specifies that the command is executed on all nodes specified in node-list . If node-list is omitted, the command is executed only on the node where the command was issued.
/OUTPUT[=filespec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file filespec . If /OUTPUT or filespec is omitted, the standard or default output is used.
/PARTITION

/PARTITION=partition_name
Specifies that information should be listed for the indicated partition. A partition name must be supplied.

Previous Next Contents Index

Type	Meaning
ORIGINAL	Original transaction
REPLAY	Replayed transaction
RECOVERY	Shadow recovery transaction
WaitOnExcept	Transaction is pending manual intervention

Reliable Transaction RouterSystem Manager's Manual

SHOW PROCESS

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/COUNTER[=counter-name]

/NOCOUNTER (D)

/IDENTIFICATION=process-id

/NOIDENTIFICATION (D)

/FULL

/NOFULL (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

Examples

SHOW REQUESTER

SHOW RESOURCE_MANAGER (SHOW RM)

Format

Description

Parameters

resource_name

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/FULL

/NOFULL (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

Related commands

Examples

SHOW RTR

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/COUNTER[=counter-name]

/NOCOUNTER (D)

/FULL

/NOFULL (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

/STATUS (D)

/NOSTATUS

/VERSION

/NOVERSION (D)

Related commands

Example

SHOW SEGMENT

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/FACILITY

/FACILITY="*" (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

Examples

SHOW SERVER

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/IDENTIFICATION=process-id

/NOIDENTIFICATION (D)

/FACILITY

/FACILITY="*" (D)

/FULL

/NOFULL (D)

Reliable Transaction Router
System Manager's Manual