Siebel Database Upgrade Guide for DB2 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 Siebel CRM 8.1, Table 7 shows the number of tables in 4-KB, 16-KB, and 32-KB table spaces in a sample Siebel Industry Applications database in a 7.5.x, 7.8, 8.0 and 8.1 release. Table 7 also shows the space required by the tables.

Because Siebel CRM adopted a 1:1:1 database schema structure since Siebel CRM 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 might not require 16-KB and 32-KB table spaces if you convert LONG VARCHAR columns to CLOB columns.

Actual expected growth might 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 Siebel CRM 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. The values shown are adjusted for compression.