IBM Support


InfoSphere DataStage: Parallel Job Performance Issue on Redhat Linux 6.1 System

Troubleshooting


Problem

On the RedHat Enterprise Linux 6.1 operating system, parallel jobs run with degradated performance.

Symptom

On RedHat Linux 6.1 system there is a 10 - 90% performance degradation depending on the hardware configuration and DataStage node configuration during parallel job runs. Increase in number of CPU cores and DataStage node counts used on the system leads to more performance degradation.

Cause

This is caused by Parallel jobs using transformer stages and use of the CurrentTimestampMS() function in the transformer stage on the Redhat Linux 6.1 system.

Diagnosing The Problem


Resolving The Problem

On the computer that has the Redhat Enterprise Linux 6.1 operating system installed, set the environment variable as follows:


TZ=:/etc/localtime
before running parallel jobs. The CPU time improves.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.1;8.7;11.5;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"PF016","label":"Linux"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21598208

Page Feedback