Websphere Portal and DB2 tuning

03 January,2012 by Jack Vamvas

Tuning DB2 is critical  if  Websphere Portal is the main client. In larger Websphere Portal architectures , where load balancing is standard , this become obvious.

Follow these general guidelines  to achieve faster response times on Portal requests. These guidelines don’t replace baselining\monitoring  and on going analysis

1) Reorg\stats update regularly

2) You should ensure that the database parameter MaxAppls is greater than the total number of connections for both the datasource and the session manager for each WebSphere Portal application server instance. If MaxAppls is not large enough, you will see exceptions in your connection pools.

3) You should use System Managed Storage (SMS) for temporary table spaces to benefit complex SQL which require temporary tables to compute their result sets. This saves time in buffer writes and improves disk utilization.

4) BufferPool sizing – aim for 95% Buffer reads

5) Increase BUFFERPOOL sizes of IBMDEFAULTBP and ICMLSMAINBP32 of JCRDB database.

 

CONNECT TO JCRDB;
ALTER BUFFERPOOL IBMDEFAULTBP IMMEDIATE size 26000;
ALTER BUFFERPOOL ICMLSMAINBP32 IMMEDIATE size 24000;
TERMINATE;
db2 CONNECT TO CUSTDB;
db2 update db cfg using MAXAPPLS 500;
db2 TERMINATE;
db2 connect to WMMDB;
db2 update db cfg using MAXAPPLS 500;
db2 TERMINATE;
db2 connect to WPSDB;
db2 update db cfg using MAXAPPLS 500;
db2 TERMINATE;
db2 connect to COMMDB;
db2 update db cfg using MAXAPPLS 500;
db2 TERMINATE;
db2 connect to JCRDB;
db2 update db cfg using MAXAPPLS 500;
db2 TERMINATE;

 Related Posts

DB2 MAXFILOP

Performance Tuning series – Performance Stack

Author: Jack Vamvas(http://www.dba-db2.com)
Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Websphere Portal and DB2 tuning

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright