Product overview
Related topics
You can use High-speed Apply Engine to rapidly apply large volumes of change data to Db2 targets with flexible, configurable control over apply processing. It is delivered as a component with several BMC products (including BMC AMI Log Master for Db2), but you can also use it independently to run SQL or logical log input, helping teams update databases efficiently across IBM z/OS and distributed platforms.
Capabilities
High-speed Apply Engine provides the following capabilities across supported Db2 environments:
| Capability | Description |
|---|---|
| Apply request run | You can create and run apply requests that run SQL statements or logical log input against a target database. An apply request controls how change data is processed and can include job-level information and parameter overrides. |
| Input source processing | You can process multiple types of input sources for apply requests, including SQL statements and logical log files created by BMC AMI Log Master for Db2, to update data quickly and consistently. |
| Configuration management | If you have routine operations that require you to process large numbers of SQL statements, you can use High-speed Apply Engine to speed the process. Consider High-speed Apply Engine for operations that you perform by using your native database SQL processors (for example, SPUFI or DSNTEP2). |
| Parallel apply processing | You can improve performance by running apply requests with multiple agents. High-speed Apply Engine supports multi-threaded runs, enabling parallel processing of change data. Parallel processing reduces the time required to apply large change volumes. It is the key to achieving high throughput in data-intensive environments. |
| Restart processing | You can enable restart processing so that, if an apply request fails, processing resumes from the point of failure instead of reprocessing completed work. This reduces downtime and operational effort for predictable and reliable runs. |
| Transaction recovery | You can use High-speed Apply Engine as part of your recovery strategy for Db2 databases. You can create an input file for High-speed Apply Engine to use to perform undo and redo processing against the target tables. You can include High-speed Apply Engine as part of the recovery tasks that you develop with the Recovery Management for Db2 solution from BMC. |
| Data migration | When you create the target tables for data migration, you can use High-speed Apply Engine to perform the row updates required to move the data to the target tables. Because you can process the updates to the target table without stopping the database, you can migrate data without waiting for a recovery window. You can translate table and column names as you run the apply request, but you cannot transform the content of a column from one data type to another |
| Conflict resolution | You can define conflict resolution rules that control how the apply process responds to SQL return codes or database messages during apply processing. You can define precise actions for specific conditions so that you can control error handling and maintain data consistency during runs. |
| Integration with BMC products | You can integrate High-speed Apply Engine as a component of other BMC products. When integrated with BMC AMI Log Master for Db2, runs change, providing generated SQL and logical log input. When integrated with LOADPLUS for DB2, it supports SQLAPPLY load actions. These integrations allow the product to run generated SQL and apply data changes as part of broader Db2 data management and recovery workflows. |
| Db2 data type support | The High-speed Apply Engine supports the same SQL data types and data type conversions as Db2. For more information about compatible data types, consult the appropriate Db2 documentation. |
| DBCS support | The High-speed Apply Engine supports double-byte characters in logical log input and SQL input. High-speed Apply Engine can read logical log files that are created by BMC AMI Log Master for Db2, or an application program that conforms to the published format. For more information about the logical log format, see the section about logical logs files in the BMC AMI Log Master for Db2 documentation space. |
User roles
| Role | Responsibilities |
|---|---|
| Application developer | Prepare SQL or logical log inputs and submit apply requests as part of data migration or recovery workflows. |
| Db2 DBA | Define configurations, tune parameters, and manage restart/recovery and conflict resolution policies. |
| System programmer | Install and maintain the component via BMC’s Installation System; ensure platform prerequisites and access controls are in place. |
For more information, see Roles and permissions.
Interfaces and components
The following table summarizes the key interfaces and components that support apply request runs, configuration management, and restart and recovery processing:
| Tool or system | Type | Description |
|---|---|---|
| Apply request | Interface | The batch job or command used to start and run High‑speed Apply Engine. The job or command might contain processing information and override configuration parameters. |
| Configuration files | Component | Parameterized control of apply behavior, organized by sections and names. For more information, see Command and syntax reference. |
| Restart table | Component | Stores progress and state needed for restart processing if an apply request fails |
| Integration layer | Component | Delivered as part of BMC solutions (Log Master, Recovery Management, LOADPLUS, Database Administration) and installable via the BMC Installation System. |