IBM 6.1.X manual DB2

Page 46

Z / O S

The following section details the tunings that we made in our DB2 9 for z/OS backend database during our testing. To start here are a few general recommendations:

∙When the DB2 z/OS server is on a different server to the Portal/WCM installation, the use of the Universal Driver type 4 database driver is recommended

∙For data sharing groups, we additionally recommend enabling Sysplex Distributor to enhance high availability and exploit workload balancing.

In our environment we created nine databases to support WCM on Portal. The release, customization, community, likeminds, and feedback are required for Portal. For WCM, a minimum of two JCR databases are required for scalability and in our environment we used four.

T A B L E S P A C E S

Following DB2 best practices, it is recommended to create all tables into individual tablespaces. This will avoid device contention and provides better monitoring possibilities. Furthermore, most DB2 utilities such as REORG operate with tablespaces rather than tables.

B U F F E R P O O L S

It is also beneficial to create separate bufferpools for use by Portal to avoid contention. When creating your database, ensure that each tablespace/indexspace has a specific bufferpool specified by the BUFFERPOOL/INDEXBP attributes rather than using the DB2 system defaults. It is recommended that a set of bufferpools separate from the Portal databases gets created for the JCR databases. The following table shows the settings for our configuration.

Table 23: DB2 z/OS Bufferpool Settings

Bufferpool settings

Database Domain

wkplc_comp.properties

DB2

BP

BP

Pagesize

BP

Size

 

 

(KB)

 

 

 

 

RELEASE

<domain>.Db4KBufferPoolName

BP2

4

40000

CUSTOMIZATION

<domain>.DbIndex4KBufferPoolName

BP3

4

5000

COMMUNITY

 

 

 

 

LIKEMINDS

<domain>.Db32KBufferPoolName

BP32K

32

1000

FEEDBACK

 

 

 

 

 

 

jcr.Db4KBufferPoolName

BP4

4

80000

JCR

 

 

 

 

jcr.DbIndex4KBufferPoolName

BP5

4

40000

 

 

 

 

 

 

jcr.Db32KBufferPoolName

BP32K1

32

20000

 

 

 

 

 

Note: When running Portal, DB2 objects like tablespaces will be created dynamically. It is important to keep your default bufferpools well defined to avoid causing contention due to an overloaded bufferpool. This is especially true for LOB and 4-KB tablespaces as they default

4 1

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

Page 45 Page 47
Image 46
Page 45 Page 47
Contents IBM WebSphere Portal IBM WebSphere Portal software family Your world. Your wayContents Web Server Tuning Portlet Caching General Information Figures About this Document Performance Tuning Overview Environment Considerations Base Portal Tuning Application Server Tuning How to get to Admin Console2003 ParameterLinux Solaris Windows Initial 1792 2048POWER5 New Area Size Xmn320m Xmn256m Xmn768m Xmn1024m Parameter Value Additional InformationSession Minutes TimeoutWeb Container Thread pool Size Name Value PropagationHow to Set Context Pool Setting Default ValueWebSphere Portal Services Default Value Definition UsedG I S T R Y S E R V I C E Default Value Value Used Cache NameDatabase Tuning Database Database name Datasource name2 O N a I X S E T U P Db2 reorgchk update statistics on table all Db2 reorgchk current statistics on table all reorgchk.txt A C L E D a T a B a S E S E R V E R T U N I N G AIXTHREADSCOPE=S Parameter ValueExecute Directory Server Tuning Db2 update db config for idsldap using dbheapWeb Server Tuning Linux Windows Additional InformationMinSpareThreads MaxSpareThreads Operating System Tuning N U T W O R K T U N I N G How-to-Setndd -set /dev/tcpPARAMETER Value L a R I S C O N T a I N E R Required Fixes MaxthreadtasksParameter Setting Used WEB 2.0 Theme TuningNavigator Service Properties JVM Initial and Maximum Heap SizeParameter Setting Used Additional Information Caching Proxy TuningInternet Explorer Support of Vary Header # uncommented these to enable statics to be cached # set cache-control public for various static contentPortlet Caching ExpiresActive OnDB2 Database Tuning Many Pages TuningRelease DB Parameter Cache Manager Service WEB Content Management Tuning WebSphere Portal Service Properties Cache NameWCM Object Cache WCM Configuration Service JCR Text SearchDB2 Tuning Authoring Environment DB2 BP4 Composite Applications Tuning Cache Manager Service PropertiesComposite Applications Best Practices BS P HE R E P O R T AL V 6 T U N I N G G U I D E Cluster Tuning Value trueHow-To Set ThreadLimit ServerLimit Session Persistence To Database Tuning Parameter Setting Additional DetailsVertical Cluster Tuning IBM Tivoli Directory Server Tuning Other Performance Tuning Options Improving Portal Startup PerformanceManaging the Retrieval of User Attributes BS P HE R E P O R T AL V 6 T U N I N G G U I D E Use of Dynamic Content Features Real-World Network Considerations BrowserMatch Mozilla/4 gzip-only-text/html Websphere Portal Caches General InformationBS P HE R E P O R T AL V 6 T U N I N G G U I D E BS P HE R E P O R T AL V 6 T U N I N G G U I D E Cache Usage Patterns Pattern invalidation checkingCache Instances Portal Access Control Cache Hierarchy Com.ibm.wps.ac.PermissionCollectionCacheCom.ibm.wps.ac.OwnedResourcesCache Com.ibm.wps.ac.AccessControlUserContextCacheCom.ibm.wps.ac.ProtectedResourceCache Com.ibm.wps.ac.RolesCacheCom.ibm.wps.ac.ExternalOIDCache Com.ibm.wps.ac.ApplicationRoleOIDCache Com.ibm.wps.ac.ChildResourcesCacheCom.ibm.wps.ac.ApplicationRoleDescriptorCache Com.ibm.wps.ac.ApplicationRoleChildrenCache Com.ibm.wps.ac.ApplicationRolesForPrincipalCacheCom.ibm.wps.ac.ContainedRolesCache Com.ibm.wps.puma.DNOIDCache / com.ibm.wps.puma.OIDDNCacheCom.ibm.wps.datastore.PortalIdCache.explicitLpidPerVP Com.ibm.wps.datastore.PortalIdCache.vpPerLpid.cacheCom.ibm.wps.datastore.pageinstance.OIDCache Com.ibm.wps.datastore.pageinstance.DerivationCache Com.ibm.wps.datastore.pageinstance.DynamicNodeCacheCom.ibm.wps.model.content.impl.ResourceCache Com.ibm.wps.model.factory.SimpleCacheKeyCom.ibm.wsp.mode.content.impl.TopologyCache Com.ibm.wps.model.factory.ContentModelCache.liveCom.ibm.wps.model.factory.ContentModelCache.isolated Com.ibm.wps.model.factory.URLMappingCache.liveCom.ibm.wps.model.factory.MultiModelCache.live Com.ibm.wps.model.content.impl.DynamicLoadCacheCom.ibm.wps.model.factory.URLMappingCache.isolated Com.ibm.wps.model.factory.MultiModelCache.isolatedWps.mappingurl.ContextsCache Com.ibm.wps.services.vpmapping.VirtualPortalIDToRealmCacheCom.ibm.wps.model.impl.RuntimeClientMap.userAgent2client Wps.mappingurl.LookupCacheCom.ibm.wps.services.vpmapping.URLToVirtualPortalIDCache Com.ibm.wps.services.vpmapping.VirtualPortalIDToURLCacheWsrp.cache.portletdescription Wsrp.cache.producer.user Wsrp.cache.servicedescriptionWsrp.cache.portlet.instance Wsrp.cache.portlet.windowProcessintegration.PendingTasksCache Wsrp.producer.portletpool.popsWsrp.producer.portletpool.ccps Wp.te.transformationAssociationCacheCom.ibm.wps.policy.services.PolicyCacheManager Com.ibm.wps.policy.services.UserPolicyNodeCacheManagerCom.lotus.cs.services.UserEnvironment Com.lotus.cs.services.directory.wmm.WMMDirectoryServiceCom.lotus.cs.services.domino.DominoService Com.ibm.wps.pe.portletentity Wp.xml.configitemsPortletMenuCache RegistryService Com.ibm.workplace.searchmenu.helper.SearchMenuCacheHelperExample Scenarios BS P HE R E P O R T AL V 6 T U N I N G G U I D E R T a L S W I T H L O N G S E S S I O N T I M E O U T S BS P HE R E P O R T AL V 6 T U N I N G G U I D E Services/cache/iwk/objectsummary WCM Summary WEB Content Management CachesServices/cache/iwk/strategy WCM Item caching WCM Cache InstancesServices/cache/iwk/processing Advanced and Resour ces Services/cache/iwk/moduleServices/cache/iwk/session Session Services/cache/iwk/abspath Absolute path Services/cache/iwk/menu MenuServices/cache/iwk/nav Navigator Services/cache/iwk/missed Missed ItemsServices/cache/iwk/draftSummary Draft Summary Services/cache/iwk/libparent Library ParentUser cache Appendix A. References Mark Alkins, Manager Lee Backstrom, Document CoordinatorBS P HE R E P O R T AL V 6 T U N I N G G U I D E
Top Page Image Contents