Creating tablespaces for a notification database on IBM® Db2 for z/OS

If you are using Db2 for z/OS, a database administrator must run scripts to create a set of tablespaces required for the notification database. The scripts must be modified to replace the placeholder parameters with ones that are appropriate for your environment.

Ensure that you use the naming conventions for Db2 for z/OS®. For example, all names of parameters must start with a letter and the length must not exceed 6 characters. For more information, see the Db2 Knowledge Center.

Procedure

  1. Connect to the database as a user with privileges to create and drop tablespaces and to allow execution of SQL statements.
  2. To create the notification tablespaces, go to the install_location/configuration/schemas/delivery/zosdb2 directory.
    1. Make a backup copy of the NC_TABLESPACES.sql script file and save the file to another location.
    2. Open the original NC_TABLESPACES.sql script file and use the following table to help you to replace the placeholder parameters with ones appropriate for your environment.
      Table 1. Tablespace parameter names and descriptions for the Db2 notification database on z/OS

      Parameter Name

      Description

      NCCOG

      Specifies the name of the notification database.

      DSN8G810

      Specifies the name of the storage group.

      BP32K

      Specifies the name of the buffer pool.

      Not all of the parameters listed are in the script, but might be added in the future.

    3. Save and run the script.
      For example, 
      db2 -tvf NC_TABLESPACES.sql
    4. Open the NC_CREATE_DB2.sql script file and replace the NCCOG placeholder parameter with the name of the notification database.
    5. Save the script.

      The Job and Scheduling Monitor services will automatically run the script. However, you may choose to run it yourself.