Siva R Vaka: DB2 v9.7 Augmenting/Configuring database instance specific to the WebSphere Portal

Following two ways to create the database instance specific to WebSphere Portal

You can create the database instance for websphere portal in following ways

By executing the IBM provided DB2 commands directly
Using "ConfigEngine" task

Using the DB2 Commands

NOTE: Cluster Guide explains how to create the separate DB instance for the each schema (Release, jcr, feedback, customization, likeminds and community) but as I'm not using it for heavy use I have created all schemas in single database instance (WP7DB)

Required commands are specified in the Appendix section of the Cluster Guide page@64, included same here for convenience.

From the command prompt

Type "db2cmd" brings up the DB2 command line processing (DB2CLP) and then type db2

db2 "CREATE DATABASE WPS7DB AUTOMATIC STORAGE YES ON 'C:\' using codeset UTF-8 territory us PAGESIZE 8192"

db2 "UPDATE DB CFG FOR WPS7DB USING AUTO_MAINT OFF"

db2 "UPDATE DB CFG FOR WPS7DB USING applheapsz 4096"

db2 "UPDATE DB CFG FOR WPS7DB USING app_ctl_heap_sz 1024"

db2 "UPDATE DB CFG FOR WPS7DB USING stmtheap 32768"

db2 "UPDATE DB CFG FOR WPS7DB USING dbheap 2400"

db2 "UPDATE DB CFG FOR WPS7DB USING locklist 1000"

db2 "UPDATE DB CFG FOR WPS7DB USING logfilsiz 4000"

db2 "UPDATE DB CFG FOR WPS7DB USING logprimary 12"

db2 "UPDATE DB CFG FOR WPS7DB USING logsecond 20"

db2 "UPDATE DB CFG FOR WPS7DB USING logbufsz 32"

db2 "UPDATE DB CFG FOR WPS7DB USING avg_appls 5"

db2 "UPDATE DB CFG FOR WPS7DB USING locktimeout 30"

db2 "UPDATE DB CFG FOR WPS7DB using AUTO_MAINT off"

IMPORTANT:

Create the following tablespaces in your JCR database. If you are using one database for all domains, then create these tablespaces in that database
Failure to create these tablespaces will cause the database-transfer to fail
These tablespace names cannot be altered. You must use the names listed below.

db2 "CONNECT TO WPS7DB USER db2admin USING db2admin"

db2 "CREATE BUFFERPOOL ICMLSFREQBP4 SIZE 1000 PAGESIZE 4 K"

db2 "CREATE BUFFERPOOL ICMLSVOLATILEBP4 SIZE 16000 PAGESIZE 4 K"

db2 "CREATE BUFFERPOOL ICMLSMAINBP32 SIZE 16000 PAGESIZE 32 K"

db2 "CREATE BUFFERPOOL CMBMAIN4 SIZE 1000 PAGESIZE 4 K"

db2 "CREATE REGULAR TABLESPACE ICMLFQ32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLFQ32') BUFFERPOOL ICMLSMAINBP32"

db2 "CREATE REGULAR TABLESPACE ICMLNF32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLNF32') BUFFERPOOL ICMLSMAINBP32"

db2 "CREATE REGULAR TABLESPACE ICMVFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMVFQ04') BUFFERPOOL ICMLSVOLATILEBP4"

db2 "CREATE REGULAR TABLESPACE ICMSFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMSFQ04') BUFFERPOOL ICMLSFREQBP4"

db2 "CREATE REGULAR TABLESPACE CMBINV04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('CMBINV04') BUFFERPOOL CMBMAIN4"

db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('icmlssystspace32') BUFFERPOOL ICMLSMAINBP32"

db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlssystspace4') BUFFERPOOL ICMLSVOLATILEBP4"

db2 "CREATE USER TEMPORARY TABLESPACE ICMLSUSRTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlsusrtspace4') BUFFERPOOL ICMLSVOLATILEBP4"

db2 "UPDATE DB CFG FOR WPS7DB USING DFT_QUERYOPT 2"

db2 "UPDATE DB CFG FOR WPS7DB USING PCKCACHESZ 16384"

db2 "DISCONNECT WPS7DB "

db2 "TERMINATE"

Executed all above

db2 => CREATE DATABASE WPS7DB AUTOMATIC STORAGE YES ON 'C:\' using codeset UTF-8 territory us PAGESIZE 8192

DB20000I The CREATE DATABASE command completed successfully.

db2 => UPDATE DB CFG FOR WPS7DB USING AUTO_MAINT OFF