Re: Change Lock Mode For Session
It won't help if the applications are executing SET LOCK MODE TO WAIT 10; after connection since that happens after the sysdbopen() function is run. It will help with any applications that are accepting the default lock wait mode. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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, Mar 23, 2010 at 3:55 PM, James Brunskill < James.Brunskill@fonterra.com> wrote: > Thanks all, > > The sysdbopen() procedure looks very useful! > > Sorry for not specifying, ifx engine is 11.50.UC5 > > Cheers, > > James > > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto: > informix-list-bounces@iiug.org] On Behalf Of jrenaut > Sent: Wednesday, March 24, 2010 4:40 AM > To: informix-list@iiug.org > Subject: Re: Change Lock Mode For Session > > On Mar 22, 11:10 pm, "James Brunskill" <James.Brunsk...@fonterra.com> > wrote: > > Hi All, > > > > Is there any way to force a particular lock mode on a informix session? > > > > I have a client app connecting to my database with lock mode set to not > > wait. > > > > This lack of a short wait can cause issues with a locking due to a > > manual process I'm running over the data currently. > > > > Changing the client application to get it to set the lock mode isn't > > easy to do at this stage J > > > > Regards, > > > > James Brunskill > > > > Computer Engineer - Manufacturing Execution Systems > > > > Automation & Process Control Group > > > > NZ Technical > > > > Fonterra > > > > Fonterra Extn: 77808 > > > > Ext Line: +64 7 849 2411 x 77808 > > > > email: james.brunsk...@fonterra.com > > <mailto:jarrod.te...@fonterra.com> > > > > DISCLAIMER: > > This email contains confidential information and may be legally > privileged. If you are not the intended recipient or have received this > email in error, please notify the sender immediately and destroy this email. > > You may not use, disclose or copy this email or its attachments in any > way. > > Any opinions expressed in this email are those of the author and are not > necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ > > Well, you don't say what version of the engine you are using, so I'll > throw out the if you are using 11.10 or newer you should be able to do > something using the sysdbopen() procedure. > > See > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqls.doc/sqls1321.htm > for more info. > > Jacques Renaut > IBM Informix Advanced Support > APD Team > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > DISCLAIMER: > This email contains confidential information and may be legally privileged. > If you are not the intended recipient or have received this email in error, > please notify the sender immediately and destroy this email. > You may not use, disclose or copy this email or its attachments in any way. > Any opinions expressed in this email are those of the author and are not > necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >