IBM 6.1.X manual Vertical Cluster Tuning

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”

5 0

W E BS P HE R E P O R T AL V 6 . 1 T U N I N G G U I D E