IDS 7.x SET EXPLAIN ON for all query

Posted in 2013

Topics: Versions, Editions & End-of-Life

MOHAMMAD IRFAN — Tue, 25 Jun 2013 14:29:52 — source: IIUG Forums & Mailing Lists

Hi, how can I set the configuration/directive on the fly to explain all the query that hit the database? I want to trace certain query from a program which we don't have the sql documentation for it. Thanks.

↪ replying to MOHAMMAD IRFAN

Art Kagel — Tue, 25 Jun 2013 18:04:28 — source: IIUG Forums & Mailing Lists

onmode -Y <sid> [0|1|2] Zero disables explain for the session, one is plan plus statistics, two sets plan only Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Tue, Jun 25, 2013 at 10:29 AM, MOHAMMAD IRFAN <irfan199@yahoo.com> wrote: > Hi, how can I set the configuration/directive on the fly to explain all the > query that hit the database? I want to trace certain query from a program > which we don't have the sql documentation for it. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c676078d45c04dffe5be6

↪ replying to Art Kagel

John Miller iii — Tue, 25 Jun 2013 18:31:06 — source: IIUG Forums & Mailing Lists

Note: Only statement prepared after the onmode command is run will be placed in the explain file. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/25/2013 11:04:29 AM: > From: "Art Kagel" <art.kagel@gmail.com> > To: ids@iiug.org, > Date: 06/25/2013 11:07 AM > Subject: Re: IDS 7.x SET EXPLAIN ON for all query [30649] > Sent by: ids-bounces@iiug.org > > onmode -Y <sid> [0|1|2]> > Zero disables explain for the session, one is plan plus statistics, two > sets plan only > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. 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 Tue, Jun 25, 2013 at 10:29 AM, MOHAMMAD IRFAN <irfan199@yahoo.com> wrote: > > > Hi, how can I set the configuration/directive on the fly to explain all the > > query that hit the database? I want to trace certain query from a program > > which we don't have the sql documentation for it. > > > > Thanks. > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013c676078d45c04dffe5be6 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >