Release Notes (FixPak 3)

2Do not partition information catalog tables

2Tables that the Information Catalog Manager uses must be contained within a 2single database partition. Numerous methods are available to put the 2tables within a single partition. The following procedure is one 2approach that works. 2

1. 2Open a DB2 Command Line Processor and issue these commands: 2

   1. 2CREATE DATABASE PARTITION GROUP pgname ON DBPARTITIONNUM pnumber

   2. 2CREATE REGULAR TABLESPACE tsname IN DATABASE PARTITION GROUP pgname
      2     MANAGED BY SYSTEM USING ('cname')

      2

   2Click Start --> Programs --> IBM DB2 --> Set-up Tools --> Manage 2Information Catalog Wizard.

   2On the Options page, specify the table space name in the Table 2space field. 2