IBM Support

Why are my Datastage Jobs showing a status of "Queued"

Question & Answer


Question

We realize that when trying to run some jobs the Director, they began to enter the Queued status, as if there is a limit of jobs that can run simultaneously. Why is this happening? How can we manage this?

Cause

The Workload Management (WLM) was introduced in Information Server version 9.1
This tool provides the capability to manage and control the order and priority given to parallel and server jobs

Answer

For more information on managing the WLM please read through the documentation regarding setting up the queues.

The main reason why jobs won't run when WLM is enabled is because the criteria defined is not met. Open the operations console and review the following criteria for the Queue if any of them are red, then you will either need to adjust the thresholds or address the cause.

  • Maximum running jobs
  • CPU Usage
  • Memory Usage
  • Job Start


If however, this feature does not appeal to you. simply modify the DSODBConfig.cfg found in InformationServer/Server/DSODB directory

Look for the following line text and set the value to 0

# DataStage Workload Manager Configuration
# ===================================================
.
# The following enables workload management if set to 1, or disabled if 0.
WLMON=0

Internal Use Only

This technote was generated by Technote Kickstart 1.1.0.83 based on Information Management PMR 80160,235,631.
View the associated PMR's text via Wellspring at: http://eclient.lenexa.ibm.com:9082/DocFetcher/source/PMR/80160.235.631%20O14/10/16

[{"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;11.3","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21688288