User`s guide

Using multiple engines to reduce job execution time
62 Sybase IQ ETL 4.1
• Install multiple GRID engines
• Register your GRID engines
• Prepare jobs for multi-engine execution
Registering GRID
engines
Once you have GRID engines installed, you can register a subset or all of them
for a special repository. When executing a multi-engine job from that
repository all projects contained will be executed on those engines.
To register GRID engines, select the Engine Manager option from the Tools
menu. If you have open connections to more than one repository you will be
asked to select one of them. The Engine Manager window displays a list of
engines that have been previously registered for the selected repository.
The properties of a registered engine are:
• Name: A user defined name for the engine.
• Host: The name or IP address of the engine host.
• Port: The number of the port the engine is listening on.
• Base Rank: A user defined ranking for the engines. A job will always try
to execute the projects on the highest ranked engines.
• Description: A free description for the engine.
You can register a GRID engine manually or you can register multiple engines.
❖ To manually register a GRID engine
1 Select Engine | New, or click Insert. The Edit Engine dialog box opens.
2 Enter the desired values.
3 Click OK. The new engine is added to the list of engines.
❖ To register multiple engines
1 Select Engine | New Engines. The New Engines dialog box opens. For
each engine, registration and additional information are shown, as well as
the engine’s online state.
2 Select the engines to register.
3 Click Add. The new engines are added to the list.
❖ To modify an engine registration
1 Select the engine in the list and choose Engine | Edit or click Edit. You can
also double-click the engine in the list. The Edit Engine dialog box
displays the current values of the registration properties.