HCL Workload Automation, Version 9.4

Tuning plan replication

Tuning plan replication involves configuring specific settings to optimize the process of replicating plan data into the database. Plan replication ensures quick and reliable access to plan data stored in the database. Its main objective is to provide quick response times and increased overall performance. Sometimes, if this synchronization process is not configured appropriately for the size of your workload, you might notice some discrepancies in your environment, such as job status misalignment between the command line (conman) and the monitoring results obtained in the Dynamic Workload Console.

There are a few simple settings you can configure to optimize performance:

Configure the cache size

Add the following properties to the TWSConfig.properties file located in <TWS_INSTALLATION_PATH>/WAS/TWSProfile/properties/TWSConfig.properties:

#Custom property which configures the mirroring cache size for file
 dependencies (default value is 10000)
com.ibm.tws.planner.monitor.filecachesize=20000

#Customer property which configures the mirroring cache size
 (default value is 10000)
com.ibm.tws.planner.monitor.cachesize=20000

In addition, follow the steps to increase the heap size settings (initialHeapSize = 2048 and maximumHeapSize = 4096) of the application server on the master domain manager as documented in Increasing application server heap size.

Set the statement cache size

Set the WebSphere Application Server data source property Statement cache size to 400. You can make this change from the WebSphere Administrative Console by editing the WebSphere Application Server data source properties page. To access the administrative console page click: Resources > JDBC > JDBC providers > <JDBC_provider_name> > Data sources > <data_source_name> > WebSphere Application Server data source properties.

You can also make this change by directly editing the file, <TWS_INSTALLATION_PATH>/WAS/TWSProfile/config/cells/TWSNodeCell/nodes/TWSNode/servers/server1/resources.xml as follows:

<factories xmi:type="resources.jdbc:DataSource" xmi:id=
 "DataSource_1268732051783" 
name="DB2 Universal Type 4 JDBC Driver DataSource" jndiName="jdbc/twsdb" 
description="DB2 Universal Driver Datasource" providerType="DB2 Universal
 JDBC Driver Provider"
authMechanismPreference="BASIC_PASSWORD" authDataAlias="twsj2c"
 manageCachedHandles="false" 
logMissingTransactionContext="true" diagnoseConnectionUsage="false" 
relationalResourceAdapter="builtin_rra" statementCacheSize="400" 
datasourceHelperClassname=
 "com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper">

Set min and max connections for data source connection pools

Set the WebSphere Application Server data source connection pools min and max connections to 0 and 300, respectively. You can make this change from the WebSphere Administrative Console by editing the WebSphere Application Server data source properties page. To access the administrative console page click: Resources > JDBC > JDBC providers > <JDBC_provider_name> > Data sources > <data_source_name> > connection pools.

You can also make this change by directly editing the file, <TWS_INSTALLATION_PATH>/WAS/TWSProfile/config/cells/TWSNodeCell/nodes/TWSNode/servers/server1/resources.xml, as follows:

<connectionPool xmi:id="ConnectionPool_1268732051796" connectionTimeout="180" 
maxConnections="300"minConnections="0" reapTime="180" unusedTimeout="1800" 
agedTimeout="0" purgePolicy="EntirePool" numberOfSharedPoolPartitions="0" 
numberOfUnsharedPoolPartitions="0" numberOfFreePoolPartitions="0"
 freePoolDistributionTableSize="0" 
surgeThreshold="-1" surgeCreationInterval="0" testConnection="false"
 testConnectionInterval="15" 
stuckTimerTime="0" stuckTime="0" stuckThreshold="0"/>

Configure the maximum number of threads for DefaultWorkManager Work manager

Set the maximum number of threads equal to 50 for the Work manager named, DefaultWorkManager. You can make this change from the WebSphere Administrative Console by editing the WebSphere Application Server DefaultWorkManager Work manager page. To access the administrative console page click: Resources > Asynchronous beans > Work managers > DefaultWorkManager.

You can also make this change by directly editing the file, <TWS_INSTALLATION_PATH>/WAS/TWSProfile/config/cells/TWSNodeCell/nodes/TWSNode/servers/server1/resources-pme.xml, as follows:

<factories xmi:type="workmanager:WorkManagerInfo" xmi:id="WorkManagerInfo_Default" 
name="DefaultWorkManager" jndiName="wm/default"
 description="WebSphere Default WorkManager" 
category="Default" minThreads="1" maxThreads="50"
 threadPriority="5" numAlarmThreads="5" 
isGrowable="true" workReqQFullAction="0">

Install DB2 JDBC Driver Type 4

Replicating plan data in the database requires that DB2 JDBC Driver Type 4 is installed. DB2 JDBC Driver Type 2 is not supported.