Upgrade Guide for DB2 UDB for z/OS > Database and UI Upgrade Planning >

About Estimating Database Size

Upgrades: All upgrades.

Environments: All environments.

Database upgrade is resource intensive. If the upgrade exceeds available resources, the upgrade halts. You must then resolve resource issues before resuming the upgrade.

To help you estimate the database size required when upgrading to release 7.8, Table 11 shows the number of tables in 4-KB, 16-KB, and 32-KB tablespaces in a sample SIA database in a 7.0.x, 7.5.x and a 7.8 release. Table 11 also shows the space required by the tables.

Because Siebel has adopted a 1:1:1 database schema structure since release 7.7 (one table in each tablespace, one tablespace in each database), these releases require many more 16-KB and 32-KB tablespaces than pre 7.7 releases. However, some tables may not require 16-KB and 32-KB tablespaces if you convert LONG VARCHAR columns to CLOB columns.

NOTE:  Table 11 shows the space required by the tables in a release but does not include the space required by indexes.

Actual expected growth may also vary widely from these estimates, depending on which Siebel application you are using (Siebel Business application or Siebel Industry application), database configuration, row size of tables, and data content.