Cisco Systems Automobile Accessories Not Specified User Manual
C H A P T E R  
31  
Configuring the CAR System Database  
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.  
To configure the CAR system database, go to Cisco Unified Serviceability -> Tools -> CDR Analysis  
and Reporting -> System or Report Config.  
This chapter contains the following topics on how to purge and reload the CAR database:  
•
•
•
•
Manually Purging or Reloading the CAR Database, page 31-1  
Configuring Automatic Database Purge, page 31-3  
Related Topics, page 31-4  
Additional Cisco Documentation, page 31-4  
Manually Purging or Reloading the CAR Database  
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:  
•
Deactivate the CAR Web Service in the Serviceability Service Activation window (Cisco Unified  
Serviceability > Service Activation).  
•
Stop the CAR Web Service in the Feature Services window of the Serviceability Control Center  
(Cisco Unified Serviceability > Tools > Control Center - Feature Services).  
The CDR Loader cannot begin again until either the CAR Web Service or the CAR Scheduler gets  
restarted.  
Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide  
OL-24541-01  
31-1  
 
   
Chapter 31 Configuring the CAR System Database  
Configuring Automatic Database Purge  
Step 5  
Step 6  
Choose the date range of the CAR records that you want to delete.  
To delete all records older than or between the dates that you specified, click the Purge button.  
A prompt advises you that you are about to permanently delete the specified records.  
To purge the records, click the OK button or click the Cancel button to abort the purge operation.  
Step 7  
If 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.  
Additional Information  
See the “Related Topics” section on page 31-4.  
Configuring 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  
Step 2  
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.  
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.  
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, see the “Enabling or Disabling Alerts by Mail”  
section on page 36-4, for instructions.  
Step 3  
Step 4  
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.  
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.  
Note  
To restore the default values for the fields in this window, click the Restore Defaults button.  
Step 5  
Click the Update button.  
The changes take effect at midnight. To make changes take effect immediately, restart the Cisco CAR  
Scheduler service.  
Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide  
OL-24541-01  
31-3  
 
 
Chapter 31 Configuring the CAR System Database  
Related Topics  
Note  
When the 2M or HWM limit is breached:  
1. CAR deletes the database partitions one by one, starting from the oldest date partition.  
2. 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.  
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:  
1. CAR loader stops processing the new records.  
2. CAR starts purging the records from the oldest partition till the record count reaches 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.  
Additional Information  
See the “Related Topics” section on page 31-4.  
Related Topics  
•
•
•
•
CDR Analysis and Reporting Configuration Checklist, page 2-1  
Chapter 29, “Configuring CAR System Parameters”  
Chapter 30, “Configuring the CAR System Scheduler”  
Chapter 32, “Generating the CAR System Event Log”  
Additional Cisco Documentation  
•
•
•
Cisco Unified Communications Operating System Administration Guide  
Cisco Unified Serviceability Administration Guide  
Cisco Unified Communications Manager Call Detail Records Administration Guide  
Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide  
OL-24541-01  
31-4  
 
   

Belgacom Telephone SPA942 User Manual
Black Box Computer Accessories 26577 User Manual
Black Box Network Cables Flexpoint 10 100 User Manual
Briggs Stratton Yard Vacuum 37641401 User Manual
Brother Sewing Machine BE 0901EAC User Manual
Califone Mouse KM PA User Manual
Califone Portable Speaker PI30 Series User Manual
CAVS DVD Player CAVS JB 199 User Manual
Cecilware Fryer F 100 User Manual
Char Broil Charcoal Grill 10501572 User Manual