Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

When to use High-speed Apply Engine

The High-speed Apply Engine can improve the performance of operations that require large numbers of updates to your DB2, DB2 LUW, or Oracle databases, including transaction recovery, data migration, and SQL processing.

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).

Was this page helpful? Yes No Submitting... Thank you

Comments