onmode -Y

Anyone know how to use this? Can't seem to find an explanation anywhere. I show that there is a new command in 9.4: onmode -Y with the following description: -Y <sid> [0|1] Set or unset dynamic explain This is all there is in the release notes: 1. Dynamically Monitor Queries ................................... Ability to monitor queries dynamically using the onmode -Y command.

Hi Bleb, I do know that Informix has come out with the Set explain on with out executing the query. You can see if the query is tune properly before actually running it. I am not sure if the onmode is the way to go, you can try it. Carl W Berner - Team Lead Informix/Oracle DBA IBM Global Services - Serving Lucent Technologies Work : (770) 750 5225 Pager: 1-800-759-8888 Pin#1615039 Email: cberner@lucent.com -----Original Message----- From: bleb@harland.net [mailto:bleb@harland.net] Sent: Monday, April 28, 2003 4:59 PM To: ids@iiug.org Subject: onmode -Y [1016] Anyone know how to use this? Can't seem to find an explanation anywhere. I show that there is a new command in 9.4: onmode -Y with the following description: -Y <sid> [0|1] Set or unset dynamic explain This is all there is in the release notes: 1. Dynamically Monitor Queries .................................. Ability to monitor queries dynamically using the onmode -Y command.

That's the new feature ...:-) U can now dynamically set the explain on for sessions ...that way you don't have to really take out the query from the application or use SQLIDEBUG to get it and test for its query plan .... Setting it will start generating the explain output for all the queries coming in after that .... Thanx much, Rajib Sarkar Advisory Support Engineer (Wells Fargo Bank) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi bleb@harland.net Sent by: To: ids@iiug.org forum.subscriber@ cc: iiug.org Subject: onmode -Y [1016] 04/28/2003 01:58 PM Anyone know how to use this? Can't seem to find an explanation anywhere. I show that there is a new command in 9.4: onmode -Y with the following description: -Y <sid> [0|1] Set or unset dynamic explain This is all there is in the release notes: 1. Dynamically Monitor Queries .................................. Ability to monitor queries dynamically using the onmode -Y command.

You can read some more explanations on the Performance Guide, pages 10-12 to 10-20 (Query Plan Report). I haven't used it yet, but I guess it should as what the documentation says. -edmund