Run a Load Request

To process a Load Request immediately, click File > Run. It is not necessary to save the Load Request before it is run.

A progress dialog and status messages provide information while the request is processing. When processing completes, or stops because of an error, you can review the details in the Process Report. You can also browse the Control File to review process details.

Fast Load Confirmation

Fast Load significantly reduces processing time when you run a Load Request that has run before. When you run the Load Request again, the Fast Load Confirmation dialog displays if these conditions are met:

If the Load Request, Source File, and Table Map names have changed, or the content of the Source File has changed, Optim™ cannot perform Fast Load for any table in the Load Request, and the Fast Load Confirmation dialog is not displayed.

If a Column Map name or the drive and directory for the DBMS loader files for a given table change, Optim cannot perform Fast Load for the table, and the table does not appear in the Fast Load Confirmation dialog.

Note: If you select Delete files if successful or Delete files if failure on the DBMS tab in the Load Request Editor, Fast Load is not available.
Fast Load Confirmation dialog

The Fast Load Confirmation dialog displays the Source file name, Table Map name or Local, and a list of the converted tables. If tables are included from more than one DB Alias, a separate tab is displayed for each DB Alias.

Use the Fast Load Confirmation dialog to review the list of converted tables. To reuse all DBMS loader files for the tables listed, click OK. To create new DBMS loader files for any table, clear the check box for the table and click OK. Click Cancel to stop processing and return to the Load Request Editor.

Note: You can right-click in the grid and select commands from the shortcut menu to select or deselect all tables for the corresponding DB Alias. You can also use the Select All or Deselect All buttons to select or deselect all tables for all DB Alias tabs.