Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >
Creating IBM DB2 Temporary Tablespaces and Bufferpools for a Siebel Upgrade
Upgrades from: All Supported Siebel releases.
Environments: Development, production test, production.
Databases: IBM DB2 only.
This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.
If your RDBMS is IBM DB2, 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
- Create a 16-KB bufferpool with at least 5000 16-KB pages.
- 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
- Create a 32-KB bufferpool with at least 1000 32-KB pages.
- Create a 32-KB temporary tablespace as SMS that can be expanded to 2 GB of storage.