DB2 CONTENTION PROBLEM (-911)



IBM's flagship relational database management system

DB2 CONTENTION PROBLEM (-911)

Postby chetan_007 » Thu Feb 12, 2009 2:49 pm

Hi,

I know that we get SQL CODE -911 due to contention problem (i.e, resource being locked by some other program in most of the cases). But I need to check in the log, what program has locked the particular resource? How to find the program that has locked the resource?

Could some one help me.

Thanks
chetan_007
 
Posts: 24
Joined: Sun Mar 02, 2008 3:22 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 CONTENTION PROBLEM (-911)

Postby dick scherrer » Fri Feb 13, 2009 1:04 am

Hello and welcome to the forum,

Suggest you work with your dba to identify what has the resource locked.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post