To add a process execution engine to the host engine:
In the left pane of the Process Administrator, select Engines.
On the Engines page, click Add.
On the Engines | Choose Engine Type page, enter the Engine Name and Engine Database Type. Ignore the Engine Type option - it cannot be configured.
Click Next.
On the Engines | Choose Engine Type | Edit Business End Point Engine 'engine name' Database Configuration page, enter the Properties for the process execution engine database.
The SQL Server (Plumtree) engine database properties are:
Host - The name of the host computer or server on which Microsoft SQL resides and on which the database will be created.
Port - The database will use this port on the host.
Database - The name of the engine database that will be created.
User - A user name that will be created when the database is created.
Note: Once this user name has been defined in the Process Administrator, the name cannot be changed. If a new administrative user name is necessary, create a new process execution engine that uses the new user name.
Password - A password that will be created for the user when the database is created.
The Oracle (Plumtree) engine database properties are:
Host - The name of the host computer or server on which Oracle SQL resides and on which the database will be created.
Port - The database will use this port on the host.
SID - System identification for the database; also used to connect to the database. Sometimes called Oracle ID.
User - A user name that will be created when the database is created.
Note: Once this user name has been defined in the Process Administrator, the name cannot be changed. If a new administrative user name is necessary, create a new process execution engine that uses the new user name.
Password - A password that will be created for the user when the database is created.
Schema - This is an optional property. If the name of a schema is entered, the configuration and introspection will only work on tables of that schema. If a schema name is not entered, the schema could be changed at runtime. For example, if a table named devel.invoice is referenced in a development environment and in production a different schema name is used, production references to devel.invoice would work only if the schema name was not entered in this field.
Database String - If this option is selected, the database connection information can be entered in the form of a URL. Complete the host, port, SID, user, and schema (schema is optional) fields. Then select the database string checkbox. In the database string field, enter the URL in the format jdbc:datadirect://host name:port number;SID. Enter and confirm a password for the user that will be created when the database is created.
The Oracle (Plumtree) engine Advanced properties are optional:
Tablespace - Some database administrators divide databases into tablespaces to control and maintain table sizes. Enter the appropriate tablespace name here. Leave the field blank if there are no tablespaces and a default tablespace will be created. When the user name is created, the user creation statement references the tablespace.
Temporary Tablespace - The name of the temporary tablespace used by the process execution engine's database to perform temporary indexing for some access: TEMP of type TEMPORARY.
Profile - A profile is a set of limits on database resources. If you assign the profile to the user being created, that user cannot exceed the established limits in the profile. This allows the administrator to limit the actions of a particular Oracle user. The Oracle administrator may have different profiles set for different groups of users so that there is control over what each group is authorized to use and over which resources from the database a particular group will have.
On the Engines | Choose Engine Type | Edit Business End Point Engine 'engine name' Database Configuration page, configure the following Runtime options for the process execution engine or accept the defaults:
Maximum Pool Size - Enter the maximum number of connections that the pool can allocate. The pool will never create more connections than this limit imposes. The default is 10.
Connection Idle Time (Mins) - Enter the amount of time the database connection can remain idle before the connection will be dropped. The default is 5 minutes.
Maximum Opened Cursors - Enter the maximum number of opened cursors allowed on the database. The default is 50. This value is related to the maximum pool size. The number of cursors is divided in between the number of maximum pool size and each connection will manage that number of cursors. For example, if you have 500 maximum opened cursors and the maximum pool size is 50, each connection can have a maximum of 10 opened cursors.
Click Next.
On the Engines | Choose Engine Type | Edit Business End Point Engine 'engine name' Database Configuration | Add Engine page, on the Basic Configuration tab:
Verify the Name of the process execution engine.
Ignore the Type - it cannot be configured.
Verify the Host location for the process execution engine.
Enter the Home Directory location or accept the default.
Enter the Log Directory location or accept the default.
Click Save.
In the left pane of Process Administrator, select Engines.
On the Engines page, Stop the process execution engine so that the process execution engine database can be created.
Click the engine Name.
On the Engines | Edit Engine enginename page, on the Basic Configuration tab, click Manage Database.
On the Engines | Edit Engine enginename | Manage Database page, under Database Creation, select Create Database and Create Data Structure.
Enter a User Name and User Password with administrative write privileges for the host engine.
Click OK.
At the top of the Engines | Edit Engine enginename page, the Message(s) section should contain the following confirmation messages:
The database has been created.
The data structure has been created.
To verify the creation of the database and data structure, check the host engine to see if the new database is there.
Note: Before starting the process execution engine, make sure the location port number is unique. Two process execution engines on the same host process execution engine cannot be running on the same port. To view and change the location port, on the Engines | Edit Engine enginename page, on the Basic Configuration tab, click Locations.
Related Topics: