Installation guide

TIBCO ActiveMatrix BPM Installation and Configuration
Create TIBCO ActiveMatrix Administrator Server Wizard Reference
|
117
Create TIBCO ActiveMatrix Administrator Server Wizard Reference
The Create TIBCO ActiveMatrix Administrator Server wizard takes 15 minutes or
more to complete depending on the configuration options.
Database Requirements
When running the wizard you specify a database for ActiveMatrix Administrator
server and several system services. If you are using an external database other
than HSQLDB, before running the wizard:
1. Package and install the database driver using the Configure Third-Party
Driver Wizard Reference.
2. Configure the external database:
• Oracle 11gR2
—The database user cannot have dba privileges, must have connect and
resource privileges, and be assigned to the default schema
• Microsoft SQL Server
— Run the command
alter database DB Name set read_committed_snapshot on
— The database user must be assigned the default database and have the
db_owner role
— Use the case insensitive collation setting
• IBM DB2
— Configure the database with a 32KB page size (instead of default 4KB)
3. Start the database server.
If you use an HSQLDB external database, concurrent user access to Administrator
server is not supported.