Installation Guide

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