Balance the Data Movement Task Execution Load

To improve server performance, you can balance the execution load when more than one IBM® Cognos® software instance is running the Data movement service.

Some data movement tasks, such as JobStreams, are comprised of multiple processes. When such a task runs, the default is for all processes to run on a single instance of the Data movement service.

You can use the DMS.DistributeBuilds setting to distribute the DM Fact Build and Dimension Build JobStream nodes over several instances of the Data movement service. For more information, refer to your Data Manager documentation.

Procedure

  1. Start IBM Cognos Connection.
  2. In the upper-right corner, click Launch, IBM Cognos Administration.
  3. On the Status tab, click System.
  4. In the upper-left corner of the Scorecard pane, click the arrow to view the Change view menu. Click Services, and then click Data Movement.
  5. Click the arrow next to Data Movement to view the Actions menu, and then click Set properties.
  6. Click the Settings tab.
  7. Click Edit next to Advanced Settings.
  8. Select Override the settings acquired from the parent entry.
  9. In the Parameter column, type DMS.DistributeBuilds.
  10. In the Value column, type TRUE to enable data movement load balancing.
  11. Click OK.
  12. On the Set properties page, click OK.
Parent topic: Tune Server Performance