Creating the Database Instance

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.

Creating the Database in Oracle 8.1.7

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.

Creating the Database in Sybase

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.

Creating the Database in DB2

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