Change Lock Mode For Session

Posted in 2010

James Brunskill — Tue, 23 Mar 2010 17:10:39 +1300 — source: Usenet: comp.databases.informix

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.brunskill@fonterra.com <mailto:jarrod.teale@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/

↪ replying to James Brunskill

jrenaut — Tue, 23 Mar 2010 08:40:08 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to jrenaut

James Brunskill — Wed, 24 Mar 2010 08:55:36 +1300 — source: Usenet: comp.databases.informix

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/