onmode -Y
A poster asked how to use the new IDS 9.4 command onmode -Y, described only as setting or unsetting dynamic explain. Rajib Sarkar explained that it turns on explain output dynamically for a given session, so queries need not be extracted from the application. Edmund Lajara pointed to the Performance Guide's query plan report. Carl Berner was unsure.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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