Informix 11.10 MACH11 SDS onstat documentation -- Posted by inturi on Saturday, March 1 2008

Brief SDS related statistics at SD source server:
$onstat -g sds

IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:06:17 -- 38912 Kbytes

Local server type: Primary
Number of SDS servers:2

SDS server information

SDS srv SDS srv Connection Last LPG sent
name status status (log id,page)
ol_1_sdc1 Active Connected 7,884
ol_1_sdc2 Active Connected 7,884

Brief SDS related statistics at SD secondary server:
$onstat -g sds
IBM Informix Dynamic Server Version 11.10.FC1 -- Read-Only (SDS) -- Up 00:03:17 -- 47104 Kbytes

Local server type: SDS
Server Status : Active
Source server name: ol_1
Connection status: Connected
Last log page received(log id,page): 7,884

Detailed SDS related statistics at SD source server
$onstat -g sds verbose

IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:06:17 -- 38912 Kbytes

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

SDS server control block: 0xb3cd8d0
server name: ol_1_sdc1
server type: SDS
server status: Active
connection status: Connected
Last log page sent(log id,page):7,884
Last log page flushed(log id,page):7,884
Last LSN acked (log id,pos):7,3621272
Sequence number of next buffer to send: 176
Sequence number of last buffer acked: 0
Time of lask ack:2007/02/20 21:04:13
Total LSNs posted:0
Total LSNs sent:0
Total page flushes posted:0
Total page flushes sent:0

SDS server control block: 0xc09bbd8
server name: ol_1_sdc2
server type: SDS
server status: Active
connection status: Connected
Last log page sent(log id,page):7,884
Last log page flushed(log id,page):7,884
Last LSN acked (log id,pos):7,3621272
Sequence number of next buffer to send: 173
Sequence number of last buffer acked: 0
Time of lask ack:2007/02/20 21:04:13
Total LSNs posted:0
Total LSNs sent:0
Total page flushes posted:0
Total page flushes sent:0

Detailed SDS related statistics at SD secondary server:
$onstat -g sds verbose

IBM Informix Dynamic Server Version 11.10.FC1 -- Read-Only (SDS) -- Up 00:03:17 -- 47104 Kbytes

SDS server control block: 0xb299880
Local server type: SDS
Server Status : Active
Source server name: ol_1
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:/work1/dbspaces/page_ol_1_sdc1_pg1
Current paging file size:2048
Old paging file:/work1/dbspaces/page_ol_1_sdc1_pg2
Old paging file size:10240

Per SDS server statistics at SD source server:
$onstat -g sds ol_1_sdc1

IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:06:17 -- 38912 Kbytes

SDS server control block: 0xb3cd8d0
server name: ol_1_sdc1
server type: SDS
server status: Active
connection status: Connected
Last log page sent(log id,page):7,884
Last log page flushed(log id,page):7,884
Last LSN acked (log id,pos):7,3621272
Sequence number of next buffer to send: 176
Sequence number of last buffer acked: 0
Time of lask ack:2007/02/20 21:04:13
Total LSNs posted:0
Total LSNs sent:0
Total page flushes posted:0
Total page flushes sent:0