473,322 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

IX lock not released

i am using type 4 driver with fp3 on windows 64bit server, auto commit
is true, cursor is CS type.

i have a sensitive , updatable cursor open and bring back a one row
resultset, i get this locklist

Lock Name = 0x020027011C0000000000000052
Lock Attributes = 0x00000000
Release Flags = 0x00000002
Lock Count = 1
Hold Count = 0
Lock Object Name = 28
Object Type = Row
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = U

Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = IX

after that i will do update on this row, once the update statement
execute. statement.execute(sql), i still have a table IX lock there,
why the commit part not working? i have tried to explicitly call
conn.commit() still not help. but this will cause us problem since we
don't want to have IX lock stay after commit. Does this is the way
work on DB2?

Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xxx
Mode = IX
Nov 12 '05 #1
2 4449
I don't use JDBC 2 feature.
Where can I find the definition of a sensitive cursor? Is it a scroll
cursor?
AFAIK, when using updatable cursor, you need turn off the autocommit,
otherwise you may lose the cursor handle.
xixi wrote:
i am using type 4 driver with fp3 on windows 64bit server, auto commit
is true, cursor is CS type.

i have a sensitive , updatable cursor open and bring back a one row
resultset, i get this locklist

Lock Name = 0x020027011C0000000000000052
Lock Attributes = 0x00000000
Release Flags = 0x00000002
Lock Count = 1
Hold Count = 0
Lock Object Name = 28
Object Type = Row
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = U

Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = IX

after that i will do update on this row, once the update statement
execute. statement.execute(sql), i still have a table IX lock there,
why the commit part not working? i have tried to explicitly call
conn.commit() still not help. but this will cause us problem since we
don't want to have IX lock stay after commit. Does this is the way
work on DB2?

Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xxx
Mode = IX


Nov 12 '05 #2
WITH HOLD... WITH HOLD... WITH HOLD...

xixi wrote:
i am using type 4 driver with fp3 on windows 64bit server, auto commit
is true, cursor is CS type.

i have a sensitive , updatable cursor open and bring back a one row
resultset, i get this locklist

Lock Name = 0x020027011C0000000000000052
Lock Attributes = 0x00000000
Release Flags = 0x00000002
Lock Count = 1
Hold Count = 0
Lock Object Name = 28
Object Type = Row
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = U

Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = IX

after that i will do update on this row, once the update statement
execute. statement.execute(sql), i still have a table IX lock there,
why the commit part not working? i have tried to explicitly call
conn.commit() still not help. but this will cause us problem since we
don't want to have IX lock stay after commit. Does this is the way
work on DB2?

Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xxx
Mode = IX


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Marco Bubke | last post by:
Hi There is the Lock object in the threading module. But there is no medode there I could aquire a scoped lock like: mutex = threading.Lock() my_lock = mutex.scoped_acquire() # maybe...
4
by: Christoph Zeltner | last post by:
hi, i am writing a thesis on the concurrency control in db2 udb and oracle. I found in the documentary of db2, that a resource holding a (U)pdate-Lock can still be requested by a read-lock...
7
by: Sunny | last post by:
Hi, I can not understend completely the lock statement. Actally what is locked: 1. the part of the code between {...} or 2. the object in lock() In the docs is written: for 1: The lock...
13
by: Andrew Morton | last post by:
I am caching some data in VB.NET using System.Web.Caching, is it possible to lock the cache so that other sessions attempting to access the same cache wait when it is being updated? I have the...
0
by: Duncan Grisby | last post by:
Hi, I have encountered a problem with the re module. I have a multi-threaded program that does lots of regular expression searching, with some relatively complex regular expressions....
2
by: adri4n | last post by:
as wat ive mentioned in the title.. im would like to know whether the a particular record/table is being locked in my program. some of the methods which i would like to develop are as below: ...
1
by: Ron M. Newman | last post by:
Hi. Quick question: - I have a class with fields. There is one method that modifies them. in this method I have something like lock (this.lockObject) { /// throwing exception here... }
2
by: Roopesh | last post by:
Hi, In my mod_python project I am using mysql as the database. There is table card in which unique cards are stored. When a user request comes he has to get a unique card. In this situation I want...
94
by: Samuel R. Neff | last post by:
When is it appropriate to use "volatile" keyword? The docs simply state: " The volatile modifier is usually used for a field that is accessed by multiple threads without using the lock...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.