new feature ? set PDQ with onmode....

Hi, ifx 11.50 FC8 . There is some way to set a PDQPRIORITY for a session with the onmode ? The idea is active/deactive the PDQ for a session what already is running, on-fly. Something like active the set explain with "onmode -Y" , but to PDQ. The objective is help a specific session, without need to restart this session and without change the script/environment what they is running... Regards Cesar

Hi Cesar. Onmode command (wf or wm) applies only to the instance configuration (dynamically). If you want to set pdqpriority for a specific session, you must do it inside it´s specific sql command (before and after it´s execution). If you want to set pdqpriority for all sessions for the user, you could use sysdbopen/sysdbclose. Regards. Em 07/10/2011 09:15, Cesar Inacio Martins escreveu: > Hi, > > ifx 11.50 FC8 . > > There is some way to set a PDQPRIORITY for a session with the onmode ? > > The idea is active/deactive the PDQ for a session what already is running, > on-fly. > > Something like active the set explain with "onmode -Y" , but to PDQ. > > The objective is help a specific session, without need to restart this session > and without change the script/environment what they is running... > > Regards > Cesar > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

Not possible Cesar. Cool feature request though. Submit it to IBM. 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 Fri, Oct 7, 2011 at 9:15 AM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi, > > ifx 11.50 FC8 . > > There is some way to set a PDQPRIORITY for a session with the onmode ? > > The idea is active/deactive the PDQ for a session what already is running, > on-fly. > > Something like active the set explain with "onmode -Y" , but to PDQ. > > The objective is help a specific session, without need to restart this > session > and without change the script/environment what they is running... > > Regards > Cesar > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00248c0eefcafa0a6804aeb5a3b6

On 07/10/11 14:15, Cesar Inacio Martins wrote: > Hi, > > ifx 11.50 FC8 . > > There is some way to set a PDQPRIORITY for a session with the onmode ? > > The idea is active/deactive the PDQ for a session what already is running, > on-fly. > > Something like active the set explain with "onmode -Y" , but to PDQ. > > The objective is help a specific session, without need to restart this session > and without change the script/environment what they is running... > > Regards > Cesar > Nope there isn't such a provision, but it might be useful! However, if it ever was implemented, it would have the limitation that only statements prepared after the onmode had been run against the session would benefit from it, not the ones already running, or those that, while not yet being executed, had been prepared earlier. -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Hi Marco, Just as I thought! Who knows if with the feature auto_reprepare is not possible reprepare the SQL statements dynamically. As Art suggest, I will submit to IBM this feature request. On sexta-feira, 7 de outubro de 2011 11:13:49, Marco Greco wrote: > On 07/10/11 14:15, Cesar Inacio Martins wrote: >> Hi, >> >> ifx 11.50 FC8 . >> >> There is some way to set a PDQPRIORITY for a session with the onmode ? >> >> The idea is active/deactive the PDQ for a session what already is running, >> on-fly. >> >> Something like active the set explain with "onmode -Y" , but to PDQ. >> >> The objective is help a specific session, without need to restart this > session >> and without change the script/environment what they is running... >> >> Regards >> Cesar >> > > Nope there isn't such a provision, but it might be useful! > However, if it ever was implemented, it would have the limitation that only > statements prepared after the onmode had been run against the session would > benefit from it, not the ones already running, or those that, while not yet > being executed, had been prepared earlier.

On 07/10/11 19:28, Cesar Inacio Martins wrote: > Hi Marco, > > Just as I thought! > Who knows if with the feature auto_reprepare is not possible reprepare > the SQL statements dynamically. > > As Art suggest, I will submit to IBM this feature request. [thinks...] It's not a bad idea at all, although, currently, it wouldn't do what you want (and I should know, as I designed and coded auto_reprepare): statements are not reprepared if already executing, and won't reprepare on a session environment change - the feature actively looks for underlying table changes before kicking in. However, now you've tickled my interest, and I'm going to look into it! I don't think it would be too complicated to have an onmode trigger the reoptimization of statements for a specific session, much like your PDQ suggestion. Submit a feature request for this one too, the two combined should help you. -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Thanks Marco, I will suggest both: - Create new parameter on the "onmode -q <sesid> <pdqpriority>" to change dynamically the PDQPRIORITY of specific session - Enable the auto_reprepapre to support the pdqpriority change dynamically via onmode. ________________________________ De: Marco Greco <marco@4glworks.com> Para: ids@iiug.org Enviadas: Sexta-feira, 7 de Outubro de 2011 16:30 Assunto: Re: new feature ? set PDQ with onmode.... [25151] On 07/10/11 19:28, Cesar Inacio Martins wrote: > Hi Marco, > > Just as I thought! > Who knows if with the feature auto_reprepare is not possible reprepare > the SQL statements dynamically. > > As Art suggest, I will submit to IBM this feature request. [thinks...] It's not a bad idea at all, although, currently, it wouldn't do what you want (and I should know, as I designed and coded auto_reprepare): statements are not reprepared if already executing, and won't reprepare on a session environment change - the feature actively looks for underlying table changes before kicking in. However, now you've tickled my interest, and I'm going to look into it! I don't think it would be too complicated to have an onmode trigger the reoptimization of statements for a specific session, much like your PDQ suggestion. Submit a feature request for this one too, the two combined should help you. -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.