Creating tablespaces for the human task and annotation database on IBM Db2 on z/OS

If you are using Db2 on z/OS, a database administrator must run scripts to create the tablespaces required for the human task and annotation database. The script must be modified to replace the placeholder parameters with ones that are appropriate for your environment.

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

You can use your content store database or a separate database for the human task and annotation database. In either case, you must run the scripts to create the tablespaces.

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 human tasks tablespaces, go to the install_location/configuration/schemas/hts/zosdb2 directory.
    1. Make a backup copy of the HTS_tablespaces.sql script file and save the file to another location.
    2. Open the original HTS_TABLESPACES.sql script file and use the following table to help you to replace the generic parameters with ones appropriate for your environment.
      Table 1. Tablespace parameter names and descriptions for human tasks on Db2 for z/OS

      Parameter Name

      Description

      NCCOG

      Specifies the name of the database.

      DSN8G810

      Specifies the name of the storage group.

      BP32K

      Specifies name of the 32 k buffer pool.

      See the script for a complete list of the parameters required.

    3. Save and run the script.
    4. Open the HTS2_CREATE_Db2zos.sql script file and use the following table to help you to replace the generic parameters with ones appropriate for your environment.
      Table 2. Tablespace parameter names and descriptions for human tasks on Db2 for z/OS

      Parameter Name

      Description

      NCCOG

      The name of the database.

      See the script for a complete list of the parameters required.

    5. Save and run the script.
  3. To create the annotations tablespaces, go to the install_location/configuration/schemas/ans/zosdb2 directory.
    1. Make a backup copy of the ANN_TABLESPACES.sql script file and save the file to another location.
    2. Open the original ANN_TABLESPACES.sql script file and use the following table to help you to replace the generic parameters with ones appropriate for your environment.
      Table 3. Tablespace parameter names and descriptions for annotations on Db2 for z/OS

      Parameter Name

      Description

      NCCOG

      The name of the database.

      DSN8G810

      The name of the storage group.

      BP32K

      The name of the 32 k buffer pool.

      See the script for a complete list of the parameters required.

    3. Save and run the script.
    4. Open the ANS2_CREATE_Db2zos.sql script file and use the following table to help you to replace the generic parameters with ones appropriate for your environment.
      Table 4. Tablespace parameter names and descriptions for annotations on Db2 for z/OS

      Parameter Name

      Description

      NCCOG

      The name of the database.

      See the script for a complete list of the parameters required.

    5. Save and run the script.