Creating the ActiveMatrix Administrator Database Using DB2
Create a DB2 database, configure it, and create an operating system user account to access it.
- Procedure
- Create a new, empty database that will be used to hold the ActiveMatrix Administrator database tables - for example,
amx.
Note: The ActiveMatrix BPM database tables (for each BPM system) and ActiveMatrix Administrator database tables must be stored in separate databases.
- Set the database page size to 32768.
- Make sure that the DB2 cur_commit database configuration parameter is set to ON.
- Create an operating system user account for the system to use to connect to the ActiveMatrix Administrator database - for example,
amx_db_user. (Alternatively, you can identify an existing operating system account to use.)
You will specify this user in the Username field of the Administrator Server Configuration: Database Details screen when you run the Create TIBCO ActiveMatrix BPM Server Wizard or Create TIBCO ActiveMatrix® Service Grid Administrator Server Wizard.
- Make sure that the database is available.