Improve apply performance with parallel processing
Related topics
Reduce apply duration by enabling multi‑threaded processing with multiple agents, tuned to workload distribution and available Db2 threads.
The benefits include:
- Faster runs through controlled parallelism (InitialAgents or MaxAgents)
- Use only the number of agents needed for the workload
- Prevent resource contention by matching thread availability on the target subsystem
Workflow for parallel performance
| Task | Product | Role | Action | Reference |
|---|---|---|---|---|
| 1 | BMC High‑speed Apply Engine | Db2 DBA | Assess workload distribution and suitability for parallelism | Agent parameters |
| 2 | BMC High‑speed Apply Engine | Db2 DBA | Configure InitialAgents and MaxAgents appropriately | |
| 3 | BMC High‑speed Apply Engine | Db2 DBA | Verify environment constraints (threads or connections) | Considerations for Db2 on mainframe targets |
| 4 | BMC High‑speed Apply Engine | Db2 DBA | Run the apply request and monitor throughput | Using |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*