Maintenance Manual

4-3

Cisco ICM Enterprise Edition Administrator Guide Release 6.0(0)

Chapter 4 Database Administration

Database Administration Tool

The ICMDBA tool (icmdba.exe) is included with the ICM software and is located

in the \icm\bin directory. This tool provides a central utility that allows you to

manage ICM database administration. Use this tool to:

• Estimate size requirements for databases

• Create, edit and delete central databases, local databases, and historical

database for installed ICM customers

• Resize database files

• Recreate a database

• Import/export data to/from databases

• View database properties

In addition to these tasks, you can use the ICMDBA tool to start or stop a server,

and to do some limited SQL Server configuration.

Note Before using the ICMDBA tool, the ICM software for a customer must be

installed. See the Cisco ICM Enterprise Edition Installation Guide for

information on the ICM installation.

Ta b l e 4 - 1 H i s t o ri c a l Ta b l e s

Historical Tables Default Retention Time

Application_Event, Config_Message_Log, Event 14 days

Logger_Admin, Recovery 30 days

All other historical tables 14 days in Logger, 1095

days in HDS