IBM WEBSPHERE 6.1.X - Manual (Page 55)

5 0
W E B S P H E R E P O R T A L V 6 . 1 T U N I N G G U I D E
S E S S I O N D A T A B A S E T U N I N G
In addition to creating bufferpool and tablespace to support 32K page size for Session
database, we applied the following tunings to our dedicated session database server,
db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON
db2set DB2_RR_TO_RS=YES
db2set DB2_PARALLEL_IO=*
# disable session tablespace FILE SYSTEM CACHING
db2 alter tablespace sess_user32k NO FILE SYSTEM CACHING
db2 alter tablespace sess_temp32k NO FILE SYSTEM CACHING
db2 “update db cfg for <sess61> using locklist 5120”
db2 “update db cfg for <sess61> using maxlocks 80”
db2 “update db cfg for <sess61> using dbheap 4800”
db2 “update db cfg for <sess61> using num_iocleaners 20”
db2 “update db cfg for <sess61> using num_ioservers 20”
db2 “update db cfg for <sess61> using logbufsz 256”
db2 “update db cfg for <sess61> using logfilsiz 12288”
db2 “update db cfg for <sess61> using logprimary 40”
Vertical Cluster Tuning
We set the following in our vertical cluster environment,
•
See Dynacache Custom Properties in Cluster Tuning section to reduce the number
and size of Dynacache messages sent between JVMs. Additional DynaCache
properties for Vertical Cluster:
Name: com.ibm.ws.cache.CacheConfig.cacheEntryWindow Value: 10
Name: com.ibm.ws.cache.CacheConfig.cacheInvalidateEntryWindow Value: 10
Name:com.ibm.ws.cache.CacheConfig.propogateInvalidationNotSharedValue: false
Name: com.ibm.ws.cache.CacheConfig.useServerClassLoader Value: true
•
See Transport Buffer Size in Cluster Tuning section to increase transfer buffer size.
•
Increase Dynamic cache size to 3500.
How to set: Portal Server -> Container Services -> Dynamic Cache Service -> Cache size =
3500
•
See WMM Context Pooling on how to improve the performance of concurrent access
to an LDAP server.
•
Use the following command to increase DBHEAP for Release database.
db2 “update db cfg for <release> using dbheap 4800”