Oninit cdi / Archive
Talk to an expert →

SET LOCK MODE TO WAIT

Posted in 2018

Summary

User asked where to set SET LOCK MODE TO WAIT 30 to resolve lock-related insert errors. Fernando Nunes explained that lock mode is a session property that must be set in the same session executing the statements. It can be configured three ways: as a JDBC connection URL property, by executing the SQL statement within the session, or via a sysdbopen() procedure. No resolution to the original error was explicitly provided.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Server Administration

MUKESH TANUKU — — source: IIUG Forums & Mailing Lists

I have a question in mind where to set the lock mode. where to run this sql statement SET LOCK MODE TO WAIT 30; -> whether we need to run this sql statement in dbaccess before application is connection to database. -> or it should be set in data source file from application end. can you please suggest on this. Im facing a issue while inserting the data into database im getting an error ERROR: Could not do a physical-order read to fetch next row.

↪ replying to MUKESH TANUKU
Fernando Nunes — — source: IIUG Forums & Mailing Lists

The lock mode (SET LOCK MODE....) as well as the isolation level (SET ISOLATION LEVEL... / SET TRANSACTION) is a session property. So it must be set on the same session where you run the statements that are showing locks..... It can be set in different ways: 1- In JDBC is can be a connection URL property 2- In any language, it can be set by executing the SET LOCK MODE ... SQL statement within the session - probably requires application change 3- You can set it in the sysdbopen() procedure if you create one for the user connecting to the database Regards. On Wed, Mar 28, 2018 at 2:32 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > I have a question in mind where to set the lock mode. > where to run this sql statement SET LOCK MODE TO WAIT 30; > > -> whether we need to run this sql statement in dbaccess before > application is > connection to database. > -> or it should be set in data source file from application end. > > can you please suggest on this. Im facing a issue while inserting the data > into database im getting an error > ERROR: Could not do a physical-order read to fetch next row. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

↪ replying to Fernando Nunes
Long Nguyen — — source: IIUG Forums & Mailing Lists

Please remove my email from your group.I am now a retiree.I don't know how to remove my name from IDS group.Thanks & best regards,Long Nguyen. On Wednesday, 28 March 2018, 11:38:30 pm AEDT, Fernando Nunes <domusonline@gmail.com> wrote: The lock mode (SET LOCK MODE....) as well as the isolation level (SET ISOLATION LEVEL... / SET TRANSACTION) is a session property. So it must be set on the same session where you run the statements that are showing locks..... It can be set in different ways: 1- In JDBC is can be a connection URL property 2- In any language, it can be set by executing the SET LOCK MODE ... SQL statement within the session - probably requires application change 3- You can set it in the sysdbopen() procedure if you create one for the user connecting to the database Regards. On Wed, Mar 28, 2018 at 2:32 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > I have a question in mind where to set the lock mode. > where to run this sql statement SET LOCK MODE TO WAIT 30; > > -> whether we need to run this sql statement in dbaccess before > application is > connection to database. > -> or it should be set in data source file from application end. > > can you please suggest on this. Im facing a issue while inserting the data > into database im getting an error > ERROR: Could not do a physical-order read to fetch next row. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Long Nguyen
Everett Mills — — source: IIUG Forums & Mailing Lists

Go to the IIUG website. Select the membership area on the menu Once logged in to the website, select Member Area on the new menu that appears It will pop up a new window, you can use "Subscribe to Email Lists" to remove yourself. --EEM -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Wednesday, March 28, 2018 7:42 AM To: ids@iiug.org Subject: Re: SET LOCK MODE TO WAIT [40953] Please remove my email from your group.I am now a retiree.I don't know how to remove my name from IDS group.Thanks & best regards,Long Nguyen. On Wednesday, 28 March 2018, 11:38:30 pm AEDT, Fernando Nunes <domusonline@gmail.com> wrote: The lock mode (SET LOCK MODE....) as well as the isolation level (SET ISOLATION LEVEL... / SET TRANSACTION) is a session property. So it must be set on the same session where you run the statements that are showing locks..... It can be set in different ways: 1- In JDBC is can be a connection URL property 2- In any language, it can be set by executing the SET LOCK MODE ... SQL statement within the session - probably requires application change 3- You can set it in the sysdbopen() procedure if you create one for the user connecting to the database Regards. On Wed, Mar 28, 2018 at 2:32 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > I have a question in mind where to set the lock mode. > where to run this sql statement SET LOCK MODE TO WAIT 30; > > -> whether we need to run this sql statement in dbaccess before > application is > connection to database. > -> or it should be set in data source file from application end. > > can you please suggest on this. Im facing a issue while inserting the > data into database im getting an error > ERROR: Could not do a physical-order read to fetch next row. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Everett Mills
Everett Mills — — source: IIUG Forums & Mailing Lists

Additional: Enjoy your retirement! -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Everett Mills Sent: Wednesday, March 28, 2018 8:12 AM To: ids@iiug.org Subject: RE: SET LOCK MODE TO WAIT [40954] [This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing at http://aka.ms/LearnAboutSpoofing] Go to the IIUG website. Select the membership area on the menu Once logged in to the website, select Member Area on the new menu that appears It will pop up a new window, you can use "Subscribe to Email Lists" to remove yourself. --EEM -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Wednesday, March 28, 2018 7:42 AM To: ids@iiug.org Subject: Re: SET LOCK MODE TO WAIT [40953] Please remove my email from your group.I am now a retiree.I don't know how to remove my name from IDS group.Thanks & best regards,Long Nguyen. On Wednesday, 28 March 2018, 11:38:30 pm AEDT, Fernando Nunes <domusonline@gmail.com> wrote: The lock mode (SET LOCK MODE....) as well as the isolation level (SET ISOLATION LEVEL... / SET TRANSACTION) is a session property. So it must be set on the same session where you run the statements that are showing locks..... It can be set in different ways: 1- In JDBC is can be a connection URL property 2- In any language, it can be set by executing the SET LOCK MODE ... SQL statement within the session - probably requires application change 3- You can set it in the sysdbopen() procedure if you create one for the user connecting to the database Regards. On Wed, Mar 28, 2018 at 2:32 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > I have a question in mind where to set the lock mode. > where to run this sql statement SET LOCK MODE TO WAIT 30; > > -> whether we need to run this sql statement in dbaccess before > application is > connection to database. > -> or it should be set in data source file from application end. > > can you please suggest on this. Im facing a issue while inserting the > data into database im getting an error > ERROR: Could not do a physical-order read to fetch next row. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Everett Mills
Spokey Wheeler — — source: IIUG Forums & Mailing Lists

Dont forget to UPDATE STATISTICS!! > On 28 Mar 2018, at 14:11, Everett Mills <Everett.Mills@nationalbeef.com> wrote: > > Go to the IIUG website. > > Select the membership area on the menu > > Once logged in to the website, select Member Area on the new menu that appears > > It will pop up a new window, you can use "Subscribe to Email Lists" to remove > yourself. > > --EEM > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long > Nguyen > Sent: Wednesday, March 28, 2018 7:42 AM > To: ids@iiug.org > Subject: Re: SET LOCK MODE TO WAIT [40953] > > Please remove my email from your group.I am now a retiree.I don't know how to > remove my name from IDS group.Thanks & best regards,Long Nguyen. > > On Wednesday, 28 March 2018, 11:38:30 pm AEDT, Fernando Nunes > <domusonline@gmail.com> wrote: > > The lock mode (SET LOCK MODE....) as well as the isolation level (SET > ISOLATION LEVEL... / SET TRANSACTION) is a session property. > So it must be set on the same session where you run the statements that are > showing locks..... > > It can be set in different ways: > > 1- In JDBC is can be a connection URL property > 2- In any language, it can be set by executing the SET LOCK MODE ... SQL > statement within the session - probably requires application change > 3- You can set it in the sysdbopen() procedure if you create one for the user > connecting to the database > > Regards. > > On Wed, Mar 28, 2018 at 2:32 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> > wrote: > >> I have a question in mind where to set the lock mode. >> where to run this sql statement SET LOCK MODE TO WAIT 30; >> >> -> whether we need to run this sql statement in dbaccess before >> application is >> connection to database. >> -> or it should be set in data source file from application end. >> >> can you please suggest on this. Im facing a issue while inserting the >> data into database im getting an error >> ERROR: Could not do a physical-order read to fetch next row. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Glossary