Cisco Cisco IPCC Web Option Installation Guide

Page of 180
Calculate Necessary File Size
The following sections provide instructions on determining the requirements for your migration.
How to calculate the required disk space for the migration
Step 1
Use the ICMDBA tool to gather database information.
Step 2
Right-click on the database and select Properties.
Note: The Database Used Size = Percent Used of the Data Size Value.
Step 3
Determine and document the amount of rows and the size of the copy/drop tables.
To accomplish this:
Select the database.
Select Data > Space Used Summary.
Note: The default setting lists the largest tables.
Step 4
Calculate the required disk space for the migration.
If none of the copy/drop tables have more than 7,000,000 rows:
Determine the DUS (Database Used Size).
Determine the required disk space for the database migration where:
Required Disk Space = 2*DUS
If at least one of the tables listed above has more than 7,000,000 rows, and you are not able to
reduce the row count(s) to less than 7,000,000 then:
Determine the following values:
TTSA (Total Table Size from all copy/drop tables
DUS (Database Used Size)
maxTSL (Table Size of the largest copy/drop table)
Determine the database file size where:
Required Disk Space = [(2*DUS) - TTSA] + (2*maxTSL)
Upgrade Guide Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.0(0)
29
Chapter 5: ICM/IPCC 7.0(0) Upgrade Time and Space Requirements
Database Migration Performance