onstat -g sds command: Print SD secondary server information

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

Read syntax diagramSkip visual syntax diagram
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:1
Updater node alias name: server_1
SDS server control block: 0x4d6a5e08
server name: server_2
server type: SDS
server status: Active
connection status: Connected
Last log page sent(log id,page):5,1829
Last log page flushed(log id,page):5,1829
Last log page acked (log id, page):5,1829
Last LSN acked (log id,pos):5,7492024
Last log page applied(log id,page): 5,1829
Approximate Log Page Backlog:0
Current SDS Cycle:1054
Acked SDS Cycle:1054
Sequence number of next buffer to send: 84329
Sequence number of last buffer acked: 84326
Time of last ack:2013/12/12 09:13:49
Supports Proxy Writes: N
Time of last received message: 2013/12/12 09:13:49
Time of last alternate write: N/A
Time of last alternate read : N/A

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 IBM® support to monitor coordination of the primary server with the SDS server
Acked SDS Cycle
Used internally by IBM 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.

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

Copyright© 2019 HCL Technologies Limited