Bookshelf Home | Contents | Index | Search | PDF

Upgrade Guide for Microsoft Windows > Preupgrade Tasks >

Verifying Database Server Configuration

---

Before you begin your upgrade, you must verify your database configuration. Later steps of the upgrade process are database-intensive and demand that your database have sufficient resources available. While specific requirements vary by database platform, the consequences of exceeding available resources are the same across platforms: a halted upgrade that requires you to allocate time to adjust the environment and then resume the upgrade.

NOTE:  If you want to change your database platform in conjunction with your upgrade, contact Siebel Technical Services for assistance.

For all platforms, the growth percentage increases depending on how you size your database and configure default storage for database tablespaces. For example, if you set the default storage for your initial or next extent in a given Oracle tablespace to 10 KB, that tablespace will grow by a smaller percentage than if you set it to 100 KB.

For estimates of growth percentages for specific RDBMS platforms and releases, see Table 7 for DB2 UDB, Table 8 for Oracle, and Table 9 for MS SQL Server.

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

Table 7.  DB2 UDB Database Growth Estimates

If Upgrading from Release...	4-KB tablespace	16-KB tablespace	32-KB tablespace
7.0x	35%-90%	25%-100%	30%-40%
6.3x	200%	400%	No change
6.2x	200%	400%	No change
6.0x	00%	400%	N/A

Table 8.  Oracle Database Growth Estimates

If Upgrading from Release...	Tables	Indexes
7.0x	35%-80%	25%-55%
6.3x	40%-70%	70%-90%
6.2x	40%-70%	70%-90%
6.0x	40%-70%	70%-90%

Table 9.  MS SQL Server Growth Estimates

If Upgrading from Release...	Tables	Indexes
7.0x	40%-90%	40%-100%
6.3x	N/A	N/A
6.2x	40%-60%	60%-90%
6.0x	40%-60%	60%-90%

When you upgrade from earlier versions of Siebel eBusiness Applications to Release 7.5, expect database growth in the range of 30%-60% across all platforms. The amount by which it grows depends on a number of factors, such as the size of your database prior to upgrade and the RDBMS you use.

Review the configuration requirements for your specific database platform and make sure that your database server configuration meets or exceeds them.

• For server configuration requirements for IBM DB2 UDB, see DB2 Universal Database Server Configuration.
• For server configuration requirements for Microsoft SQL Server, see Microsoft SQL Server Database Server Configuration.
• For server configuration requirements for Oracle, see Oracle Database Server Configuration.

Bookshelf Home | Contents | Index | Search | PDF