Hi All,

We have being facing a weird issue in our environment since 3 months now. App details are below.

Tivoli Identity manager 5.1 deployed on WAS 7.

Issue : We have a feature in TIM 5.1 where we can check the number of pending transactions in queue, which technically is a fuction that queries database and gets the results. From 3 months it intermittently happens that the query acquires the lock on  database and the view pending requests page gets hanged(or doesn't give back o/p which it has to give) and when we force the lock manually (sometimes it clears by itself) on database the veiw pending request function works fine.

We haven't noticed any pattern in these locks and its intermittent. The same query returns o/p all the time but hangs when locks is acquired and not released for long time.


TroubleShooting steps followed :

As the issue was impacting production env, we have opened PMR with both TIM and DB2.Below actions were suggested and performed by PMR.

1. DB size was very high so deleting old unwanted data, retaining only 400 days of data.
2. Providing thread dumps and db snapshots to PMR when locks happen.

Even PMR is striving to find the root cause with little luck so far.


P.S: I know its not purely a WAS related issue, but thought you people can share some ideas on how to investigate the issue.

Thanks in Advance.

Regards,
Pavan