The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.
You can configure CAR to notify you when the CAR database size exceeds a percentage of the maximum number of records. You can set the message and the maximum number of records and specify the alert percentage.
You can configure the system to maintain the CAR database size between the low water mark and the high water mark values that you configure through the Configure Automatic Database Purge window. When the database size reaches the low water mark, CAR sends an alert to the user. When the database size reaches the high water mark, the system deletes records based on the deletion age and sends an e-mail.
This section describes how to manually purge selected records from the CAR database and how to delete all of the CAR data and reload the database with new CDR data. You may want to reload the database to reclassify calls after dial-plan updates, user-device association changes, call rate changes, and so on.
Before you begin to manually purge data, disable the CDR Loader.
Manual purging of the CDRs gets stopped if the CAR Web Service is stopped during the manual purge process. Manual purging cannot begin again until the CAR Web Service restarts. Then you must begin the manual purge process again.
There are two ways to intentionally stop the CAR Web Service:
The CDR Loader cannot begin again until either the CAR Web Service or the CAR Scheduler gets restarted.
A CAR administrator can no longer generate CAR reports when a manual purge of the CAR database is in process or CDR records are reloading. The following error message displays when you try to run reports during these processes:
10023: Manual Purge/Reload is in process. Please run the reports once the Manual Purge/Reload is over.
Both the Purge button and the Reload All Call Detail Records button get disabled, and the following alert message displays on the Manual Purge window, when either a manual purge or CDR reload occurs:
Manual Purge/Reload is still running. User will not be allowed to run another instance of Manual Purge/Reload. So, both Purge and Reload All Call Detail Records buttons are disabled.
This section describes how to schedule and disable automatic purging of the CAR database. By default, the system enables automatic database purge.
Step 1 |
Choose . 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 80 percent.
|
||
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 90 percent. | ||
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 60 days. CAR deletes all CDRs that are older than the specified number of days.
|
||
Step 5 |
Click the Update button. The changes take effect at midnight. To make changes take effect immediately, restart the Cisco CAR Scheduler service.
In cases where there are large number of CDRs present in the billing tables and deleting the partitions does not bring the record count below the 2M or HWM limit, CAR holds at least two days data in the database. When the record count in the database reaches the 2M or HWM limit:
If the record count does not fall below the 2M or HWM limit even after deleting the records, CAR holds at least two days records and stops the CAR loader. Also, CAR sends an e-mail notification to CAR administrator to proceed with manual purge. Following an upgrade, the Configure Automatic Database Purge > MAX DATABASE AGE parameter will be changed to one of the following:
|