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 using locklist 5120”
db2 “update db cfg for using maxlocks 80”
db2 “update db cfg for using dbheap 4800”
db2 “update db cfg for using num_iocleaners 20”
db2 “update db cfg for using num_ioservers 20”
db2 “update db cfg for using logbufsz 256”
db2 “update db cfg for using logfilsiz 12288”
db2 “update db cfg for 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 using dbheap 4800”