It's all about the answers!

Ask a question

Why are we getting repeated lock wait warnings on the SCM.CONTENT_CLAIMER table?


Michael Walker (99215201157) | asked May 07 '13, 1:51 a.m.
We started getting multiple lock wait warnings each hour recently against one of our RTC  backend databases in DB2.  The statement is LOCK TABLE SCM.CONTENT_CLAIMER IN SHARE MODE. 

What are the possible reasons that this is occurring?  Is this multiple people or applications trying to check-out the same file and one user already has the lock?

I looked at the rows inside that table but couldn't get an idea exactly what it's used for.

Comments
Michael Walker commented May 08 '13, 3:16 a.m.

bump bump bump

One answer



permanent link
Tim Mok (6.6k38) | answered May 08 '13, 10:19 a.m.
JAZZ DEVELOPER
This wouldn't be caused by multiple users loading the same content or having a file locked. This looks like a problem at the database level. I suggest taking a look at the tuning guide or contacting IBM support.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.