Migrate data between databases
Related topics
Move data between Db2 targets using High‑speed Apply Engine with SQL or logical log inputs, tunable parallelism, and conflict handling.
The benefits include:
- Flexible inputs (SQL/logical log) for migration scenarios
- Higher throughput with multi‑threaded agents (InitialAgents or MaxAgents)
- Predictable behavior via conflict resolution rules and deferred output files
Workflow for data migration
| Task | Product | Role | Action | Reference |
|---|---|---|---|---|
| 1 | BMC AMI Log Master for Db2 or source system | Db2 DBA or Data engineer | Prepare migration SQL or logical log input | Input sources for apply requests |
| 2 | BMC High‑speed Apply Engine | Db2 DBA | Define configuration, including performance and conflict rules | |
| 3 | BMC High‑speed Apply Engine | Db2 DBA | Tune Agent parameters for parallel processing | Agent parameters |
| 4 | BMC High‑speed Apply Engine | Db2 DBA | Run the apply request and verify migrated data | Using |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*