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:
Log in to the DB2 server with a user ID
that has database administrator authority, such as db2inst1.
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"
To verify the database was created, type the following
command:
db2 "LIST DATABASE DIRECTORY"
You should see a database entry for the diameter database.
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"
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"
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"