Skip to main contentCúram Performance & Tuning Guide

Tuning batch processes

Use the following guidelines to tune the performance of batch processes.

Batch chunk size

For streamed batch jobs, to offer good balance between scalability and error management, tune the chunk size for a batch job so that it takes between one to two minutes to process one chunk.

For more information about Cúram batch streaming performance, see Tuning batch streaming performance in the Tuning Batch Streaming Performance Guide.

Db2®

When Db2 is used, set the following tables to be volatile:

BATCHPROCESS
BATCHPROCESSCHUNK

Oracle

When Oracle is used, enable Oracle connection and statement caching in the Bootstrap.properties file:

curam.db.oracle.connectioncache.enabled=true
curam.db.oracle.connectioncache.minlimit=3
curam.db.oracle.connectioncache.maxlimit=3
curam.db.oracle.connectioncache.initiallimit=3
curam.db.oracle.cachesize=1000