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.