The DataBee Set Loader Rule Statistics Tab

The primary function of the Set Loader Rule Statistics tab is to provide a record of the status of individual loader rules as the loader set is executed. The current execution state and statistics are presented for each rule individually. Aggregate statistics for the loader set as a whole and specific statistics for those loader rules currently executing, can be found on the Set Loader Run Statistics tab. Please note that other than the Command rule and the Rule Controller all other rules in a loader set are manager rules. This means they encapsulate a large number of actions within one rule. Double clicking with the mouse on any manager rule will open up a form which provides detailed information and diagnostics on that rules actions.

The panel on the Rule Statistics tab lists all rules in the current loader set. There are seven vertical columns in the loader rule statistics display. These columns provide specific information on various components of the rule. All of the statistics fields are "live" and will constantly update as the rule is executing. The columns can be sorted by clicking in the column header above each type of statistic.

What the columns in the Rules Panel mean

Rule#

This column indicates the rule block and ID number of the rule and also contains a small icon which indicates the loader rule type.

Rule Controller

Load Manager rule

Truncate Manager rule

Foreign Key Enable Rule

Foreign Key Disable Rule

Trigger Enable Rule

Trigger Disable Rule

Command rule

The rule block and ID number are displayed as a sequence of digits in the form XX-YYYY. The XX value is the rule block and the YYYY component is the rule ID. The ID of the rule is not particularly significant and serves only to provide a unique identification number for the rule. The rule block, however, is of considerable significance since it controls the execution order of the rule. The DataBee Set Loader software is multi-threaded and can run up to eight rules in parallel. It is almost always the case within a loader set that most rules cannot run simultaneously and must run sequentially one after the other as a chain. The rule block value controls the execution sequence. Please see the discussion of Rule Blocks in the loader set overview help page and view the Creating a New Loader Set tutorial [(local) (internet)] in order to understand how to explicitly control the execution order of the loader rules. Note that the loader rules can be sorted in any order by clicking on the column headers. The presentation order on the display will not change the execution order in any way since the execution order is totally dependent on the rule block configuration. The rule block and the rule ID can be modified in the Set Designer application (not in the Set Loader) by clicking it with the mouse and editing the value as appropriate.

Rule Type

This column contains descriptive text indicating the type of loader rule which is represented by that line of the display.

Status

This area lists the current execution status of the rule. The currently executing rules are always listed as running. A Rule Controller with an actively executing loader rule will also be shown as running until all of the loader rules it contains have been processed.

Rows Loaded

This column indicates the number of rows loaded by a Load Manager rule - it is unused by all other rule types. If a Load Manager rule is currently executing, this display will be updated periodically.

Run Time (sec)

This is the total run time in seconds for the rule. This field will update continuously while a rule is executing.

Rows/Sec

Load Manager rules will execute at a variety of rates depending on the rule type, database configuration and a large number of other factors. This field provides an indication of how many rows the rule is loading per second. The value is derived from the other statistics via the formula: (Rows Loaded)/(Time in Seconds). If the Time in Seconds field is less than 1 then a value of 1 second is assumed. Since fractional seconds are not tracked, this can make the calculated rows per second value seem much lower than it really is for small amounts of data. This field is unused for rules which are not of the Load Manager type.

Errors

Each line describing a rule has a button in the Errors column. If an error occurred during execution, this button will change to a red X indicating that the rule had errors. Pressing on the button will launch a diagnostic form which displays diagnostic and debugging information regarding the error.