Creating users for Oracle databases
- If the property is set to false, database tables are automatically created when you run the BPMConfig command to create the stand-alone profile. Therefore, the database users must exist before you run the BPMConfig command.
- If the property is set to true, database table creation is deferred when you run the BPMConfig command to create the stand-alone profile. Therefore, you can create the database users either before or after running the command. You might find it useful to create the database users after running the BPMConfig command because you can use the set of populated scripts, which the command generates, to create the database users and database tables at a time that you choose.
Before you begin
Before you create any users for Oracle databases, see the topic Configuring XA transactions for Oracle in a network environment on Linux.
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.
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.
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 the profiles and configuring the deployment environment
To generate the database scripts that can be used by the BPMConfig command to create the users and configure your databases, you can run BPMConfig with the -create -sqlfiles parameters, and additionally include the -outputDir parameter to specify a location for the generated scripts. When you run the BPMConfig command with these parameters, it generates the database scripts without configuring your environment.
Before you begin
- Information about the database configuration that you are designing.
This might be a document that describes the general purpose of the
database configuration supplied by the database administrator or solution
architect. Alternatively, it might be a description of required parameters
and properties. This information must include:
- The location of the databases
- The user ID and password for authenticating to the database
- Information about how IBM Business Process Manager and its components have been installed, the database software used, and the properties required by that type of database.
- An understanding of the profiles that you plan to create, specifically, the functional relationship between the profile types and the databases.
- Information about the topology pattern to be implemented, and an understanding of how the database design fits into the pattern that you plan to use.
Procedure
Creating users for the databases after creating the profiles and configuring the deployment environment
If you want to use the BPMConfig command to create the stand-alone profile separately from the database tables, you can first run the command with the -create -de parameters to create the profile. Afterwards, you can run the command again with the -create -sqlfiles parameters to generate the database scripts that can be used to create the users for the databases and the database tables. The generated database scripts are populated with the values from the properties file that you specified.
Before you begin
You must have already run the BPMConfig command to create the stand-alone profile.