Before you can run the database scripts, you must create a database instance in which the tables will be created. This is standard for Oracle 10g, Oracle 9i, and SQL Server, but requires additional steps for Oracle 8.1.7, Sybase, and DB2.
For Oracle 8.1.7, you must either increase the default db_block_size from 8KB to 16KB or edit the database script to run successfully with the default db_block_size of 8KB.
In order to run the database installation scripts in Sybase, the server page size must be 16k. Set the server page size when you create the adaptive server on which you will run the Sybase scripts.
Using DB2 with Sun BPM requires a few extra setup steps. Review this section and ask your database administrator to review the installation script prior to running any scripts against your DB2 database instance. The database administrator needs to use the DBA or Sysadmin/DB2 user to create the following:
A database instance on the server.
A tablespace named BPM60DB.
A new user that has privileges to create objects in the database such as tables, indexes, sequences objects, and so on.
A 32k User temporary tablespace. A User temporary tablespace gives Sun BPM space for declared temporary tables. Use the DB2 administrative tool to create the tablespace. For detailed information about creating a DB2 User temporary tablespace, see the DB2 documentation. When you create the temporary tablespace, use the following parameter settings:
Pagesize: 32KB
Buffer Pool Size: 32KB
System-managed space
Average table size: 2GB to 20GB
Prefetch size: 32KB
Extent size: 32KB
Overhead: 10.5 ms
Transfer rate: 0.14 ms