Maintenance Manual

4-5
Cisco ICM Enterprise Edition Administrator Guide Release 6.0(0)
Chapter 4 Database Administration
Database Administration Tool
You can expand the sever by clicking on the plus sign (+) next to its name. This
displays the ICM instances that have databases on the server. Expanding the ICM
instance displays a specific ICM node or nodes (Distributor and Logger) on
machines that have databases for that instance. Expanding the node displays the
databases associated with the node. Expanding the node database displays a list
of the individual tables in the node database. Under databases are the table groups,
and the final level lists the tables in the group.
To view the properties of a table, right-click on the desired table in the list and
select Properties from the pop-up menu, or double-click on the table in the list.
There are two ways to access the ICMDBA tool functions. From the main window,
choose a node or database from the tree and then select a function from the menu
bar menu, or right-click a node or database to display a pop-up menu.
Estimating the Size of a Database
Use the Estimate Database function for the following
• Estimate database size
• Control the amount of time that data is retained
• Save a database estimate to a file
• Open a previously saved database estimate file
To estimate a database:
Step 1 For the server, instance, and node (Distributor or Logger), select the database that
you want to estimate.
Step 2 Choose Database > Estimate from the menu bar (or click the right mouse button
and choose Estimate). The Estimate window displays.