|Bookshelf Home | Contents | Index | PDF|
The size of EIM batches can significantly affect throughput. This occurs as a result of the number of commits that EIM must execute. While each commit is CPU-intensive, commits release page locks, thereby releasing memory and avoiding lock escalation and time-outs.
While every installation is different, you should perform initial testing with large batch sizes (except DELETE EXACT, which normally runs better with smaller batch sizes). You might want to use this as a starting point for your own processes and modify batch size based on results.
NOTE: Processes that populate child tables might violate the maximum number of locks allowed by the system or cause contention for resources in those child tables. To avoid this, reduce the batch size of these processes.
|Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390|