Reliable Transaction Router
System Manager's Manual

SHOW LINK

Display 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-list
/OUTPUT[=file-spec]	/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 wild cards ("*" and "%"), in which case all matching links will be 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 then the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered then the command is executed only on the node where the command was issued.
Note: In environments that do not support clustering, use of the /CLUSTER qualifier will cause 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-list (D)
Specifies that the command is executed on all nodes specified in node-list. If node-list is omitted then the command is executed only on the node where the command was issued.
/OUTPUT[=file-spec]

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

/NOSTATE (D)
Specifies that a detailed status of the specified link(s) 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

Display the names of the current log files.

Format

SHOW LOG

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/NODE[=node-list]	/NODE=default-node-list
/OUTPUT[=file-spec]	/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 then the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered then the command is executed only on the node where the command was issued.
Note: In environments that do not support clustering, use of the /CLUSTER qualifier will cause the relevant command to be executed on the local node only.
/NODE[=node-list]

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

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file file-spec. If /OUTPUT or file-spec is omitted then 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)

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

SHOW MODE

Displays the current RTR mode.

Format

SHOW MODE

Command Qualifiers	Defaults
/CLUSTER	/NOCLUSTER
/NODE[=node-list]	/NODE=default-node-list
/OUTPUT[=file-spec]	/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 then the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered then the command is executed only on the node where the command was issued.
Note: In environments that do not support clustering, use of the /CLUSTER qualifier will cause the relevant command to be executed on the local node only.
/NODE[=node-list]

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

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

Related Commands

SET MODE

Examples

 RTR> SHOW MODE  
  
 Group name is "develop"

SHOW NODE

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-list
/OUTPUT[=file-spec]	/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 then the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered then the command is executed only on the node where the command was issued.
Note: In environments that do not support clustering, use of the /CLUSTER qualifier will cause the relevant command to be executed on the local node only.
/NODE[=node-list]

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

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file file-spec. If /OUTPUT or file-spec is omitted then 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.
Network status
Auto isolation state (enabled or disabled).
Inactivity timer value in seconds.

SHOW PARTITION

Display server data partition information.

Format

SHOW PARTITION

Command Qualifiers	Defaults
/BACKEND	/BACKEND
/BRIEF	/NOBRIEF
/CLUSTER	/NOCLUSTER
/FACILITY	/FACILITY="*"
/FULL	/NOFULL
/NODE[=node-list]	/NODE=default-node-list
/OUTPUT[=file-spec]	/OUTPUT=stdout
/ROUTER	/ROUTER

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 6-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 6-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 6-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 6-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 my 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 then the command is executed on the nodes specified by the latest SET ENVIRONMENT command. If no SET ENVIRONMENT command has been entered then the command is executed only on the node where the command was issued.
Note: In environments that do not support clustering, use of the /CLUSTER qualifier will cause 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_compatibilty

The SHOW PARTITION comand 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-list (D)
Specifies that the command is executed on all nodes specified in node-list. If node-list is omitted then the command is executed only on the node where the command was issued.
/OUTPUT[=file-spec]

/OUTPUT=stdout (D)
Specifies that the resulting information is written to the file file-spec. If /OUTPUT or file-spec is omitted then 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 four bytes are shown.

Examples

The following example shows a router partition.

RTR> SHOW PARTITION/ROUTER 
 
Facility                       Low Bound        High Bound       Primary Main 
RTR$DEFAULT_FACILITY           0                4294967295       depth 
 
RTR> SHOW PARTITION/ROUTER/FULL 
 
Facility:       RTR$DEFAULT_FACILITY     State:                        ACTIVE 
Low Bound:                         0     High Bound:               4294967295 
Failover policy:                                              fail_to_standby 
Backends:                                                               depth 
States:                                                                active 
Primary Main:                  depth     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

Contents

Index

Reliable Transaction RouterSystem Manager's Manual

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-list (D)

/OUTPUT[=file-spec]

/OUTPUT=stdout (D)

/STATE

/NOSTATE (D)

Related Commands

Example

SHOW LOG

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/NODE[=node-list]

/NODE=default-node-list (D)

/OUTPUT[=file-spec]

/OUTPUT=stdout (D)

Related Commands

Example

SHOW MODE

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/NODE[=node-list]

/NODE=default-node-list (D)

/OUTPUT[=file-spec]

/OUTPUT=stdout (D)

Related Commands

Examples

SHOW NODE

Format

Description

Qualifiers

/CLUSTER

/NOCLUSTER (D)

/NODE[=node-list]

/NODE=default-node-list (D)

/OUTPUT[=file-spec]

/OUTPUT=stdout (D)

Related Commands

Examples

SHOW PARTITION

Format

Description

Qualifiers

/BACKEND

/NOBACKEND (D)

/BRIEF

/NOBRIEF (D)

/CLUSTER

/NOCLUSTER (D)

/FACILITY

/FACILITY="*" (D)

/FULL

/NOFULL (D)

/NODE[=node-list]

/NODE=default-node-list (D)

/OUTPUT[=file-spec]

/OUTPUT=stdout (D)

/ROUTER

/NOROUTER (D)

Examples

Reliable Transaction Router
System Manager's Manual