Adding a Temporary Tablespace to the Primary Database

Add a temporary tablespace to the primary database.

  1. In the Control Center All Databases view, right-click the Table Spaces folder under your primary database, and select Create from the context menu.
  2. In the Name window, specify a name for the new table space, and select the Let DB2 Manage My Storage radio button. Click Next.
  3. In the Type window, select User Temporary, and click Next.
  4. In the Buffer Pool window, click Create.
  5. In the Create Buffer Pool window, specify a name for the buffer pool, specify at least 8KB as the page size in the drop-down menu, select Create Bufferpool Immediately, and click OK.
  6. Click Finish to create the table space. The new table space appears in the Table Spaces folder.