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:

LOGBUFSZ = 2150
DBHEAP = AUTOMATIC (or greater than LOGBUFSZ)

LOGFILSIZ = 3000
LOGPRIMARY = 200
LOGSECOND = 40

PAGE_AGE_TRGT_MCR = 120

In addition, increase the number of pages (NPAGES) of the TWS_PLN_BUFFPOOL parameter to 182000 and the TWS_BUFFPOOL parameter to 50000 by 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 in the DB2 Knowledge Center.