IBM® DB2® database tablespaces

The DB2® database manages Database-managed Space (DMS) tablespaces. A tablespace is a storage location that contains the data sets where the DB2® tables are stored. Create tablespaces for the IBM® DB2® database before you install Marketing Operations.

You can specify the following types of tablespaces for the application data:

Online transaction Processing (OLTP) data tablespace. Use this tablespace to store the transactional data from the application.

OLTP index tablespace. Use this tablespace to store the indexes that are created to access the OLTP data tables.

Discussion Support System (DSS) data tablespace. Use this tablespace to store the OLTP data that is loaded into the DSS schema. The DSS schema organizes data from the OLTP to make it easier to generate reports of the application's activity.

DSS index tablespace. Use this tablespace to store the indexes that are created to access the DSS data tables.

Make note of the names of the tablespaces and the name of the server where you create the database. These tablespaces must exist before you install Marketing Operations. You must allocate at least 100 MB of space each for the OLTP data and DSS data tablespaces, and at least 50 MB each for the OLTP index and DSS index tablespaces.

If you do not want to maintain all four tablespaces, you can specify the same tablespace for multiple fields in the installation program. For example, you can supply the same tablespace for both the OLTP data and OLTP index tables, or a single tablespace for all four types of tables. Allocate sufficient space for all the tables that are written to the tablespace.

In addition, you must provide a temporary (TMP) tablespace of at least 10 MB.

The database user that you specify when you install Marketing Operations must be associated with the tablespaces, or have permissions to administer the tablespaces. The Leads application must be able to create schema in these tablespaces and write initial data to them.