IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced for z/OS: Process Server > Configure IBM BPM Advanced for z/OS: Process Server > Create and augmenting profiles > Set up the configuration file system and creating a profile

Generate a design file and database scripts for the database objects

Before you create and configure the default profile, you must define the database configuration values that will used to create the database objects for the stand-alone server or ND cell.

When you created the customization definition in zPMT, you were presented with the option to define the database configuration within the zPMT windows, or to use a database design file. For DB2 for z/OS , a database design file is the only viable option. If you do not have an existing file ready for use, you can create the file in either of the following ways:

• Use the configuration planning spreadsheet to create a database design file. See Collating customization information for configuring your environment.

• Run the database design tool (DbDesignGenerator.sh) to generate the design of your database configuration in a database design file. The design can be for an enterprise-level database configuration supporting full Business Process Management functionality, or for a specific component.

About the database design tool

Use the database design tool to specify the database configuration values for the IBM BPM database components. The benefit of using the database design tool is that it allows for each of the database components to be configured with different settings; for example, schema names.

The database design tool produces the following output:

• The database design file, which is used to store the database configuration values that you specified when you ran the tool. This file must be specified as the value for the bpmdbDesign parameter in the augmentation response file that will be used to configure the runtime environment.

• The database scripts, which you can run to create the DB2 for z/OS database objects for the various IBM BPM components.

You can generate a database design file and associated database scripts in a single process flow by running the database design tool in interactive mode. If you have an existing database design file and want to generate associated database scripts, you can run the database design tool in silent mode.

Tip: To use an existing database design file, the file must have been created or edited by running the database design tool in interactive mode in your current version of IBM BPM. Database design files created in one version of the product must be edited before being used in another version of the product because the database configuration parameters for the database components might vary slightly across versions.

The DbDesignGenerator.sh script is located in the WAS_HOME/util/dbUtils directory, where WAS_HOME represents the home location of the configuration directories for the node; for example, /WebSphere/V8T8DM/DeploymentManager.

• Create a database design file and database scripts for a stand-alone profile or deployment environment by using the database design tool
  

  You can use the database design tool to generate a database design file that can be used when setting up a stand-alone or ND environment. The database design tool optionally generates database scripts that you can use to create your database tables.

• Create a database design file and database scripts for a specific component by using the database design tool
  

  You can use the database design tool to generate a design file, and optionally database scripts, for the database tables required by specific IBM BPM components.

• Generate scripts for creating database objects in DB2 for z/OS
  

  If you have an existing database design file, you can use it to generate database scripts for creating IBM BPM database objects in a DB2 for z/OS database subsystem.

• Database design tool examples
  

  You can use the database design tool to generate a design file for different types of databases, including DB2, Oracle, and SQL Server.

• Troubleshooting the database design tool
  

  If you have errors in your database scripts, you can use the diagnostic and validation information provided by the database design tool to diagnose the problems.

Set up the configuration file system and creating a profile

Related tasks:
Create customization definitions for fully customized profiles
Create the databases