Informix V11.10 MACH11 RSS onstat statistics documentation -- Posted by inturi on Saturday, March 1 2008
Brief RSS Server related statistics at RSS source server

$onstat -g rss

IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:08:56 -- 47104 Kbytes

Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2007/02/20 18:10:01
Number of RSS servers: 3

RSS Server information:

RSS Srv RSS Srv Connection Next LPG to send
name status status (log id,page)
ol_1_c1 Active Connected 7,899
l_1_c2 Active Connected 7,899
ol_1_c3 Active Connected 7,899


Brief RSS server related statistics at RS secondary server
$onstat –g rss

IBM Informix Dynamic Server Version 11.10.FC1 -- Read-Only (RSS) -- Up 00:05:18 -- 55296 Kbytes

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

Detailed RSS server related statistics at RSS source server

$onstat -g rss verbose

IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:08:56 -- 47104 Kbytes

Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2007/02/20 18:10:01
Number of RSS servers: 3

RSS Server information:

RSS Server control block: 0xb3ccc90
RSS server name: ol_1_c1
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 7,899
Sequence number of next buffer to send: 244
Sequence number of last buffer acked: 234

RSS Server control block: 0xc499b68
RSS server name: ol_1_c2
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 7,899
Sequence number of next buffer to send: 243
Sequence number of last buffer acked: 233

RSS Server control block: 0xc43bb68
RSS server name: ol_1_c3
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 7,899
Sequence number of next buffer to send: 242
Sequence number of last buffer acked: 232

Detailed RSS statistics at RS secondary server

$onstat -g rss verbose

IBM Informix Dynamic Server Version 11.10.FC1 -- Read-Only (RSS) -- Up 00:05:18 -- 55296 Kbytes

RSS Server control block: 0xb407880
Local server type: RSS
Server Status : Active
Source server name: ol_1
Connection status: Connected
Last log page received(log id,page): 7,877
Sequence number of last buffer received: 242
Sequence number of last buffer acked: 233


Log capture statistics at RSS source server

$onsat -g rss log


IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:08:57 -- 47104 Kbytes

Log Pages Snooped:
RSS Srv From From Tossed
name Cache Disk (LBC full)

ol_1_c1 1368 1331 0
ol_1_c2 1357 1342 0
ol_1_c3 1356 1343 0

Per RSS server statistics at RSS source server:

$onstat -g rss ol_1_c1

IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 00:08:56 -- 47104 Kbytes

RSS Server control block: 0xb3ccc90
RSS server name: ol_1_c1
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 7,899
Sequence number of next buffer to send: 244
Sequence number of last buffer acked: 234

Log Pages Snooped:
RSS Srv From From Tossed
name Cache Disk (LBC full)

ol_1_c1 1368 1331 0

[Edit] Home
If this information is helpful to you then please click here and post one simple tip that you know. Share your knowledge!