Creating the Decision Center DB2 database

After you customize the JCL files, you can set up the DB2® database. A DB2 database on z/OS® can be used for a Decision Center, irrespective of where the Decision Center application is running.

Before you begin

Ensure that you have DB2 administrator authority to create a database, and to create and update tables.

About this task

JCL jobs are provided in the ++HBRHLQ++.SHBRJCL data set to create a DB2 database. You can customize these jobs to meet your requirements. The HBRUUPTI job creates the instance of the server and configures the jobs with the values defined in the HBRINST member. For more information, see the DCDB control statement in Customizing the control statements for your topologyCustomizing the z/OS configuration and runtime variables.

Note:

You must customize the variables, as indicated in the comments within each PDSE member, before you run the HBRUUPTI job on the z/OS system. Customize the JCL either by using a manual search and replace, or by using an ISPF macro. Your customized variables are used to create your new data sets, so it is important to review your variable values before you run any job.

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

Procedure

  1. If you are using RACF®, configure RACF security for the DB2 database by adding the ++DB2GROUP++ to an existing superior group by using the following command: 
    ADDGROUP ++DB2GROUP++ SUPGROUP(SYS1) OWNER(SYS1)

    Where ++DB2GROUP++ represents the name of the RACF security group that is provided to you by your security administrator.

  2. Run the HBRDCCDB JCL job to create the database artifacts for Decision Center. The database administrator typically performs this task.

    The job is in the ++HBRWORKDS++.SHBRJCL data set. ++HBRWORKDS++ represents the high-level qualifier that is assigned to the working data sets.

    Note:

    Verify that the JCL jobs contain the correct settings for your site. The settings were copied from the ++HBRHLQ++.SHBRPARM(HBRINST) member when you created the working data sets.

  3. Give the RACF ++DB2GROUP++ access to the created tables by running ++HBRWORKDS++.SHBRJCL(HBRDCGRN).
  4. Add the user ID to the++DB2GROUP++ to connect to the database by submitting the following command: 
    CONNECT ++DB2USER++ GROUP(++DB2GROUP++)

    Where ++DB2USER++ is the user ID to access DB2.