Simple question about log

Hi! I have this record in log file. 15:29:32 Maximum server connections 132 15:29:32 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txnsblocked 1, Plog used 50241, Llog used 32703 15:29:39 Explain file for session 15085 : /root/sqexplain.out 15:30:17 Explain file for session 15092 : /root/sqexplain.out 15:31:03 Explain file for session 15103 : /root/sqexplain.out 15:33:19 Explain file for session 15111 : /root/sqexplain.out 15:34:26 Explain file for session 15130 : /root/sqexplain.out 15:34:32 Checkpoint Completed: duration was 0 seconds. 15:34:32 Fri Oct 2 - loguniq 2401, logpos 0xa41f018, timestamp:0x65b73f9b Interval: 7024 Are such strings as "15:30:17 Explain file for session 15092 : /root/sqexplain.out" results of executing "onmode -Y id_session 2" command? Who could execute this command? Only administrator? Is it possible to use command "onmode " for all sessions? Should I execute onmode command with number of each sesion (15092, 15093, ...) in this case or there is some way to make it automatically? There is no SET EXPLAIN in SQL code. TIA

Server version and platform information is always helpful. From the message and the format of hte log messages, I can tell that this is 11.xx but not if it is 11.10 or 11.50. Anyway, in 11.xx you can put a SET EXPLAIN statement into the sysdbopen procedure which is executed by all users when they connect to the instance. In that procedure you can filter which users will execute the SET EXPLAIN using logic based on username, host, the contents of a table, etc. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Nov 23, 2009 at 4:07 AM, padddfoot <ivan.krasnoslobodtsev@gmail.com>wrote: > Hi! > > I have this record in log file. > > 15:29:32 Maximum server connections 132 > 15:29:32 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns> blocked 1, Plog used 50241, Llog used 32703 > > 15:29:39 Explain file for session 15085 : /root/sqexplain.out > 15:30:17 Explain file for session 15092 : /root/sqexplain.out > 15:31:03 Explain file for session 15103 : /root/sqexplain.out > 15:33:19 Explain file for session 15111 : /root/sqexplain.out > 15:34:26 Explain file for session 15130 : /root/sqexplain.out > 15:34:32 Checkpoint Completed: duration was 0 seconds. > 15:34:32 Fri Oct 2 - loguniq 2401, logpos 0xa41f018, timestamp:> 0x65b73f9b Interval: 7024 > > Are such strings as > "15:30:17 Explain file for session 15092 : /root/sqexplain.out" > results of executing "onmode -Y id_session 2" command? > Who could execute this command? Only administrator? > Is it possible to use command "onmode " for all sessions? Should I > execute onmode command with number of each sesion (15092, 15093, ...) > in this case or there is some way to make it automatically? > There is no SET EXPLAIN in SQL code. > > > TIA > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >