onstat -g sds command: Print SD secondary server information

Use the onstat -g sds command to display information about shared-disk secondary servers.


Syntax:

>>-onstat-- -g -sds -+-----------------+-----------------------><
                     '-+-server_name-+-'   
                       '-verbose-----'

The output of the onstat -g sds command differs slightly depending on whether the command is issued on the primary server or on the SD secondary server.

Invocation	Explanation
onstat -g sds	Displays brief SD secondary server information
onstat -g sds verbose	Displays detailed SD secondary server information
onstat -g sds `server_name`	Displays information about a specific SD secondary server. When `server_name` is specified, the command must be issued from the primary server.

Example output (primary server)

Figure 1. onstat -g sds command output when you run the command from primary server.

Local server type: Primary
Number of SDS servers:1

SDS server information

SDS srv      SDS srv      Connection        Last LPG sent  Supports
name         status       status            (log id,page)  Proxy Writes
C_151162     Active       Connected             554,4998   Y

Output description (primary server)

Local server type: Primary or SDS (shared disk secondary) server type
Number of SDS servers: Number of SD secondary servers connected to the primary server
SDS Srv name: Name of SD secondary server
SDS Srv status: Displays whether SD secondary server is active
Connection status: Displays whether SD secondary server is connected
Last LPG sent (log id, page): Most recent LPG log ID and page
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 verbose option (primary server)

Figure 2. onstat -g sds server_name command output when you run the command from primary server.

Number of SDS servers:2
Updater node alias name :server_1

SDS server control block: 0x46217640
server name: rahulb_4
server type: SDS
server status: Active
connection status: Connected
Last log page sent(log id,page):6,44
Last log page flushed(log id,page):6,44
Last log page acked (log id, page):6,44
Last LSN acked (log id,pos):6,180664
Last log page applied(log id,page): 6,44
Approximate Log Page Backlog:0
Current SDS Cycle:19
Acked SDS Cycle:19
Sequence number of next buffer to send: 447
Sequence number of last buffer acked: 444
Time of last ack:2020/05/23 06:16:28
Supports Proxy Writes: N
Time of last received message: 2020/05/23 06:16:49
Time of last alternate write: N/A
Time of last alternate read : N/A
Total number of delay(s): 11
Time of last delay: 2020/05/23 06:13:04

Output description with verbose option (primary server)

Number of SDS servers: The number of SD secondary servers that share disk space with the primary server
Updater node alias name: The name of the primary server
SDS server control block: SD secondary server control block
server name: The name of the server
server type: The type of server
server status: Displays whether the server is active or inactive
connection status: Status of connection between primary and secondary server
Last log page sent (log id, page): Log ID and page of most recent log page sent
Last log page flushed (log id, page): Log ID and page of the most recent log page flushed
Last log page acked (log id, pos)): Most recent log page acknowledged
Last LSN acked (log id, pos): Most recent log sequence number that was acknowledged
Last log page applied(log id,page): The log ID and page number of the last applied log
Approximate Log Page Backlog: The number of logs waiting to be sent
Current® SDS Cycle: Used internally by support to monitor coordination of the primary server with the SDS server
Acked SDS Cycle: Used internally by support to monitor coordination of the primary server with the SDS server
Sequence number of next buffer to send: Sequence number of next buffer to send
Sequence number of last buffer acked: Sequence number of next buffer acknowledged
Time of last ack: Date and time of last log acknowledgment
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.
Time of last received message:: The timestamp of the current server's most recently received from another server.
Time of last alternate write: The timestamp of the current server's most recent write to the blobspace specified by the SDS_ALTERNATE configuration parameter.
Time of last alternate read: The timestamp of the current server's most recent read from the blobspace specified by the SDS_ALTERNATE configuration parameter.
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 verbose option (SD secondary server)

Figure 3. onstat -g sds verbose command output when you run the command from the SD secondary server.

SDS server control block: 0xb299880
Local server type: SDS
Server Status : Active
Source server name: my_source_server
Connection status: Connected
Last log page received(log id,page): 7,884
Next log page to read(log id,page):7,885
Last LSN acked (log id,pos):7,3621272
Sequence number of last buffer received: 0
Sequence number of last buffer acked: 0
Current paging file:/dbspaces/page_my_source_server_sdc1_
Current paging file size:2048
Old paging file:/dbspaces/page_my_source_server_sdc1_
Old paging file size:10240

Output description with verbose option (SD secondary server)

SDS server control block: SD secondary server control block
Local server type: Primary or SDS (shared disk secondary) server type
Server status: Displays whether SD secondary server is active
Source server name: Displays name of primary server
Connection status: Displays whether SD secondary server is connected
Last log page received (log id, page): Most recent log page received
Next log page to read (log id,page): Next log page in sequence to read
Last LSN acked (log id,pos): Most recent LSN acknowledged
Sequence number of last buffer received: Sequence number of last buffer received
Sequence number of last buffer acked: Sequence number of last buffer acknowledged
Current paging file: Name of current paging file
Current paging file size: Size of current paging file
Old paging file: Name of previous paging file
Old paging file size: Size of previous paging file