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