Reliable Transaction Router
System Manager's Manual
Previous Contents Index

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 clustering, the /CLUSTER qualifier causes the relevant command to be executed on the local node only.

/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 clustering, the /CLUSTER qualifier causes the relevant command to be executed on the local node only.

/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

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 clustering, the /CLUSTER qualifier causes the relevant command to be executed on the local node only.

/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

Example


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

  1. Shows the state and configuration of RTR.
  2. 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 clustering, the /CLUSTER qualifier causes the relevant command to be executed on the local node only.

/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

  1. Shows the routing key segments for all facilities.
  2. 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

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 clustering, the /CLUSTER qualifier causes the relevant command to be executed on the local node only.

/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

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

/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 clustering, the /CLUSTER qualifier causes the relevant command to be executed on the local node only.

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

Use SHOW PARTITION to view the names of the currently active partitions.

/ROUTER

/NOROUTER (D)

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

The Key-Range-State field for SHOW TRANSACTION /ROUTER /FULL shows the following states:

Table 7-25 Key-Range States
State Meaning
locl_rec Local recovery in progress
shad_rec Shadow recovery in progress
active Active non-shadowed
sec_act Secondary active
pri_act Primary active
pri_lone Primary running alone
sec_chup Secondary is catching up

/SINCE[=date]

Selects only those transactions whose timestamp is after the specified date. Default is the current date.

/STATE=current_state

Displays a particular transaction or a set of transactions that are in the specified current_state transaction state. This qualifier is required and the current_state value must be specified.

Previous Next Contents Index