Improving the performance of data sharing applications

Several actions can help your resource-intensive applications run at their best in the Parallel Sysplex®.

Many of the things you currently do for a single Db2 subsystem to improve response time or reduce processor consumption also hold true in the Parallel Sysplex. However, if the processing speed of the CPU is slower than that on which you are currently running, be sure to plan carefully for applications or Db2 utility processes where processor resource consumption represents the significant part of the elapsed time. Some examples are some batch applications, complex queries, and many Db2 utilities.

General recommendation

Take advantage of data partitioning and design for parallel processing whenever possible. Db2 can use parallel processing effectively only when the data is partitioned.