Configuring a DB2 database

You must create and configure a database to store the IBM® SPSS® Modeler Advantage Marketing Edition system tables.

In the following steps, the DB2 user and schema names WPADMIN are examples. It is possible to install everything under the DB2ADMIN default administrator login for DB2. Install with separate schemas and users for each database to simplify administration and the granting of rights. DB2 will not allow the user who is connected to the database grant themselves access rights.

To configure the DB2 database for the IBM® SPSS® Modeler Advantage Marketing Edition and IBM® Campaign integration.

Under user WPADMIN schema WPADMIN, create a database named SPSSMAME to store the IBM® SPSS® Modeler Advantage Marketing Edition System Tables.

Configure the database properly as indicated in the following sample SQL statements:

/* SPSS MAME Database Creation Script */ 
CREATE DATABASE SPSSMAME ON DB2 USING CODESET UTF-8 TERRITORY  
US COLLATE USING SYSTEM;

CONNECT TO SPSSMAME;

CREATE BUFFERPOOL CDS8K IMMEDIATE SIZE 250 AUTOMATIC PAGESIZE 8 K;

CREATE REGULAR TABLESPACE CDS8K PAGESIZE 8 K MANAGED BY AUTOMATIC STORAGE 
EXTENTSIZE 8 OVERHEAD 10.5 PREFETCHSIZE 8 TRANSFERRATE 0.14 BUFFERPOOL CDS8K 
DROPPED TABLE RECOVERY ON;

COMMENT ON TABLESPACE CDS8K IS '';

CREATE BUFFERPOOL CDSTEMP IMMEDIATE SIZE 250 PAGESIZE 32 K;

CREATE SYSTEM TEMPORARY TABLESPACE CDSTEMP PAGESIZE 32 K MANAGED BY AUTOMATIC 
STORAGE EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 
BUFFERPOOL "CDSTEMP";

COMMENT ON TABLESPACE CDSTEMP IS '';

CONNECT RESET;