Apply Db2 changes at high volume
Related topics
By applying database changes with BMC High‑speed Apply Engine, you accelerate data change execution while maintaining control, reliability, and recoverability.
The benefits include:
- Reducing the time required to apply large volumes of database changes
- Improving reliability through restart and recovery processing
- Controlling execution behavior with flexible configuration options
- Handling conflicts predictably during apply processing
Workflow for applying high‑volume Db2 changes
| Task | Product | Role | Action | Reference |
|---|---|---|---|---|
| 1 | BMC AMI Log Master for Db2 | Db2 DBA | Generate SQL or logical log input that contains the database changes to apply | Getting started with BMC AMI Log Master for Db2 |
| 2 | BMC High‑speed Apply Engine | Db2 DBA | Define configuration files to control apply processing, performance, and error handling | Defining configurations |
| 3 | BMC High‑speed Apply Engine | Db2 DBA | Create an apply request that references the input and configuration files | Creating and running apply requests |
| 4 | BMC High‑speed Apply Engine | Db2 DBA, system programmer | Run the apply request as a batch job to apply the changes to the target database | Using |
| 5 | BMC High‑speed Apply Engine | Db2 DBA | (Optional) Restart the apply request from the point of failure if errors occur |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*