If these tables are large enough the sesseion cleanup and reaper casues deadlocks specially on DB2 .
This issue could be happing on oracle as well in versions AA sp2 andd sp2p1.
First try these quaries and see if there is more than hand full of records on these tables. If there a lot of records.
follow the steps for solution.
These tables should have not more than 20 records in them reaper task must cleanup these up daily.
Select count(*) from RSASESSION;
Select count(*) from RSATRANSACTION;
Select count(*) from SESSIONACSP;
1) Shutdown AAoP. you need to stop your app server for the AAoP
2) Truncate these tables
Truncate SESSIONACSP;3) Startup AAoP
|Legacy Article ID||a54559|