WebSphere brand IBM WebSphere IP Multimedia Subsystem Connector, Version 6.2

Preparing DB2

Create a DB2® database before installing Diameter Enabler.

Before you begin
Before you begin:
  • DB2 should be installed and running
About this task
Some initial tuning values are provided; however, additional database tuning may be needed for optimal performance. Complete the following steps to create, configure, and connect to the database:
  1. Log in to the DB2 server with a user ID that has database administrator authority, such as db2inst1.
  2. Create a database named diameter by entering the following command from the command line:
    • db2 "CREATE DATABASE diameter USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM DFT_EXTENT_SZ 64"
  3. To verify the database was created, type the following command:
    • db2 "LIST DATABASE DIRECTORY"
    You should see a database entry for the diameter database.
  4. Configure the database manager.
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING MAXAGENTS 1000"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING SHEAPTHRES 20000"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING MON_HEAP_SZ 512"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING MAX_QUERYDEGREE 1"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_BUFPOOL off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_LOCK off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_SORT off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_STMT off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_TABLE off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_TIMESTAMP off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING DFT_MON_UOW off"
    • db2 "UPDATE DATABASE MANAGER CONFIGURATION USING HEALTH_MON off"
  5. Configure the database using the following series of commands:
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING DBHEAP 8192"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING CATALOGCACHE_SZ 512"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING LOGBUFSZ 2048"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING PCKCACHESZ 2048"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING APPLHEAPSZ 2048"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING APP_CTL_HEAP_SZ 4096"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING STAT_HEAP_SZ 8192"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING STMTHEAP 2048"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING SORTHEAP 512"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING LOCKLIST 10000"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING MAXLOCKS 45"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING LOGFILSIZ 5000"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING LOGPRIMARY 20"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING LOGSECOND 20"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING MAXAPPLS 500"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING AVG_APPLS 1"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING NUM_IOCLEANERS 3"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING NUM_IOSERVERS 3"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING SOFTMAX 100"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING DFT_DEGREE 1"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING DFT_PREFETCH_SZ 16"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING DFT_EXTENT_SZ 64"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING CHNGPGS_THRESH 60"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING AUTO_MAINT ON"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING AUTO_TBL_MAINT ON"
    • db2 "UPDATE DATABASE CONFIGURATION FOR diameter USING AUTO_RUNSTATS ON"
  6. Connect to the database and create all necessary tables using the following commands where dbuser represents the database user for the diameter database and dbpassword represents the password for the database user:
    • db2 "CONNECT TO diameter USER dbuser USING dbpassword"
    • db2 "create bufferpool BP_32K all nodes size 1000 pagesize 32K"
    • db2 "create regular tablespace SUBSCRIPTIONTS pagesize 32K managed by system using ('SUBSCRIPTIONTS') extentsize 256 prefetchsize 64 bufferpool BP_32K"
    • db2 "create regular tablespace ROSUBSCRIPTIONTS pagesize 32K managed by system using ('ROSUBSCRIPTIONTS') extentsize 256 prefetchsize 64 bufferpool BP_32K"
    • db2 "CREATE TABLE DIAMETERSHSUBSCRIPTION (SERVERNAME VARCHAR(250) NOT NULL, PUBLICIDENTITY VARCHAR(250) NOT NULL, DATAREFERENCE INTEGER NOT NULL, SERVICEINDICATION VARCHAR(250) NOT NULL, CALLBACKURL VARCHAR(250) NOT NULL, DATESUBSCRIBED TIMESTAMP, USERID VARCHAR(250), PASSWORD1 VARCHAR(250), SUBSCRIBEUSERDATA SMALLINT NOT NULL) IN SUBSCRIPTIONTS"
    • db2 "ALTER TABLE DIAMETERSHSUBSCRIPTION ADD CONSTRAINT PK_DIAMETERSHSUBS2 PRIMARY KEY (PUBLICIDENTITY, DATAREFERENCE, CALLBACKURL, SUBSCRIBEUSERDATA, SERVICEINDICATION, SERVERNAME)"
    • db2 "CREATE TABLE DIAMETERROSUBSCRIPTION (SESSIONID VARCHAR(250) NOT NULL, DESTINATIONREALM VARCHAR(250) NOT NULL, CALLBACKURI VARCHAR(250), DATESUBSCRIBED TIMESTAMP, DATEEXPIRESSECONDS BIGINT NOT NULL, USERID VARCHAR(250), PASSWORD1 VARCHAR(250)) IN ROSUBSCRIPTIONTS"
    • db2 "ALTER TABLE DIAMETERROSUBSCRIPTION ADD CONSTRAINT PK_DIAMETERROSUBS2 PRIMARY KEY (SESSIONID, DESTINATIONREALM)"
  7. Restart DB2 using the following commands:
    • db2stop force
    • db2start



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.