Load Tab

Use the Load tab to specify the paths to DBMS loaders.

Note: You can expedite the configuration of the Load settings for the Server by clicking Merge Current User. This merges Load settings for the logged-on user in the Current User registry with settings for the Server machine in the Local Machine registry.
Optim Server Settings dialog, Load tab

Optim Directory

Select [Default] in the Optim Directory list to enter the path and name of the Loader executable file for each DBMS type.

If you have more than one version of a particular DBMS type, you can enter the unique loader specification for each version. Select the specific Optim™ Directory and DB Alias, then enter the appropriate path and name of the Loader executable file for the particular DBMS version.

Load Specifications

Specify the complete path and name of the executable to access each DBMS Loader that can be used with a Load Request.

DB Alias
Select a specific Optim Directory, then click the down arrow to select a specific DB Alias. Specify the appropriate loader path for the corresponding DBMS version.

If you are using DB2®, Oracle, or Informix®, you can also specify a default Creator ID for Exception Tables (or Violation Tables).

To specify load settings for a Teradata database, select a Teradata-related DB Alias and click the Teradata button to display the Teradata Settings dialog.

Exception Table Default Creator ID
Specify a default Creator ID or other identifier for exception tables for DB2 and Oracle, violation tables for Informix, or error tables and work tables for Teradata. For Teradata, this parameter is used to specify the database name in Teradata in which the error tables and work tables (temporary tables) can be created by the Teradata loaders. This parameters is available only when you select a DB Alias for a DB2, Informix, Oracle, or Teradata database.
Fully Qualified Path for DBMS Loaders
Specify the directory path and program name for the specific DBMS Loader. Consult your DBMS documentation for the name of the loader program. To select from your system directories, click the browse button.
Teradata
Click to provide settings for the Teradata loader on the Teradata Settings dialog.
Example of the Teradata Settings dialog
Use FastLoad if more rows than:
Type the row count used to determine whether FastLoad or MultiLoad is used. Allowable values are 0 to 999,999,999. If you specify 0 or do not specify a value, MultiLoad is used. For any other value, FastLoad is used if the row count of the load file is greater than the value you specify for this parameter.
Fully qualified path for Teradata FastLoad
Provide the directory path and program name for the Teradata FastLoad. Consult your Teradata documentation for the name of the loader program. To select from your system directories, click the browse button.
Fully qualified path for Teradata MultiLoad
Provide the directory path and program name for the Teradata MultiLoad. Consult your Teradata documentation for the name of the loader program. To select from your system directories, click the browse button.
Fully qualified path for Basic Teradata Query facility
Provide the directory path and program name for the Basic Teradata Query facility (BTEQ). Consult your Teradata documentation for the name of this facility. To select from your system directories, click the browse button.
Server Name
Type the name of the Teradata server.
Teradata User ID
Type the Teradata User ID for the user creating the Load Request.
Teradata Password
Type the Teradata password for the user creating the Load Request.

Merge Current User

Click Merge Current User to merge the settings from the Current User registry to the Local Machine registry for the Server machine.



Feedback