Processing Utilities

Processing utilities allow you to run Optim™ processes (such as Extract, Archive, Insert, Convert, Compare, Delete, Search, and Restore) 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.

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.

CENTERA_OPTIONS

Establish or override options for an Archive File stored on a Centera Server.

TIVOLI _OPTIONS

Establish or override options for an Archive File stored on an IBM Tivoli Storage Manager Server.

IGNORE_GENERIC_RELS

Specifies whether generic relationships are ignored in process requests.

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.