473,287 Members | 1,565 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,287 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 4446
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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...
1
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: 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...

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.