Page 1 of 1

DB2 CONTENTION PROBLEM (-911)

PostPosted: Thu Feb 12, 2009 2:49 pm
by chetan_007
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

Re: DB2 CONTENTION PROBLEM (-911)

PostPosted: Fri Feb 13, 2009 1:04 am
by dick scherrer
Hello and welcome to the forum,

Suggest you work with your dba to identify what has the resource locked.