System Database Configuration

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:

  • For a CAR database alert (shown in Figure 33-14), the maximum number of rows in the billing table is 2,000,000 rows. A notification is sent when 80 percent of the rows are used. By default, the CAR administrator receives an e-mail, and the users specified in the CC field are also notified. The predefined e-mail subject is "Alert for CAR database." Also, the e-mail message is predefined as "Number of rows in Billing table in the CAR database has crossed the threshold limit."
  • For a CDR database alert (shown in Figure 33-15), the alert mechanism works in the same way, and the threshold is predefined at 80 percent also. The difference is that the maximum number of rows is 1,500,000.

Figure 33-15. Configuring CDR Database Alerts


Database Purges

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:


Step 1.

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


Step 2.

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.

Step 3.

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.

Step 4.

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

Media Resources

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

Monitoring Performance

Configuring Alarms and Traces

Configuring CAR

Using Additional Management and Monitoring Tools

Part VIII: Appendix

Appendix A. Answers to Review Questions


Authorized Self-Study Guide Cisco IP Telephony (CIPT)
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
ISBN: 158705261X
EAN: 2147483647
Year: 2004
Pages: 329 © 2008-2020.
If you may any questions please contact us: