Cisco OL-24541-01 User Manual

CHAP 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 -> Too ls -> 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 > Too ls > Control Center - Feature Services).

The CDR Loader cannot begin again until either the CAR Web Service or the CAR Scheduler gets
restarted.

OL-24541-01

Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide

31-1

Manually Purging or Reloading the CAR Database

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.

Procedure

Step 1 Choose System > Database > Manual Purge.

The Manual Database Purge window displays.

Step 2 Choose one of the following actions:

Chapter 31 Configuring the CAR System Database

• To delete the existing CAR data and reload the CAR database, click the Reload All Call Detail

Records button.

The system displays a message that indicates that deleting the records may impact system
performance. To continue the reload process, click OK.

The system begins loading the CDRs into the CAR database within 5 minutes and continues
uninterrupted for up to 6 hours. To monitor the progress of the reload, generate the CDR Load event
log, as described in the “Generating the Event Log” section on page 32-1.

After the system loads the new records, the system loads the records according to the schedule that
is configured in Chapter 30, “Configuring the CAR System Scheduler”. By default, CDR data loads
24 hours per day and 7 days per week.

• To manually purge selected CAR records, continue with Step 3.

Step 3 In the Select Table field, choose the table in the database that you want purged.

To view the tables for which manual purge is permitted, the total number of records in the table, and the
latest record and oldest record in the table, click the Tab le In f o rm a ti o n button.

The Table Information window displays. You will see a table with the following information:

Database Name Table Name Total No. of Records Latest Record Oldest Record

CAR Tbl_billing_data 0 0 0

CAR Tbl_billing_error 0 0 0

CAR Tbl_purge_history 0 0 0

31-2

To return to the Manual Database Purge window, click the Close button.

Step 4 In the Delete records field, choose a date that will determine which records will be purged by clicking

one of the following radio buttons:

• Older than—Choose a date for which all records before that date will be deleted.

• Between—Choose a range of dates between which all records will be deleted.

Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide

OL-24541-01