search cancel

UBP database cleanup

book

Article ID: 256795

calendar_today

Updated On:

Products

CA Risk Authentication CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort) CA Advanced Authentication

Issue/Introduction

Can the UBP database table be cleaned since it contains excessive amounts of outdated data (e.g., for users/devices that don't exist anymore)?

Environment

Release : 9.1 SP2

Resolution

Below is the query to cleanup the UBP data for the users who are deleted from the system.

DELETE FROM XUBPDATA where (USERNAME,ORGNAME) IN (SELECT USERID,ORGNAME from ARUDSUSER_ARCHIVE);

The DBA should be involved if the ARUDSUSER_ARCHIVE table has large data (approximately 1M) to add the necessary indexes.

Customer with only a few records (approximately 1k or 2k) does not need an index.