470,590 Members | 2,482 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,590 developers. It's quick & easy.

Details on DB2_SKIPDELETED

Hi.

We have deadlocks involving DELETEs, and I was hoping that
DB2_SKIPDELETED might be able to help in the short term.

I was looking at the following link:

"http://publib.boulder.ibm.com/infocenter/cmgmt/v8r3m0/index.jsp?topic=/com.ibm.cmgmtreadmefp.doc/d104742.htm"

It states that:

db2set DB2_EVALUNCOMMITTED=ON
db2set DB2_SKIPINSERTED=ON
db2set DB2_SKIPDELETED=ON

(specifically DB2_SKIPDELETED) are variables which can protect from
locking in some cases.

Is this intended to protect a SELECT from deadlocking against a DELETE?

And do you know which versions of DB2 have these variables available?

Any help would be much appreciated.

Joel

Jan 18 '07 #1
1 3235
<mi************@yahoo.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...
Hi.

We have deadlocks involving DELETEs, and I was hoping that
DB2_SKIPDELETED might be able to help in the short term.

I was looking at the following link:

"http://publib.boulder.ibm.com/infocenter/cmgmt/v8r3m0/index.jsp?topic=/com.ibm.cmgmtreadmefp.doc/d104742.htm"

It states that:

db2set DB2_EVALUNCOMMITTED=ON
db2set DB2_SKIPINSERTED=ON
db2set DB2_SKIPDELETED=ON

(specifically DB2_SKIPDELETED) are variables which can protect from
locking in some cases.

Is this intended to protect a SELECT from deadlocking against a DELETE?

And do you know which versions of DB2 have these variables available?

Any help would be much appreciated.

Joel
It takes two different applications, each locking on two different objects
to cause a deadlock (usually from two different SQL statements).

With DB2_SKIPDELETED=ON, if a row is deleted by application program 1, then
application program 2 will assume the row does not exist (and will not
lockwait on that row) even if application 1 has not committed the delete.

I believe DB2_SKIPDELETED=ON was introduced in 8.1 FP 4.
Jan 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Srinivasa Reddy K Ganji | last post: by
1 post views Thread by SwatSoftwareDev | last post: by
1 post views Thread by brian.newman | last post: by
4 posts views Thread by randy.buchholz | last post: by
reply views Thread by peter.c.bradley | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.