IBM Supplies Database Tech For EU Smart Grid...

IBM's smart metering system allows wise use of energy...

IBM to help people monitor energy use...

IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain...

Misurare il consumo energetico: DEHEMS e pronto...

IBM software in your home? Pact enables five-city smart meter pilot in Europe...

Yes, because of the index page. The rows being inserted were probably being inserted onto separate pages so no row lock contention, only index key...

oh, and btw, if my lock mode is row, i dont encounter the locking issues. ******************************************************************************* To post a response via email...

yep, im setting lock mode to wait for both the applicstions before beginning them. the only thing is, why did the error not occur when...

Sorry that last got away from me. If you set LOCK MODE TO WAIT 10; then the second session will not get an error as...

Do the SET LOCK MODE TO WAIT 10; in both sessions before trying the inserts. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer:...

Yes. These locks are transient (lasting only a fraction of a second normally - unless your apps are poorly designed). The fix is to SET...

Interesting. Will have to read up. j. On Feb 22, 2012, at 10:12 AM, Art Kagel wrote: > Ok, no matter what the second row...

On Wed, Feb 22, 2012 at 01:48, MARS CHEN <hedgezzz@yahoo.com.tw> wrote: > This question is not about IDS , I am confused with thread's behavior...

so the page locks may be on index pages? since when i dropped all indexes and primary keys, the error wa gone. ...

A page can hold several rows. When you use the page level lock the first insert (you don't commit) holds the lock for the whole...