Troubleshooting
Problem
In a distributed configuration, when using the Decision Center console and the Rule Execution Server installation manager to configure a DB2 for z/OS database the setup does not work properly and results in errors.
Cause
DB2 for z/OS database requires specific configuration that is provided with dedicated z/OS scripts.
Environment
DB2 on z/OS used with a distributed installation of WebSphere Operational Decision Management
Resolving The Problem
On the z/OS machine where DB2 is installed use the files in the attached ZIP file:
Supplement the instructions in the following topics by running the JCL jobs described below:
- For Decision Center: Step 4: Creating the Decision Center DB2 database
- For Decision Server: Step 5: Configuring a DB2 persistence layer
Rev A: update script for Decision Center to fix version number and String type definition.
On the z/OS machine where DB2 is installed use the files in the attached ZIP file:
Supplement the instructions in the following topics by running the JCL jobs described below:
- For Decision Center: Step 4: Creating the Decision Center DB2 database
- For Decision Server: Step 5: Configuring a DB2 persistence layer
For Decision Center:
- To create the tables use HBRDCCDB.jcl
- To grant authority to the tables use HBRDCGRN.jcl
- To create the RULEAPP tables use HBRDSCDB.jcl
- To create the XOM table use HBRDSXOM.jcl
- To create the EXECUTION_TRACES tables HBRDSCTR.jcl
- To grant authority to the tables use HBRDSGRN.jcl
[{"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0;7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0;7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0;7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
10 August 2022
UID
swg21599674