Changing your work database for a migrated installation of Db2

You can change the high-level qualifier for your work database if you have a migrated installation of Db2 for z/OS®.

About this task

Migrated installations do not have a usable DSNTIJTM, because the IDCAMS allocation step is missing.

To change your work database:

1. Stop the database by using the following command (for a database named DSNDB07):

   -STOP DATABASE (DSNDB07)

2. Drop the database by using the following SQL statement:

   DROP DATABASE DSNDB07;

3. Re-create the database by using the following SQL statement:

   CREATE DATABASE DSNDB07;

4. Define the clusters by using the following access method services commands. You must specify the instance qualifier of your data set, y, which can be either I or J.

      ALTER oldcat.DSNDBC.DSNDB07.DSN4K01.y0001.A001
         NEWNAME newcat.DSNDBC.DSNDB07.DSN4K01.y0001.A001
      ALTER oldcat.DSNDBC.DSNDB07.DSN32K01.y0001.A001
         NEWNAME newcat.DSNDBC.DSNDB07.DSN32K01.y0001.A001

   Repeat the preceding statements (with the appropriate table space name) for as many table spaces as you use.

5. Create the table spaces in DSNDB07 by using the following commands:

   CREATE TABLESPACE DSN4K01
     IN DSNDB07
     BUFFERPOOL BP0
     CLOSE NO
     USING VCAT DSNC910;

   CREATE TABLESPACE DSN32K01
     IN DSNDB07
     BUFFERPOOL BP32K
     CLOSE NO
     USING VCAT DSNC910;

6. Start the database by using the following command:

   -START DATABASE (DSNDB07)