onstat -g cluster command: Print high-availability cluster information

Use the onstat -g cluster command to display information about the servers in a high-availability cluster environment.

Figure 1: Syntax:

1  onstat   -g cluster
2.1 verbose

The onstat -g cluster command combines the functionality of onstat -g dri, onstat -g sds, and onstat -g rss. The output of the onstat -g cluster command differs slightly depending on whether the command is run on the primary server or on one of the secondary servers.

Example output (primary server)

Following is sample output from the onstat -g cluster command. The sample shows output when the command is run on the primary server.

Figure 2: onstat -g cluster command output (run on the primary server)
	
	Primary Server:serv1
	Current Log Page:16,476
	Index page logging status: Enabled
	Index page logging was enabled at: 2013/12/11 14:05:17
	
	
	Server ACKed Log    Applied Log  Supports     Status
	       (log, page)  (log, page)  Updates
	serv2  16,476       16,476       Yes          SYNC(SDS),Connected,Active
	serv3  16,476       16,476       Yes          ASYNC(HDR),Connected,On
	serv4  16,476       16,476       Yes          ASYNC(RSS),Connected,Active

Output description (primary server)

Primary server
The name assigned to the primary server.
Current® log page
The log ID and page number of the current log page.
Index page logging status
Indicates whether index page logging is enabled or disabled.
Index page logging was enabled at
The date and time that index page logging was enabled.
Server
The name of the secondary server.
ACKed Log (log, page)
The log ID and page number of the last acknowledged log transmission.
Applied Log (log, page)
The log ID and page number of the last applied log transmission.
Supports Updates
Displays whether client applications can perform update, insert, and delete operations on the secondary server (as specified by the UPDATABLE_SECONDARY configuration parameter).
Status
Displays the connection status of the secondary server

Example output (primary server, verbose output)

Figure 3: onstat -g cluster verbose command output (run on the primary server)

Following is sample output from the onstat -g cluster verbose command. The sample shows output when the command is run on the primary server with the verbose option.

Primary Server:serv1
	Current Log Page:16,479
	Index page logging status: Enabled
	Index page logging was enabled at: 2013/12/11 14:05:17
	
	
	-----------------------------------------------------------
	
	server name: serv3
	type: ASYNC (HDR)
	control block: 0x4b673018
	server status: On
	connection status: Connected
	Last log page sent (log id, page): 16,479
	Last log page acked (log id, page); 16,479
	Last log page applied (log id, page); 16,479
	Approximate log page backlog: 0
	SDS cycle not used
	Delayed Apply Not Used
	Stop Apply Not Used
	Time of last ack: 2013/12/11 14:09:12
	Supports Updates: Yes
	
	
	-----------------------------------------------------------
	
	server name: serv2
	type: SYNC (SDS)
	control block: 0x4c2de0b8
	server status: Active
	connection status: Connected
	Last log page sent (log id, page): 16,479
	Last log page acked (log id, page); 16,479
	Last log page applied (log id, page); 16,479
	Approximate log page backlog: 0
	SDS cycle current: 20 ACKed: 20
	Delayed Apply Not Used
	Stop Apply Not Used
	Time of last ack: 2013/12/11 14:09:13
	Supports Updates: Yes

Output description (primary server, verbose output)

Primary server
The name of the primary server
Current log page
The log ID and page number of the current log page.
Index page logging status
Indicates whether index page logging is enabled or disabled.
Index page logging was enabled at
The date and time that index page logging was enabled.
Server name
The name of the secondary server.
type
Displays whether the secondary server is connected synchronously (SYNC) or asynchronously (ASYNC). Also displays the type of secondary server: HDR, SDS, or RSS.
control block
The in-memory address of the thread control block.
server status
Displays the current status of the secondary server.
connection status
Displays the current network connection status of the secondary server.
Last log page sent (log id, page)
The log ID and page number of the most recent log page sent by the primary server to the secondary server.
Last log page acked (log id, page)
The log ID and page number of the most recent log page the secondary server acknowledged.
Last log page applied (log id, page)
The log ID and page number of the most recent log page the secondary server applied.
Approximate log page backlog
Indicates the approximate number of log pages that have yet to be processed by the secondary server.
SDS cycle
Indicates the cycle number to which the primary server has advanced and which the shared disk secondary server has acknowledged. Used internally by the support to monitor coordination of the primary server with the secondary server.
Delayed Apply
Indicates whether the secondary server waits for a specified amount of time before applying logs (as specified by the DELAY_APPLY configuration parameter).
Stop Apply
Indicates whether the secondary server has stopped applying log files received from the primary server (as specified by the STOP_APPLY configuration parameter).
Time of last ack
The date and time of the last acknowledged log.
Supports Updates
Displays whether client applications can perform update, insert, and delete operations on the secondary server (as specified by the UPDATABLE_SECONDARY configuration parameter).

Example output (secondary server)

Following is sample output from the onstat -g cluster command. The sample shows output when the command is run on a secondary server.

Figure 4: onstat -g cluster command output (run on the secondary server)
Primary Server:serv1
	Index page logging status: Enabled
	Index page logging was enabled at: 2010/01/11 14:05:17
	
	
	Server ACKed Log    Applied Log   Supports     Status
	       (log, page)  (log, page)   Updates
	serv2  16,479       16,479        Yes          SYNC(SDS),Connected,Active

Output description (secondary server)

Primary server
The name of the primary server
Index page logging status
Indicates whether index page logging is enabled or disabled.
Index page logging was enabled at
The date and time that index page logging was enabled.
Server
The name of the secondary server.
ACKed Log (log, page)
The log ID and page number of the last acknowledged log.
Applied Log (log, page)
The log ID and page number of the last applied log transmission.
Supports Updates
Displays whether client applications can perform update, insert, and delete operations on the secondary server (as specified by the UPDATABLE_SECONDARY configuration parameter).
Status
Displays the connection status of the secondary server.