Creating an IBM DB2 Database

If you use an IBM DB2 database, you must perform the following operations.

Note: The database, buffer pool, and table space names defined in the following example are suggested values. You can substitute names that follow your naming standards if necessary. These changes should be made through the IBM DB2 Control Center or an equivalent tool.

Procedure

  1. Create a DB2 database.
    The only required value is the database name. For example, you can assign a database name, such as MFTCCDB.
  2. Create a DB2 buffer pool with a page size of 32K.
    Assign a buffer pool name, such as MFTCCBP. This buffer pool will be needed in later steps.
  3. Create a DB2 table space.
    Assign this table space a name, such as MFTCCTS. This table space should be defined as type Regular and use the buffer pool defined in Step 2. Create a DB2 container with a unique name, such as C:\DB2Container\CFCCCTS. This directory will be automatically created by DB2 when the table space definition is completed.
  4. Create a second DB2 table space.
    Assign this table space a name, such as MFTCCTTS. 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, such as C:\DB2Container\CFCCCTTS. This directory will be automatically created by DB2 when the table space definition is completed.