A fix is available
APAR status
Closed as program error.
Error description
DataStage jobs that include a Tranformer stage along with a Netezza stage in the same job design hang after the installation of Fix Pack 1 on Windows platforms. The issue exhibits itself after the job has apparently finished since a Director Monitor View shows that all stages in the job have indeed finished but the final status for the job still showsas Running. In addition, one osh process will consume the resources for a single CPU core until the job is stopped.
Local fix
Problem summary
Parallel jobs that use the Netezza stage show a status of Running even though the job has finished. This is caused by problems in the shutdown of osh.exe.
Problem conclusion
The osh executable was looping when using return(result) to exit. The code was changed to use _exit(result) and we were then able to run the previously hanging job multiple times without any failures.
Temporary fix
Comments
APAR Information
APAR number
JR39892
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-20
Closed date
2011-07-13
Last modified date
2011-07-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R850 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
13 July 2011