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 12 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 12 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 12 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.

Table 12. Number of Tables and Space Required in a Sample Siebel DB2 Database by Release
Release...
4-KB Tablespace
16-KB Tablespace
32-KB Tablespace

7.8

3857 (569,442 KB)

459 (237,735 KB)

86 (224,62 KB)

7.5.x

2542 (637,706 KB)

404 (336,384 KB)

22 (143,28 KB)

7.0.x

1995 (398,068 KB)

357 (135,469 KB)

10 (102,39 KB)

Upgrade Guide for DB2 UDB for z/OS