Designed for organizations that run online transaction processing (OLTP) applications on distributed systems, IBM DB2 pureScale offers clustering technology that helps deliver high availability and exceptional scalability transparent to applications. DB2 pureScale is based on technology from IBM DB2 for z/OS and is available as an option on IBM DB2 9.7 Enterprise Server Edition. (reference for more information:
http://www.ibm.com/software/data/db2/linux-unix-windows/editions-features-purescale.html)
Beginning with WebSphere Portal and IBM Web Content Manager V7.0.0.1 Combined cumulative fix 007, both WebSphere Portal and IBM Web Content Manager have been tested and are supported with DB2 pureScale V9.8.0.3 or later. The steps to configure WebSphere Portal with DB2 pureScale are similar to those already documented in the information center (
link), but with some differences as noted below.
Here is the additional information and steps that are needed to configure WebSphere Portal with DB2 pureScale:
1. You must use WebSphere Portal V7.0.0.1 with Combined CF007 or higher installed.
2. You must use DB2 pureScale version: 9.8.0.3 or later
3. You must use DB2 JDBC Driver version 9.7 FP3 JCC 4.9 or later for WLB support.
4. Tablespace Creation differences
For regular DB2 configuration, we do
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
For DB2 pureScale, only automatic storage is supported, so the above statements need to be replaced with:
CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32 K BUFFERPOOL ICMLSMAINBP32
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4 K BUFFERPOOL ICMLSVOLATILEBP4
db2 "CREATE USER TEMPORARY TABLESPACE ICMLSUSRTSPACE4 PAGESIZE 4 K BUFFERPOOL ICMLSVOLATILEBP4
5. Adjust the setting in the WebSphere Deployment Manager (DMgr) console on each jdbc datasource for enabling pureScale load balance feature:
Log into Deployment Manager administrative console, click Resources -> JDBC -> Data Sources, click each of the data sources for DB2 pureScale, -> custom properties -> add -> enableSysplexWLB (value: true)