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

Creating DB2 32-KB Tablespace and Bufferpool

If you are upgrading from Release 6.x and your RDBMS is DB2 UDB, you must create a new 32-KB tablespace and bufferpool in order for the upgrade to complete successfully.

NOTE:  Skip this step if you are upgrading from Release 7.x, because you already created your 32-KB tablespace and bufferpool. Instead, perform the task described in Increasing DB2 32-KB Tablespace.

To create 32-KB tablespace and bufferpool

  1. Create a 32-KB bufferpool, with the number of pages equal to at least 1,000 32-KB pages.
  2. Create a 32-KB tablespace using the DB2 tools of your choice.

This completes creation of your new 32-KB tablespace and bufferpool.


 Upgrade Guide for Microsoft Windows
 Published: 20 October 2003