Analyzing Execution Details

image_pdfimage_print

After the execution of an Integrator (ETL) job or load, the following essential runtime information is displayed in the monitor of Jedox Integrator:

  • Execution ID
  • Start time
  • Duration
  • Status
  • Log messages

More detailed information at the component level (i.e., extracts, transforms, loads) can be obtained through execution detail monitoring. This can be helpful for performance analysis of complex Integrator jobs.

The execution detail monitoring has to be activated first by setting the parameter “#persistDetails” in file .\tomcat\webapps\etlserver\config to “true” (requires tomcat restart after the change is made).

Note: the analysis of execution details is currently only available via the Jedox Integrator Command Line Client (CLI). For a forthcoming release, it will also be integrated in the Jedox Integrator.

The runtime data can be returned either in tabular or graphical form, as outlined below.

Execution details in tabular form

A CSV file can be generated, with additional runtime information on the execution of each component (using “;” as delimiter). The following information is available:

  • Component name
  • Runtime in seconds
  • Runtime in % of total runtime
  • Number of input calls
  • Number of output calls
  • Number of input rows
  • Number of output rows

For extracts, the number of input calls and rows is always 0. For loads, the number of output calls and rows is always 0.

Notation:

etlclient -ed <executionid> -o <filename>

Execution details in graphical form

A flow graph of the Integrator project can be generated with additional runtime information on the execution for each component. This SVG (Scalable Vector Graphics) file can be opened with any browser.

Available information:

  • Component name
  • Runtime in seconds
  • Number of calls
  • Number of rows

For extracts, the number of calls and rows signifies the number of output rows. For transforms the number of calls and rows signifies the number of input rows.

Examples

1. Write the execution details of execution ID 123 in tabular form to file ExecutionDetails_123.csv

etlclient -ed 123 -o ExecutionDetails_123.csv

2. Write the execution details of execution ID123 in graphical form to file ExecutionDetails_123.svg

etlclient -eg 123 -o ExecutionDetails_123.svg

image_pdfimage_print
Was this post helpful?
NoYes (0 rating, 2 votes)
Loading...