You must create and configure a database to store the IBM®
SPSS® Modeler Advantage Enterprise Marketing Management
Edition system tables.
About this task
Note: 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 Enterprise Marketing Management
Edition
and HCL
Campaign integration.
Procedure
-
Under user WPADMIN schema WPADMIN, create a
database named SPSSMAME to store the IBM
SPSS Modeler Advantage Enterprise Marketing Management
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;