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