onstat -g rss command: Print RS secondary server information

Use the onstat -g rss commands to display information about remote standalone secondary servers.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -g--rss--+-------------+---------------------------><
                     +-verbose-----+   
                     +-log---------+   
                     '-server_name-'   

The output of the onstat -g rss command differs slightly depending on whether the command is run on the primary server or on the RS secondary server.

Invocation Explanation
onstat -g rss Displays brief RS secondary server information
onstat -g rss verbose Displays detailed RS secondary server information
onstat -g rss log Displays log information. This command is only applicable when run on the primary server.
onstat -g rss server_name Displays information about a specific RS secondary server. This command is only applicable when run on the primary server.

Example output (primary server)

Figure 1. onstat -g rss verbose command output, when the command is run on the primary server.
Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2009/08/31 09:35:22
Number of RSS servers: 1

RSS Server information:

RSS Server control block: 0x5fdd9740
RSS server name: serv3
RSS server status: Active
RSS connection status: Connected
RSS flow control:576/528
Log transmission status: Active
Next log page to send(log id,page): 53,117632
Last log page acked(log id,page): 53,115615
Last log page applied (log id, page); 53,115615
Time of Last Acknowledgment: 2009-08-31.14:14:09
Pending Log Pages to be ACKed: 1984
Approximate Log Page Backlog:97104
Sequence number of next buffer to send: 3676
Sequence number of last buffer acked: 3612
Supports Proxy Writes: Y

Output description (primary server)

Local server type
Primary or RSS (remote standalone secondary) server type
Index page logging status
Displays whether index page logging is enabled or disabled between primary server and secondary server
Index page logging was enabled at
Date and time that index page logging was enabled
Number of RSS servers
Number of RS secondary servers connected to the primary server
RSS Server control block
RS secondary server control block
RSS Server name
Name of RS secondary server
RSS Server status
Displays whether RS secondary server is active or not
RSS flow control
Values, in number of logical log pages, determining when flow control is enabled or disabled, respectively.
RSS Connection status
Connection status of RS secondary server
Log transmission status
Displays whether log transmission is active or inactive
Next log page to send (log id, page)
The log ID and page number of the next log page that will be sent
Last log page acked (log id, page)
The log ID and page number of the last acknowledged log
Last log page applied (log id, page)
The log ID and page number of the last applied log
Time of Last Acknowledgment
The time at which the last log was acknowledged
Pending Log pages to be ACKed
The number of logs sent but not yet acknowledged
Approximate Log Page Backlog
The difference between the number of logs that were sent and the end of the logical log
Sequence number of next buffer to send
The sequence number of the next buffer to be sent
Sequence number of last buffer acked
The sequence number of the last acknowledged buffer
Supports Proxy Writes
Displays whether the server is currently configured to allow updates to secondary servers. Y = supports updates to secondary servers, N = does not support updates to secondary servers.

Example output with log option (primary server)

Figure 2. onstat -g rss log command output, when the command is run on the primary server.
Log Pages Snooped:
RSS Srv         From      From      Tossed
name             Cache     Disk     (LBC full)

cdr_ol_nag_1_c1    1368       1331      0
cdr_ol_nag_1_c2    1357       1342      0
cdr_ol_nag_1_c3    1356       1343      0

Output description with log option (primary server)

Log Pages Snooped
Statistics for each RS secondary server
RSS Srv name
RS secondary server name
From Cache
From cache number
From Disk
Log from disk
Tossed (LBC full)
Number of log pages that were discarded as a result of the LBC becoming full

Example output (RS secondary server)

Figure 3. onstat -g rss command output, when the command is run on the RS secondary server.
Local server type: RSS
Server Status: Active
Source server name: cdr_ol_nag_1
Connection status: Connected
Last log page received(log id,page): 7,877

Output description (RS secondary server)

Local server type
Primary or RSS (remote standalone secondary) server type
Server Status
Displays whether RS secondary server is active
Source server name
Name of the primary server
Connection status
Connection status of RS secondary server
Last log page received (log id,page)
Most recent log ID and page received

Example output with verbose option (RS secondary server)

Figure 4. onstat -g rss verbose command output, when the command is run on the RS secondary server.
RSS Server control block: 0x45a3fe58
Local server type: RSS
Server Status: Active
Source server name: my_server
Connection status: Connected
Last log page received(log id,page): 10,1364
Sequence number of last buffer received: 489
Sequence number of last buffer acked: 489
Delay Apply: Configured (3)
Stop Apply: Not configured.
Delay or Stop Apply control block: 0x45a40ba8
    Pending pages: 7
    Last page written: (10:1372).
    Next page to read: (10:1366).
    Delay or Stop Apply thread: Running.

Output description with verbose option (RS secondary server)

RSS Server control block
The server control block.
Local server type
The local server's type.
Server Status
The status of the RS secondary server.
Source server name
The name of the primary server in the RS secondary server's high-availability cluster.
Connection status
The status of the connection between the RS secondary server and the cluster's primary server.
Last log page received (log id,page)
The log ID and page number of the last log acknowledged by the RS secondary server.
Sequence number of last buffer received
The sequence number of the last buffer that was received by the RS secondary server.
Sequence number of last buffer acked
The sequence number of the last buffer acknowledged by the RS secondary server.
Delay Apply
Whether delay apply is configured or not. The delay value, in seconds, is included in parentheses.
Stop Apply
Whether stop apply is configured or not. The stop value, which is enclosed in parentheses, is either 1 or a Unix time.
Delay or Stop Apply control block
The control block of the delay or the stop apply.
Pending pages
The number of pages that are waiting to be written to the log-staging directory.
Last page written
The log id and page number of the log that was most recently written to the log-staging directory.
Next page to read
The log id and page number of the next log to write to the log-staging directory.
Delay or Stop Apply thread
The status of the delay-apply or stop-apply thread.

Copyright© 2019 HCL Technologies Limited