In the System > Database menu, you can configure CAR to notify an administrator when the CAR database size or CDR database size exceeds a percentage of the maximum number of records, as shown in Figure 33-14. Set the message and the maximum number of records, and specify the alert percentage. CAR restricts you from editing the maximum number of records in the CDR database. Sometimes, it might be necessary to purge the database to reallocate the database space. You can use the System > Database > Manual Purge or Configure Automatically to disable database purging manually, or automatically purge the database.
Figure 33-14. Configuring CAR Database Alerts
CDR and CAR Database Alerts
With the database alerts, CAR informs the administrator about predefined alert thresholds:
Figure 33-15. Configuring CDR Database Alerts
Storage in the database is limited, so you must purge the database from time to time. To do this operation manually in the Manual Database Purge configuration area, follow these steps:
In CAR, choose System > Database > Manual Purge. The screen that appears is illustrated in Figure 33-16. Choose the database in the Select Database drop-down list. The two possible options are CAR and CDR.
Figure 33-16. Manually Purging the CDR Database
Choose the table to purge using the Select Table drop-down list. Possible values are the CallDetailRecord, Tbl_Billing_Data, Tbl_Error_Log, and Tbl_Purge_History tables. The Table Information button displays an overview of the number of records in each of the tables and shows when the first and last records were stored in the database.
To delete records, use the Delete Records option. Database entries older than the date specified in the Older Than field or from the range of dates specified in the Between fields will be deleted.
Click the Purge button.
In addition to the manual purge option, CallManager can purge the databases automatically by configuring the parameters in the Configure Automatic Database Purge area. All data older than the specified number of days will be deleted from the CDR or CAR database. In the example illustrated in Figure 33-17, CallManager will automatically purge records in the database older than 100 days.
Figure 33-17. Automatically Purging the CDR Database
In most cases, third-party products are used for billing. Make sure you do not purge the database before the billing system has replicated the data. Some billing products are also able to delete the data after a successful replication. Be aware that there is no way to restore the deleted database entries after the purge. Automatic purging of both the CDR and CAR databases is disabled by default.
Part I: Cisco CallManager Fundamentals
Introduction to Cisco Unified Communications and Cisco Unified CallManager
Cisco Unified CallManager Clustering and Deployment Options
Cisco Unified CallManager Installation and Upgrades
Part II: IPT Devices and Users
Cisco IP Phones and Other User Devices
Configuring Cisco Unified CallManager to Support IP Phones
Cisco IP Telephony Users
Cisco Bulk Administration Tool
Part III: IPT Network Integration and Route Plan
Cisco Catalyst Switches
Configuring Cisco Gateways and Trunks
Cisco Unified CallManager Route Plan Basics
Cisco Unified CallManager Advanced Route Plans
Configuring Hunt Groups and Call Coverage
Implementing Telephony Call Restrictions and Control
Implementing Multiple-Site Deployments
Part IV: VoIP Features
Configuring User Features, Part 1
Configuring User Features, Part 2
Configuring Cisco Unified CallManager Attendant Console
Configuring Cisco IP Manager Assistant
Part V: IPT Security
Securing the Windows Operating System
Securing Cisco Unified CallManager Administration
Preventing Toll Fraud
Hardening the IP Phone
Understanding Cryptographic Fundamentals
Understanding the Public Key Infrastructure
Understanding Cisco IP Telephony Authentication and Encryption Fundamentals
Configuring Cisco IP Telephony Authentication and Encryption
Part VI: IP Video
Introducing IP Video Telephony
Configuring Cisco VT Advantage
Part VII: IPT Management
Introducing Database Tools and Cisco Unified CallManager Serviceability
Configuring Alarms and Traces
Using Additional Management and Monitoring Tools
Part VIII: Appendix
Appendix A. Answers to Review Questions