onstat -g rss command: Print RS secondary server information

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

Figure 1: Syntax:

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 2: 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: 2020/05/23 06:12:06
Number of RSS servers: 2

RSS Server information:

RSS Server control block: 0x64f64758
RSS server name: rahulb_3
RSS server status: Active
RSS connection status: Connected
RSS flow control:384/352
Log transmission status: Active
Next log page to send(log id,page): 6,36
Last log page acked(log id,page): 6,35
Last log page applied(log id,page): 6,35
Time of Last Acknowledgement: 2020-05-23.06:13:29
Pending Log Pages to be ACKed: 0
Approximate Log Page Backlog:0
Sequence number of next buffer to send: 231
Sequence number of last buffer acked: 230
Supports Proxy Writes: N
Total number of delay(s): 8
Time of last delay: 2020-05-23.06:13:02

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.
Total number of delay(s): The total number of times the flow delay occurred.
Time of last delay: The time of last delay in flow control.

Example output with log option (primary server)

Figure 3: 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 4: 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 5: 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.