The options on the Misc. Setup tab of the Set Loader application exist to modify the actions of an executing loader set. Please note that any changes to these options can only affect the currently open loader set. The Set Loader application has no ability to save any changes back into the loader set. To permanently save changes to the Misc. Setup tab options into a loader set, open the loader set in the Set Designer application and make the changes there.

The Set Loader Misc. Setup Tab

Loader Set Options

Test connections before running loader set

If checked, the login details for all Rule Controllers will be tested before any loader rules are executed. This option is useful if the loader set is configured with multiple Rule Controllers as it can prevent a login failure resulting in a partially run loader set.

Each rule makes a new connection.

The normal method of operation for the DataBee Set Loader software is for each thread to make and hold open a connection to the target schema. This connection is used by all rules running on the thread and is only closed when the loader set run is finished. Under some circumstances it is better to have each rule connect and disconnect rather than using a pooled set of connections. This option is slower since it requires to overhead of making a connection for each rule but can be useful if network timeouts or other errors such as ORA-03113 End of file on communication channel are being received.

Global Load Rule Hint

This hint is applied to all SQL statements that load rows in the Set Loader application. Usually this hint is unnecessary and the option exists primarily to be used when advised to do so by the DataBee support team.

The Set Loader Misc. Setup Tab Loader Report Options

Loader Report Options

The two load statistics reports which can be generated using the Loader Rule Statistics Report and Loader Table Statistics Report buttons below can also be automatically generated when the loader set completes.

Write the report to the logfile

If checked, the report contents will automatically be emitted to the logfile upon completion of the loader set run.

Write the report to the directory below

If checked, the report contents will automatically be emitted to the specified directory upon completion of the loader set run. The file name used is a concatenation of the loader set name and the date.

Actions

Show Notes Splash Screen

Immediately displays the notes splash screen. This can be used to review the contents of the loader set notes.

View Log File Now

Each time the Set Loader application starts it creates a new log file in which it records its actions. This button will open the current log file in a text editor.

Loader Rule Statistics Report

Launches a form which provides the ability to save a report listing the statistics of the rules in the current loader set run. A rule statistics report could be used to provide a permanent record of the execution of the rules.

Loader Table Statistics Report

Launches a form which provides the ability to save a report listing the statistics of the tables in the current loader set run. A table statistics report could be used to provide a permanent record of the number of rows loaded for each table.

Reset All Passwords

This button prompts for a password and sets all passwords on each Rule Rontroller in the set to the specified value. This function can be useful if the set contains multiple Rule Controllers which have frequent password changes mandated by a security policy.

Configuration Details

Directory for Log Files

The Set Loader application writes out various informational messages to a log in order to record its progress. A new log file is created each time the application starts and this field indicates the directory in which the log files will be placed.