HCL Workload Automation, Version 9.4

Optimizing the replication of the Symphony file in the database

Tuning DB2 database configuration parameters to improve performance when the Symphony file is replicated in the database.

In a HCL Workload Automation environment where more than 200,000 jobs are scheduled to be submitted, there are several DB2 database configuration parameters than can be tuned to improve performance when the Symphony plan is replicated in the HCL Workload Automation database.

The following are the suggested values for a plan with more than 200,000 jobs:Start of change
LOGBUFSZ = 2150
DBHEAP = AUTOMATIC (or greater than LOGBUFSZ)

LOGFILSIZ = 3000
LOGPRIMARY = 200
LOGSECOND = 40

PAGE_AGE_TRGT_MCR = 120
End of change

In addition, increase the number of pages (NPAGES) of the TWS_PLN_BUFFPOOL parameter to 182000 using the ALTER BUFFERPOOL command.

Before changing any of these values, refer to the information about tuning a DB2 database in the relevant product documentation at IBM DB2 Database for Linux, UNIX, and Windows Information Center.