hi, for a aix db2 udb v7.2 fixpack 10a server, for a database we got -911 messages.
above that message it writes the timeout caused by lock.


2004-09-09-09.16.24.328967 Instance:db2inst1de:000
PID:12642(db2agent (SATDB)) Appid:yyyyyyyyy.yyyyy.yyyyyyyyyy
lock_manager sqlplnfd Probe:80 DatabaseATDB

Request for lock "REC: (15, 2) RID 00000205" in mode ".NS" timed out
Application caused the lock wait is "xxxxxxxx.xxxxxx.xxxxxxxxx"
Statement: 7245 6c65 6374 2134 3253 5449 4e43 5430 SELECT
2053 5542 5f54 494c 5f55 5352 5f53 4943 <there is a statement here>
494c 2020 6672 6f6d 2054 5355 422e 5355



my question is that: is this statement the cause of the timeout or is it the statement that waited for lock and timed out?

tnx all

hi
that'a an urgent problem
can anyone help??

Hi!

I think:

'Application caused the lock wait is "xxxxxxxx.xxxxxx.xxxxxxxxx"' is probably the guilty party.

And 'PID:12642(db2agent (SATDB)) Appid:yyyyyyyyy.yyyyy.yyyyyyyyyy' describes the victim.

Yours, Bill


(ps. my knowledge IS for z/OS but this looks familiar...)

what about the sql statement written there(i erased the exact sql statement in forum, but the log message writes a SELECT statement there)
is it the cause or the victim?

The log message SELECT is the victim.

Yours, Bill

ok thanx a lot Bill