IT咨询服务数据库
onmode命令问题！？
现有sql回话：
[informix@Age732 ~]$ onstat -g sql
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line -- Up 00:14:10 -- 353428 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
27 SELECT sysmaster CR Not Wait 0 0 9.24 Off
23 sysadmin DR Wait 5 0 0 - Off
22 sysadmin DR Wait 5 0 0 - Off
21 sysadmin DR Wait 5 0 0 - Off
使用onmode使用工具动态的打开SQL解释：
onmode -Y 27 1
然后再执行onstat -g sql:
[informix@Age732 ~]$ onstat -g sql
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line -- Up 00:15:17 -- 353428 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
27 SELECT sysmaster CR Not Wait 0 0 9.24 Dyn. stat
23 sysadmin DR Wait 5 0 0 - Off
22 sysadmin DR Wait 5 0 0 - Off
21 sysadmin DR Wait 5 0 0 - Off
怎么查看sqexplain.out文件？该文件在哪个路径下？
[informix@Age732 ~]$ onstat -g sql
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line -- Up 00:14:10 -- 353428 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
27 SELECT sysmaster CR Not Wait 0 0 9.24 Off
23 sysadmin DR Wait 5 0 0 - Off
22 sysadmin DR Wait 5 0 0 - Off
21 sysadmin DR Wait 5 0 0 - Off
使用onmode使用工具动态的打开SQL解释：
onmode -Y 27 1
然后再执行onstat -g sql:
[informix@Age732 ~]$ onstat -g sql
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line -- Up 00:15:17 -- 353428 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
27 SELECT sysmaster CR Not Wait 0 0 9.24 Dyn. stat
23 sysadmin DR Wait 5 0 0 - Off
22 sysadmin DR Wait 5 0 0 - Off
21 sysadmin DR Wait 5 0 0 - Off
怎么查看sqexplain.out文件？该文件在哪个路径下？
6同行回答
浏览872
onstat -m输出：
[informix@Age732 ~]$ onstat -m
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line -- Up 00:18:54 -- 353428 Kbytes
Message Log File: /opt/IBM/informix/online.log
09:09:16 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 108, Llog used 283
09:09:18 Checkpoint Completed: duration was 0 seconds.
09:09:18 Wed Sep 11 - loguniq 8, logpos 0x51037e4, timestamp: 0x30ee5c Interval: 2154
09:09:18 Maximum server connections 0
09:09:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 28, Llog used 14
09:14:40 Checkpoint Completed: duration was 0 seconds.
09:14:40 Wed Sep 11 - loguniq 8, logpos 0x5123018, timestamp: 0x30f721 Interval: 2155
09:14:40 Maximum server connections 0
09:14:40 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 56, Llog used 31
09:24:41 Checkpoint Completed: duration was 0 seconds.
09:24:41 Wed Sep 11 - loguniq 8, logpos 0x5125018, timestamp: 0x30f732 Interval: 2156
09:24:41 Maximum server connections 1
09:24:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2收起
[informix@Age732 ~]$ onstat -m
IBM Informix Dynamic Server Version 11.50.UC7 -- On-Line -- Up 00:18:54 -- 353428 Kbytes
Message Log File: /opt/IBM/informix/online.log
09:09:16 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 108, Llog used 283
09:09:18 Checkpoint Completed: duration was 0 seconds.
09:09:18 Wed Sep 11 - loguniq 8, logpos 0x51037e4, timestamp: 0x30ee5c Interval: 2154
09:09:18 Maximum server connections 0
09:09:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 28, Llog used 14
09:14:40 Checkpoint Completed: duration was 0 seconds.
09:14:40 Wed Sep 11 - loguniq 8, logpos 0x5123018, timestamp: 0x30f721 Interval: 2155
09:14:40 Maximum server connections 0
09:14:40 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 56, Llog used 31
09:24:41 Checkpoint Completed: duration was 0 seconds.
09:24:41 Wed Sep 11 - loguniq 8, logpos 0x5125018, timestamp: 0x30f732 Interval: 2156
09:24:41 Maximum server connections 1
09:24:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2收起
浏览927