分类： DB2/Informix
2008-05-31 18:10:01
RSS：监视
本节讨论以下主题：
onstat 有几个选项，而且输出取决于运行 onstat 的位置。清单 57 演示了如何使用显示简要 RSS 信息的几个选项：
$ onstat -g rss
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 1 days
02:28:52 -- 196608 Kbytes
Local server type: HDR Primary
Index page logging status: Enabled
Index page logging was enabled at: 2007/05/15 08:50:18
Number of RSS servers: 2
RSS Server information:
RSS Srv RSS Srv Connection Next LPG to send
name status status (log id,page)
war Active Connected 4,3
uabrs Active Connected 4,3
|
注意 “Next LPG to send”。这是惟一逻辑日志 id 和这个惟一日志中的逻辑日志页面。
清单 58 显示一个特定 RSS 节点的相关信息：
$ onstat -g rss war
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 1 days
06:49:10 -- 196608 Kbytes
RSS Server control block: 0xf202f68
RSS server name: war
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 4,48
Sequence number of next buffer to send: 1279
Sequence number of last buffer acked: 1265
Log Pages Snooped:
RSS Srv From From Tossed
name Cache Disk (LBC full)
war 3448 1053 0
|
清单 59 显示详细的 RSS 信息：
$ onstat -g rss verbose
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 1 days
06:51:01 -- 196608 Kbytes
Local server type: HDR Primary
Index page logging status: Enabled
Index page logging was enabled at: 2007/05/15 08:50:18
Number of RSS servers: 2
RSS Server information:
RSS Server control block: 0xf202f68
RSS server name: war
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 4,48
Sequence number of next buffer to send: 1279
Sequence number of last buffer acked: 1265
RSS Server control block: 0xf202e20
RSS server name: uabrs
RSS server status: Active
RSS connection status: Connected
Log transmission status: Active
Next log page to send(log id,page): 4,48
Sequence number of next buffer to send: 313
Sequence number of last buffer acked: 299
|
清单 60 显示日志信息：
$ onstat -g rss log
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 1 days
06:52:24 -- 196608 Kbytes
Log Pages Snooped:
RSS Srv From From Tossed
name Cache Disk (LBC full)
war 3448 1053 0
uabrs 47 4454 0
|
清单 61 中的选项显示在 RSS 节点上看到的信息：
$ onstat -g rss
IBM Informix Dynamic Server Version 11.10.FC1 -- Read-Only (RSS) -- Up 1 days
05:46:19 -- 196608 Kbytes
Local server type: RSS
Server Status : Active
Source server name: boy
Connection status: Connected
Last log page received(log id,page): 4,47
|
清单 62 演示了如何利用 onstat -g smx 选项显示 SMX 连接统计信息：
$ onstat -g smx
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 18 days
09:22:51 -- 196608 Kbytes
SMX connection statistics:
SMX control block: 0xefa9028
Peer server name: war
SMX connection address: 0xefabcc8
Encryption status: Disabled
Total bytes sent: 49830400
Total bytes received: 23055144
Total buffers sent: 211527
Total buffers received: 795204
Total write calls: 205405
Total read calls: 795204
Total retries for write call: 0
Peer server name: uabrs
SMX connection address: 0xf73c050
Encryption status: Disabled
Total bytes sent: 49829140
Total bytes received: 23053252
Total buffers sent: 211508
Total buffers received: 795138
Total write calls: 205382
Total read calls: 795138
Total retries for write call: 0
|
清单 63 中的选项显示 SMX 会话统计信息：
$ onstat -g smx ses
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 18 days
09:25:20 -- 196608 Kbytes
SMX session statistics:
SMX control block: 0xefa9028
Peer SMX session client reads writes
name address type
war f968050 RSS Send 397634 211541
uabrs f73c688 RSS Send 397601 211522
|
清单 64 利用 onstat -g ipl 选项显示索引页面日志记录的状态信息：
$ onstat -g ipl IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (Prim) -- Up 18 days 09:38:43 -- 196608 Kbytes Index page logging status: Enabled Index page logging was enabled at: 2007/05/15 08:50:18 |
