Processing Utilities

Edit online

Processing utilities allow you to run Optim™ processes (such as Extract, Archive, Insert, Convert, Compare, Delete, Search, Restore, and Load) in batch mode.

You can create batch jobs in the following two ways:

Enter the job parameters directly in an editor, using the Batch Utility control statements.
Use the Optim online panels to provide process request parameters and elect to run the request in batch. Optim executes the Batch Utility and uses the parameters you entered on the online panels to build the SYSIN data set, which consists of a series of control statements defining the job function to be performed.

In both cases, you can save the batch job and edit the control statements.

This section describes the following batch processing utilities:

ARCHIVE: Create an Archive File, using an Access Definition defined in the Optim Directory. You can use keywords to specify parameters similar to those for the online Archive Process and to override parameters in the Optim Directory Access Definition.
OFFLINE_DELETE: Avoid the overhead of Db2® logging by using a batch Delete Archive Process. When deleting large quantities of data from your database, this could be an important consideration.
COMPARE: Compare two different sets of related data and create a Compare File to hold the results of the comparison. You can specify parameters similar to those for the online Compare Process.
CONVERT: Convert data from an Extract or Archive File to mask sensitive information or transform data to CSV format and create a converted file. You can specify parameters similar to those for the online Convert Process.
DEFERRED_DELETE: Delete archived data from the database, when deletion was deferred during the Archive Process. You can use keywords to provide parameters similar to those for the online Archive Delete Process.
SEARCH: Search for specific data within one or more Archive Files. The results are reported in a data set that can be reviewed online.
RESTORE: Select and restore archived data from Archive Files, using one or more Table Maps and optional criteria.
SUBSET: Create a Subset File that contains a referentially correct subset of rows from an existing Archive File.
EXTRACT: Creates an Extract File, using an Access Definition defined in the Optim Directory. You can use keywords to specify parameters similar to those for the online Extract Process and to override parameters in the Optim Directory Access Definition.
INSERT: Insert or update rows in Db2 tables using data from an Extract File. You can specify parameters similar to those for the online Insert Process.
LOAD: Transform the contents of an Extract File or an Archive File to Load Utility format. The output files created by this statement can then be used as input to an IBM® load utility or another vendor's load utility to load the data into the database.
MOVE_DELETE: Delete data that has been placed in an Extract File from the Db2 database.

The syntax for each batch statement includes a number of keywords that allow flexibility and provide all of the options available online. For most processes, only a few keywords are needed: those to control processing and others to allocate an output file.

Keywords to control processing are shown in the syntax for each batch statement. For keywords to allocate an output file, see File Allocation Parameters.

Note: The batch processing utilities acknowledge all options that are specified on the online Site Options panel. However, User Options are not available to the utilities and are ignored. Control statements in which user options would be relevant include appropriate keywords to allow you to provide equivalent information.