Migrate data across environments
Related topics
By generating SQL and load files from the Db2 log, you can move data across subsystems or platforms with less manual effort and risk.
Log Master produces SQL/LOAD outputs; load files can be processed by IBM LOAD, BMC LOADPLUS, or BMC AMI Load for Db2, and SQL can be applied via High‑speed Apply Engine.
The benefits include:
- Reducing migration effort by automating file generation and apply steps
- Improving performance by using mainframe utilities and High‑speed Apply Engine
- Preserving data integrity with audit‑backed change sets
Workflow for migrating data
| Task | Product | Role | Action | Reference | |
|---|---|---|---|---|---|
| 1 | BMC AMI Log Master for Db2 | Db2 DBA | Define a log scan for the migration window and select LOAD and/or SQL outputs. | LOGSCAN statement | |
| 2 | IBM LOAD, BMC LOADPLUS, or BMC AMI Load for Db2 | Db2 DBA | Process generated load files on the target subsystem. | Log Master architecture | |
| 3 | High-speed Apply Engine | Db2 DBA | Apply generated SQL on the target environment. | Log Master architecture | |
| 4 | BMC AMI Log Master for Db2 | Db2 DBA | Validate migration with audit reports or logical logs. | Log Master and tasks associated with auditing | |
5 | BMC AMI Log Master for Db2 | System programmer | Archive migration artifacts and update operational documentation. | Product features |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*