Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Running ETL using an NSH script

You can run ETL from the command line using the run_etl.nsh script.

When you run the run_etl.nsh script, it executes the scenarios in the specified property file and runs them in the background. By default, run_etl.nsh executes scenarios for all report data groups in parallel sequence (using the default RunETL.properties file) if the database resources allow. However, you can execute scenarios for individual report data groups. The script is located in the etl/bin directory.

The run_etl command has a property file argument that enables you to run an individual scenario that corresponds to one of the report data groups. Using the property file argument, you specify a property file that includes the appropriate individual scenario and any parent scenarios that are required to properly execute that scenario. The property files enable you to customize your reports warehouse updates.

If you limit the number of scenarios that can run in parallel, using the -p property file argument, and the script must execute more scenarios than the limit, it executes scenarios sequentially in groups based on the limit.

Note

BMC recommends that you always run the run_etl command with the default RunETL.properties file to update the reports warehouse and reports with data for all report data groups. If you run the command with an individual scenario property file, the reports warehouse and reports contain the latest data only for the report data group that corresponds to the property file. The warehouse and reports for all other reports groups contain older data.

For descriptions of the scenarios, their execution dependencies, and property files, see Understanding-data-transfer-scenarios.

You can run the run_etl command on a schedule by using platform-specific OS scheduling or you can run it on demand from the command line.

Note

You can only run one ETL instance at a time from a BMC BladeLogic Decision Support for Server Automation installation. If you attempt to execute more than one instance of the run_etl command at the same time, the most recently executed instance returns an error.

You can set up schedules to run the run_etl command by using your operating system scheduler (refer to your operating system documentation). You can also schedule ETL runs for multiple sites. For more information, see Scheduling-ETL-for-multiple-sites.

The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*