Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >

Creating IBM DB2 Temporary Tablespaces and Bufferpools for a Siebel Upgrade

Environments: Development, production test, production.

Databases: IBM DB2 only.

If your RDBMS is IBM DB2, then verify that you have 16-KB and 32-KB temporary tablespaces to use for sorting and other SQL processing. Both the 16-KB and 32-KB temporary tablespaces require dedicated bufferpools.

To create a 16-KB temporary tablespace

1. Create a 16-KB bufferpool with at least 5000 16-KB pages.
2. Create a 16-KB temporary tablespace as system managed space (SMS) that can be expanded to 2 GB of storage.

To create a 32-KB temporary tablespace

1. Create a 32-KB bufferpool with at least 1000 32-KB pages.
2. Create a 32-KB temporary tablespace as SMS that can be expanded to 2 GB of storage.