Reliable Transaction Router
System Manager's Manual

Shows the disks used for RTR's recovery journal and the file names
Shows two disks are currently in use
Shows device name
Shows file size in blocks
Shows allocated file size in blocks
Shows maximum file size in blocks
Filename

SHOW KEY

The SHOW KEY command displays the key definitions created by the DEFINE /KEY command.

Format

SHOW KEY [key-name]

Command Qualifiers	Defaults
/ALL	/NOALL
/FULL	/NOFULL
/OUTPUT[=filespec]	/OUTPUT=stdout
/IF_STATE	/NOIF_STATE

Description

The SHOW KEY command shows the key definitions created by the DEFINE /KEY command.

Parameters

key-name
Specifies the name of the key whose definition you want displayed. See the description of the DEFINE /KEY command for a list of the valid key names.

Qualifiers

/ALL

/NOALL (D)
Requests that all key definitions in the current state be displayed. You can use the /IF_STATE qualifier to request key definitions in other states. Do not specify a key name with the /ALL qualifier. If no state is specified, all key definitions in the current state are displayed.
/FULL

/NOFULL (D)
Requests that all qualifiers associated with a definition are displayed. By default, only the state of the definition and the definition itself are displayed.
/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.
/IF_STATE=state-name

/NOIF_STATE (D)
Specifies the name of a state for which the specified key definitions are displayed. State names can be any appropriate alphanumeric string. State names are created with the DEFINE /KEY command. If you omit the /IF_STATE qualifier or use /NOIF_STATE, key definitions in the current state are displayed.

Related commands

DEFINE /KEY

Examples


RTR> SHOW KEY/FULL DEFAULT PF1 defined as "" DEFAULT KP0 defined as "MONITOR/RESUME" DEFAULT KP2 defined as "SCROLL DOWN 1" DEFAULT KP4 defined as "SCROLL LEFT 1" DEFAULT KP5 defined as "SCROLL HOME" DEFAULT KP6 defined as "SCROLL RIGHT 1" DEFAULT KP8 defined as "SCROLL UP 1" GOLD KP2 defined as "SCROLL DOWN 10" GOLD KP4 defined as "SCROLL LEFT 10" GOLD KP6 defined as "SCROLL RIGHT 10" GOLD KP8 defined as "SCROLL UP 10"

 RTR> SHOW KEY/FULL  
 DEFAULT PF1 defined as ""
 DEFAULT KP0 defined as "MONITOR/RESUME"
 DEFAULT KP2 defined as "SCROLL DOWN 1"
 DEFAULT KP4 defined as "SCROLL LEFT 1"
 DEFAULT KP5 defined as "SCROLL HOME"
 DEFAULT KP6 defined as "SCROLL RIGHT 1"
 DEFAULT KP8 defined as "SCROLL UP 1"
 GOLD KP2 defined as "SCROLL DOWN 10"
 GOLD KP4 defined as "SCROLL LEFT 10"
 GOLD KP6 defined as "SCROLL RIGHT 10"
 GOLD KP8 defined as "SCROLL UP 10"

SHOW LINK

The SHOW LINK command displays the configuration and status of the links to other nodes.

Format

SHOW LINK [node-name]

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/COUNTER[=counter-name]	/NOCOUNTER
/FACILITY	/NOFACILITY
/FULL	/NOFULL
/NODE[=node-list]	/NODE=default-node
/OUTPUT[=filespec]	/OUTPUT=stdout
/STATE	/NOSTATE

Description

The SHOW LINK command shows the configuration and status of the links to RTR nodes. If no qualifiers are given, a brief display of the links is shown.

Parameters

node-name
Specifies the name of a node; the parameters for the link to this node are displayed. Node-name may contain wildcards (* and %), in which case all matching links are displayed. If node-name is omitted, all known links 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.

/COUNTER[=counter-name]

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

/NOFACILITY (D)
Specifies that the names of facilities using the link are also displayed.
/FULL
Equivalent to specifying /FACILITY/STATE.
/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.
/STATE

/NOSTATE (D)
Specifies that a detailed status of the specified link is displayed.

Related commands

SET LINK
CREATE FACILITY
SHOW FACILITY/LINK

Example

RTR> SHOW LINK/FULL IRON Links: To Node: iron Address: iron.zuo.dec.com Status:- Outgoing message sequence nr: 22 Incoming message sequence nr: 22 Current receive buffer size: 2048 Current transmit buffer size: 2048 Current number of link users: 1 Write buffer timed out: no Write buffer full, may be sent: no Write buffer allocated: yes I/O error detected in write: no I/O error detected in read: no Pipe temporarily blocked: no Connection broken: no Write issued, not completed: no Read is pending: yes Node initiated the connection: yes Connection established: yes Connection in progress: no Node is configured: yes Link is in disabled state: no Link may be suspect: no Facilities:- In facility: steve2 Frontend: no Router: yes Backend: no Router -> Frontend: no Frontend -> Router: yes Backend -> Router: no Router -> Backend: no Router quorate: no Backend quorate: no Router current: yes Backend coordinator:no

This example shows the:

Name and network address of the partner node.
Link status.
Name of facility using this link and how the link is used in the facility.

SHOW LOG

The SHOW LOG command displays the names of the current log files.

Format

SHOW LOG

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

Description

The SHOW LOG command shows the names of the current RTR log files as defined with the SET LOG command.

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.

/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

SET LOG

Example


RTR> SHOW LOG (1) Messages not being sent to operator console (2) Log file[1]: /usr/users/someone/rtr_logfile.log (3)

Shows where RTR log messages are currently written
Shows log messages are currently not being sent to the operator log.
Shows log messages are currently being written to file rtr_logfile.log .

SHOW MODE

The SHOW MODE command displays the current RTR mode.

Format

SHOW MODE

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

Description

The SHOW MODE command shows the currently running user group for RTR. For nogroup (system) mode, a null group name is displayed. SET MODE command for further information about modes.

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.

/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

SET MODE

Examples


RTR> SHOW MODE Group name is "develop"

SHOW NODE

The SHOW NODE command shows the node network status, the autoisolation state and the node inactivity timer.

Format

SHOW NODE

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

Description

The SHOW NODE shows the network status, the autoisolation state (enabled or disabled) and the node inactivity timer.

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.

/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

SET NODE/ISOLATE
SET LINK

Examples


RTR> SHOW NODE (1) Node properties: Network state: enabled (2) Auto isolation: disabled (3) Inactivity timer/s: 60 (4)

SHOW NODE command
Shows network status
Shows auto isolation state (enabled or disabled)
Shows inactivity timer value in seconds

SHOW PARTITION

The SHOW PARTITION command displays server data partition information.

Format

SHOW PARTITION

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

Description

The SHOW PARTITION command displays information about key range partitions, their states, and current transaction activity. This information is useful for diagnosing bottlenecks or partition difficulties in RTR.
The States field of SHOW PARTITION /BACKEND can display the following values:

Table 7-20 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 State field of SHOW PARTITION /ROUTER can display the following values:

Table 7-21 Router Partition States
State Meaning

BLOCKED Key range is recovering or awaiting journal access

ACTIVE Primary server is ready to accept transactions

CATCHUP Secondary server is catching up with primary

TAKEOVR Standby take-over is in progress

LAGGING Secondary is ready, primary is still recovering

**Table 7-20 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-21 Router Partition States**
State	Meaning
BLOCKED	Key range is recovering or awaiting journal access
ACTIVE	Primary server is ready to accept transactions
CATCHUP	Secondary server is catching up with primary
TAKEOVR	Standby take-over is in progress
LAGGING	Secondary is ready, primary is still recovering

Qualifiers

/BACKEND

/NOBACKEND (D)
Displays information about backend partitions; it shows the partition state and low and high bounds. /BACKEND with /FULL provides more detailed information for a partition, giving the current queue depth (transactions active) on a partition. This is useful for determining whether a server is processing transactions correctly.

Last Rcvy BE: shows from which node recovery information may be fetched.
Txns Rcvrd: shows the number of transactions actually recovered.
The default is to output brief router and backend information.
/BRIEF

/NOBRIEF (D)
Brief output gives a one-line listing of each partition in the system, showing the partition name, the facility in which it resides, and the partition state. Since space on the line is limited, partition names may be truncated to fit.
/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.
/FULL

/NOFULL (D)
Gives a detailed listing of server partition information.
The following items are displayed:

Key segment low and high bounds
Counts of the active and free servers bound to the partition
Counts of the active and recovered transactions for the partition
The state of transaction presentation - one of active, suspended or suspending
The current failover policy - one of fail_to_standby , fail_to_shadow or pre_v32_compatibility

The SHOW PARTITION command displays callout server data as backend server data because a callout server uses server, not router, data structures. A callout server actually runs on the router identified for its facility.
/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.
/ROUTER

/NOROUTER (D)
Displays information about router partitions; it shows the partition state and partition low and high bounds. It can be used to quickly determine the current primary node for a given partition. Using /ROUTER with /FULL provides more detailed information, such as the main, shadow and standby servers for the partitions, as seen from the router.
Partition bounds are shown as ASCII characters if there is a translation, otherwise as hexadecimal digits. Only the least significant 4 bytes are shown.

Examples

The following example shows a router partition.


RTR> SHOW PARTITION/ROUTER Low Bound High Bound Primary Main 0 4294967295 node10 RTR> SHOW PARTITION/ROUTER/FULL Facility: RTR$DEFAULT_FACILITY State: ACTIVE Low Bound: 0 High Bound: 4294967295 Failover policy: fail_to_standby Backends: node10 States: active Primary Main: node10 Shadow Main:

RTR> SHOW PARTITION/ROUTER 
 
Low Bound        High Bound       Primary Main 
0                4294967295       node10 
 
RTR> SHOW PARTITION/ROUTER/FULL 
 
Facility:       RTR$DEFAULT_FACILITY     State:                        ACTIVE 
Low Bound:                         0     High Bound:               4294967295 
Failover policy:                                              fail_to_standby 
Backends:                                                              node10 
States:                                                                active 
Primary Main:                  node10    Shadow Main:

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

Contents

Index

Reliable Transaction RouterSystem Manager's Manual

SHOW KEY

Format

Description

Parameters

key-name

Qualifiers

/ALL

/NOALL (D)

/FULL

/NOFULL (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

/IF_STATE=state-name

/NOIF_STATE (D)

Related commands

Examples

SHOW LINK

Format

Description

Parameters

node-name

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/COUNTER[=counter-name]

/NOCOUNTER (D)

/FACILITY

/NOFACILITY (D)

/FULL

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

/STATE

/NOSTATE (D)

Related commands

Example

SHOW LOG

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

Related commands

Example

SHOW MODE

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

Related commands

Examples

SHOW NODE

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/NODE[=node-list]

/NODE=default-node (D)

/OUTPUT[=filespec]

/OUTPUT=stdout (D)

Related commands

Examples

SHOW PARTITION

Format

Description

Qualifiers

/BACKEND

/NOBACKEND (D)

Reliable Transaction Router
System Manager's Manual