Installation guide

TIBCO ActiveMatrix BPM Installation and Configuration
Setting up the Databases
|
37
Set OPEN CURSORS for the Database
Login to the TIBCO ActiveMatrix BPM database as the DBA and set the
maximum open cursors for the database to at least 400 using the following:
ALTER SYSTEM SET OPEN_CURSORS=400 SID=db_name
Using DB2
Create User To Grant Permissions on The Database
Identify an operating system user, or create a new operating system user if
needed who can be granted the ActiveMatrix BPM database user permissions.
When configuring the ActiveMatrix BPM server, the database user permissions
will be granted to an operating system user. You must have an operating system
user already created before installing the BPM runtime.
Create Database and Set Pagesize to 16384
You must create a database manually as DB2 installation does not create a default
database.
Create a database using either the DB2 Control Center, or the DB2 Command Line
Processor (CLP), and set the database pagesize to 16384.
Access to SYSTOOLSPACE
Ensure that the SYSTOOLSPACE tablespace has been created before proceeding
to configure the TIBCO ActiveMatrix BPM Server. This is necessary as some
scripts require access to the SYSTOOLSPACE tablespace to run successfully. See
the vendor’s documentation for details on how to create the tablespace manually.
Set the Statement Termination Character to ’/’
This setting is required only if you are manually creating or running the database
scripts.
Not all the scripts use the same termination character. For example, the
termination character for
WorkManagerCreate.sql is ’/’ and for
createdb-admin.sql and ProcessManagerCreate.sql scripts is ’;’.
Ensure that you examine the scripts and set the appropriate termination character
using the DB2 Control Center. Doing so ensures that the scripts can be used from
either the DB2 Control Center or the DB2 Command Line Processor.