Siebel Database Upgrade Guide for DB2 UDB for z/OS > Planning A Siebel Database Upgrade >

About Estimating Database Size

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 8.0, Table 7 shows the number of tables in 4-KB, 16-KB, and 32-KB table spaces in a sample SIA database in a 7.0.x, 7.5.x and a 7.8 release. Table 7 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 table space, one table space in each database), these releases require many more 16-KB and 32-KB table spaces than pre 7.7 releases. However, some tables may not require 16-KB and 32-KB table spaces if you convert LONG VARCHAR columns to CLOB columns.

Actual expected growth may also vary widely from these estimates, depending on which Siebel application you are using (Siebel Business Applications or Siebel Industry Applications), database configuration, row size of tables, data content, and code page. The number of tables and space estimates shown in Table 7 for Release 8.0 are for an EBCDIC database.

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