Problem Note 59534: Changing the value for "Number of Days of Audit Records in Data Mart" has no effect on the length of time that audit records are retained
The SAS® Environment Manager audit tables are retained in the data mart based on the value specified in the Number of Days of Resource Records in Data Mart property. They do not honor the value specified for the Number of Days of Audit Records in Data Mart, which is set to 365 by default. Changing the value for Number of Days of Audit Records in Data Mart has no effect on the length of time the audit records are retained. If you want to change the length of time the audit records are retained, you must change the value of the Number of Days of Resource Records in Data Mart. This has an impact on the retention period for both of the records created by the APM (audit, performance, and measurement) and ACM (agent-collected metrics) ETL (extract, transform, and load) processes.
To change the Number of Days of Resource Records in Data Mart property value, do the following:
- Open SAS® Management Console.
- Select Application Management ► Configuration Manager.
- Right-click EnvMgr Enablement Kit 2.2 and select Properties.
- Click the Settings tab.
- Change the value for Number of Days of Resource Records in Data Mart to your desired retention period.
- Click OK to save the new value.
- During the next run of the APM and ACM ETL processes, any records older than the value that you specified are automatically rolled out of the data mart.
Warning: Increasing the value of Number of Days of Resource Records in Data Mart causes the data mart to grow in size. It is strongly discouraged to increase this value unless you have sufficient space to accommodate the growing data mart. If your audit tables are taking up too much disk space, you might want to decrease the value of Number of Days of Resource Records in Data Mart.
Operating System and Release Information
| SAS System | SAS Environment Manager Enablement Kit Server | Microsoft® Windows® for x64 | | 9.4 TS1M5 |
| 64-bit Enabled AIX | | 9.4 TS1M5 |
| 64-bit Enabled Solaris | | 9.4 TS1M5 |
| HP-UX IPF | | 9.4 TS1M5 |
| Linux for x64 | | 9.4 TS1M5 |
| Solaris for x64 | | 9.4 TS1M5 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
SAS® Environment Manager audit tables are retained based on the "Number of Days of Resource Records in Data Mart" property.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2016-12-20 11:07:11 |
| Date Created: | 2016-12-14 14:50:09 |
