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:
BATCHPROCESSBATCHPROCESSCHUNK
Oracle
When Oracle is used, enable Oracle connection and statement caching in the Bootstrap.properties
file:
curam.db.oracle.connectioncache.enabled=truecuram.db.oracle.connectioncache.minlimit=3curam.db.oracle.connectioncache.maxlimit=3curam.db.oracle.connectioncache.initiallimit=3curam.db.oracle.cachesize=1000