/mcpIf you click OK, the records get purged from the selected table. After successful deletion of records, the status message shows the number of records that were deleted from the table. Set Up Automatic Database Purge This section describes how to schedule and disable automatic purging of the CAR database. By default, the system enables automatic database purge. Procedure Step 1 Choose System > Database > Configure Automatic Purge. The Configure Automatic Database Purge window displays. At the top of the window, the percentage amount of the CAR database space that has been used gets displayed. The maximum CAR Database space that is available gets displayed in megabytes. Step 2 From the Low Water Mark drop-down list box, choose the minimum percentage of the maximum CAR database size that you want the system to use for CAR data. The default value specifies 80percent. Tip The system notifies you when the CAR database size reaches the low or the high water mark; it also notifies you when the CAR database size exceeds the maximum number of records. For information on configuring an e-mail alert. Step 3 From the High Water Mark drop-down list box, choose the maximum percentage of the maximum CAR database size that you want the system to use for CAR data. The default value specifies 90percent. Step 4 In the Max Age of Call Detail Records field, enter the maximum number of days that you want to keep the CDRs in the CAR database. Enter a number between 1 and 180. The default value specifies 60days. CAR deletes all CDRs that are older than the specified number of days. Note To restore the default values for the fields in this window, click Restore Defaults. Step 5 Click Update. The changes take effect at midnight. To make changes take effect immediately, restart the Cisco CAR Scheduler service. Note When the 2M or HWM limit is breached: a. CAR deletes the database partitions one by one, starting from the oldest date partition. b. CAR stops purging under one of the following conditions: • When the record count falls below the 2M or HWM limit. • When there is only last two days partitions left on the billing tables. Call Reporting and Billing Administration Guide for Cisco Unified Communications Manager, Release 15 and SUs 45 CDR Analysis and Reporting Set Up Automatic Database Purge