Upgrade Guide for Microsoft Windows > Preupgrade Tasks > Preparing the Database for a DB2 Upgrade >

Creating DB2 Temporary Tablespaces and Bufferpools

If your RDBMS is DB2 UDB, 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 5,000 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 1,000 32-KB pages.
  2. Create a 32-KB temporary tablespace as SMS that can be expanded to 2 GB of storage.

 Upgrade Guide for Microsoft Windows
 Published: 20 October 2003