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 the databases
Create databases in the DB2 for z/OS subsystem
When you use the database design tool (DbDesignGenerator.sh) to define your database configuration, you can generate the database scripts that are required for creating the databases for the IBM BPM components.
You can use various tools to run these database scripts:
- When you run the database design tool to generate the database scripts, the createDB2.sh script is also generated.
You can use createDB2.sh to run the database scripts.
- You can use tools such as the DB2 command line processor, SPUFI, or DSNTEP2 to run the database scripts.
Choose which tool to use
You can choose one tool over another based on experience and familiarity, or personal preference. Your organization might also have implemented standards or conventions for the tools used to create DB2 for z/OS objects, particularly in a production environment.
Considerations for choosing the createDB2.sh script
- createDB2.sh can create all your database objects in one simple execution of the tool, so it is a good choice if this is your first server implementation.
- createDB2.sh runs the database scripts that the database design tool (DbDesignGenerator.sh) generates.
- createDB2.sh runs the SQL for each component in the correct sequence.
- createDB2.sh creates database objects according to a naming convention that you define.
- createDB2.sh organizes the layout of database objects across DB2 for z/OS databases.
- createDB2.sh issues GRANT permissions to database, storage group, and buffer pool objects.
- createDB2.sh automatically completes customization of the service integration bus Data Definition Language (DDL).
- createDB2.sh runs in a UNIX System Services environment.
- createDB2.sh produces an audit trail of the objects that it creates.
Considerations for choosing other tools
- You might prefer to use the DB2 command line processor to run the SQL statements in the UNIX Systems Services environment. You must first run the createDB2.sh script in a mode that bypasses execution of the SQL statements and instead consolidates them into two .sql files. You can then run these files by using the command line processor.
- You might need to copy the database scripts from the IBM BPM file system into a partitioned data set. You can use a tool such as Ddl2Pds.sh to copy the files.
- There is no restriction on the naming or organization conventions that apply to the database objects other than the standard database subsystem restrictions.
- Some tools can be run from a z/OS environment.
- The tools can produce an audit trail of the DB2 database commands that have been issued.
- Configure the DB2 command line processor
Before you run the createDB2.sh script, configure the DB2 command line processor by defining a set of environment variables and a db2 command alias. You must also define alias names that can be used to connect to the DB2 for z/OS server.- Create DB2 for z/OS database objects using the createDB2.sh script
After creating the database scripts for the IBM BPM components, you can run the createDB2.sh script to create one or more databases in the DB2 for z/OS subsystem and populate each database with objects.- Create DB2 for z/OS database objects using the DB2 command line processor
When you run the createDB2.sh script, you can choose to run the SQL immediately to create the database objects for the specified database, or you can bypass running the SQL scripts so that you can run them later. If you bypass execution of the SQL, the createDB2.sh script consolidates the SQL statements into two files (z_schema.sql and z_schemaProc.sql) that you can run later by using the DB2 command line processor.- Create DB2 for z/OS database objects using SPUFI or DSNTEP2
You can use tools such as SPUFI or DSNTEP2 to run the database scripts used to create the DB2 for z/OS database objects for your configuration. If you want to work in the UNIX System Services environment, you can also run the database scripts by using the DB2 command line processor.
Related concepts:
Generate a design file and database scripts for the database objects
Related information:
Ddl2Pds.sh script