Creating the Decision Center DB2 database on z/OS

An empty DB2® database is required for Decision Center. You create one on the z/OS® platform for use with the application on a distributed platform.

Before you begin

Before you do this step, check that you have a supported version DB2 for z/OS installed, and that you have DB2 Administrator authority to CREATE a database and CREATE and UPDATE tables.DB2.

About this task

If you want to use a DB2 database on z/OS, you must create the database schema by running the provided JCL jobs and SQL scripts on the z/OS system where DB2 is installed.

After you customized the JCL variables for your configuration, you can submit the jobs to create a database for Decision Center.

Procedure

  1. Copy HBRDC*.jcl and HBRDC*.sql files from /teamserver/jcl folder.

    The *.sql and *.jcl files must be edited before you submit them.

    Note: You must customize the JCL as required, as indicated in the comments within each PDSE member, before you run them on the z/OS system. You can customize the JCL either by using a manual search and replace, or by using an ISPF macro.
  2. Submit the JCL jobs.