000016815 - Adaptiveauthentication- Db2 deadlocks can stop responding due to large number of records sin RSASESSION  RSATRANSACTIOn and SESSIONACSP tables

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000016815
Applies To

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.

Resolution

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;

 

 

 Solution:

 

1) Shutdown AAoP. you need to stop your app server for the AAoP

2) Truncate these tables

            Truncate RSATRANSACTION;

            Truncate RSASESSION;

            Truncate SESSIONACSP;

3) Startup AAoP
Legacy Article IDa54559

Attachments

    Outcomes