Verify the Daily Purge Cycle on the Logger Successfully Completes [Cisco Unified Intelligent Contact Management Enterprise]

Document ID: 49668

Questions

Introduction
How do I verify whether the daily purge cycle on the Logger has successfully completed?
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

This document provides information on the correct way to verify whether the daily purge run on the Logger has successfully completed in the Cisco Intelligent Contact Management (ICM) environment.

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Q. How do I verify whether the daily purge cycle on the Logger has successfully completed?

A. ICM initiates a purge process on each Logger once a day. By default, the purge process runs each night at 12:30 A.M, and deletes records that are older than a specified number of days. When you configure the ICM databases, you can specify the number of days to keep data for each table in the database on the Logger.

ICM has automatic checks to prevent the central database from becoming full. If the Automatic Purge option is selected when you install the Logger software, ICM automatically deletes the oldest historical data. This is if the data exceeds the retention period when the central database nears capacity. If the data has not exceeded the retention period, it does not delete. By default, automatic purge occurs when the database is 95% full, but you can set the percentage when you set up the Logger. You can also set the retention period for data when you set up the Logger.

If the purge cycle runs successfully, this log for the Recovery Process on the Logger appears:
Figure 1 – Log for the Recovery Process on the Logger

In ICM, there is a table which contains one record of information for each administrative task the ICM software applies to the central database. Specifically, this table tracks Purges and Update Statistics operations. These operations run automatically as scheduled jobs. In ICM versions 4.1 through 4.6.2, the table name is Admin table. In ICM version 5.0, the table is renamed Logger_Admin table. You can issue this command to query the content of the Logger_Admin table:

select TableName,FunctionName,DateTime from Logger Admin

Figure 2 shows the Structured Query Language (SQL) statement and results. The results contain the table name, the purge function, and the date and time the purge began.
Figure 2 – The SQL Statement and Results

This also applies to the Historical Data Server (HDS). A purge process runs daily to delete records from the HDS database.