Filter
Top Products
50
WEBSPHERE PORTAL V6.1 TUNING GUIDE
SESSI ON D ATABAS E TUNING
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”