Database Archive tables clarification in dbtrim.properties for Advanced Authentication
Article ID: 204661
Updated On:
Products
Issue/Introduction
We have configured the dbtrim.properties file to remove the data from the Archive tables, the setting is 90 days or 1 million records but there is 45 million records still in some of the tables e.g. ARRFSYSAUDITLOG_AR table.
Environment
Release : 9.1.x
Component : AuthMinder(Arcot WebFort) CA Strong Authentication
CA Risk Authentication
Resolution
Use # to comment the RetainDays and MaxRetainedRows properties per your requirement.
When you comment RetainDays, you can trim the data by number of the rows
When you comment MaxRetainedRows, You can trim the data by number of days (RetainDays).
When you do not comment RetainDays and MaxRetainedRows, DB trim triggers when the first condition of the two properties is met.
|
RetainDays = 150 MaxRetainedRows = 7500000000 Enabled_Archive_Trim = true CronValue_Archive_Trim = 00 00 ? * 7L |
- RetainDays
Specifies the number of days for data retention.
Default:
150
- MaxRetainedRows
Specifies the maximum number of rows for retention. Change this value if you expect large spikes of activity in your system.
Default:
7500000000
- Enabled_Archive_Trim
Enables deleting from archive log table.
Default:
False For more information about the supported tables, see Supported Archive Tables Information.
- True
- Initiates the Archive Trim and deletes the data from archive log table
- False
Does not initiate the Archive Trim.
- CronValue_Archive_Trim
Schedules the archive trim job.
Default:
00 00 ? * 7L fires at 12 AM on last Saturday of every month. See Cron Scheduler for more information.
Additional Information
https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/advanced-authentication/9-1/administrating/database-trimming.html
Feedback
