Creating an IBM DB2 Database

If you are using an IBM DB2 database, you must make some changes to the database through the IBM DB2 Control Center or an equivalent tool.

The database, buffer pool and table space names defined below are suggested values. You can substitute names that follow your naming standards if necessary.

Procedure

  1. Create a DB2 database.
    The only required value is the database name. For example, you can assign a database name such as MFTISDB.
  2. Create a DB2 buffer pool with a page size of 32KB.
    Give this buffer pool a name. For example, MFTISBP.
  3. Create a DB2 table space.
    Give this table space a name. For example, MFTISTS. This table spaces should be defined as type Regular and use the buffer pool defined in Step 2. Create a DB2 container with a unique name, for example, C:\DB2Container\MFTISTS. This directory will be automatically created by DB2 when the table space definition is completed.
  4. Create a second DB2 table space.
    Give this table space a name. For example, MFTISCTTS. This table space should be defined as type System Temporary and use the buffer pool defined in Step 2. Create a DB2 container with a unique name, for example, C:\DB2Container\MFTISTTS. This directory will be automatically created by DB2 when the table space definition is completed.