When to use High-speed Apply Engine

Transaction recovery

You can use High-speed Apply Engine as part of your recovery strategy for Db2, Db2 LUW, and Oracle databases. You can create an input file for High-speed Apply Engine to use to perform undo and redo processing against the target tables.

For Db2, 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 Software.

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.

SQL processing

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, DSNTEP2, DB2CLP, DB2SQL89, DB2BATCH, or SQL*Plus).