Creating users for Oracle databases
- If the Create Tables option is selected, database tables are automatically created at the same time as the deployment environment. Therefore, the database users must exist before you run the Deployment Environment wizard.
- If the Create Tables option is not selected, database table creation is deferred when you create the deployment environment. Therefore, you can create the database users either before or after you run the Deployment Environment wizard. You might find it useful to create the database users after running the wizard because you can use the set of populated scripts, which the wizard generates, to create the database users and database tables at a time that you choose.
Before you begin
Tuning item | Minimum memory for initial settings (MB) |
---|---|
Buffer cache | 2048 |
Shared pool size | 1024 |
Recommendations for database tablespace settings:
On Oracle, IBM® Business Process Manager stores large objects (LOBs) with the SECUREFILE option. For SECUREFILE, it is recommended to use a tablespace with the AUTOALLOCATE option. If you use UNIFORM SIZE extents, ensure that the UNIFORM SIZE is big enough. Given the default block size of 8K, specify a UNIFORM SIZE of at least 120K. IBM BPM does not explicitly prescribe the tablespace options; it relies on the default Oracle settings (such as AUTOALLOCATE) to automatically manage extents.
For new IBM BPM installations, create tablespaces with the AUTOALLOCATE option.
For migrations, if you use tablespaces with a UNIFORM SIZE less than 120K, create new tablespaces with the AUTOALLOCATE option and make it the default tablespace for IBM BPM database schema users.
You can use a single instance of Oracle for configuring IBM Business Process Manager. The Oracle instance must exist and be available for access. Consult the Oracle documentation to create an Oracle instance. If you use a single Oracle instance, make sure that you use different user IDs for the three different IBM Business Process Manager databases.
About this task
The default database names are BPMDB for the Process database, PDWDB for the Performance Data Warehouse database, and CMNDB for the Common database.
Creating users for the databases before creating profiles or the deployment environment
To create the users for the databases before you create the profiles or before you use the Deployment Environment wizard to create your deployment environment, you can use the createUser.sql template that is provided with your IBM Business Process Manager installation.
Procedure
Complete the following steps for each database user that you want to create:
Creating users for the databases after creating the profiles and the deployment environment
After you create the profiles, you can use the Deployment Environment wizard to create the deployment environment and generate the database scripts. The scripts are populated with the configuration values that you specified in the wizard. You can use some of these scripts to create the users for the databases if you chose to defer the creation of the database tables.
Before you begin
You must have already used the Profile Management Tool, the BPMConfig command, or the manageprofiles utility to create and augment the profiles. You must also have used the Deployment Environment wizard to configure the deployment environment.