Folder Stage Ouput comming as blank

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dilip.datastage
Participant
Posts: 22
Joined: Wed Aug 15, 2007 10:59 pm
Location: Bangalore

Folder Stage Ouput comming as blank

Post by dilip.datastage »

Hi,

I am using Folder stage to read the file names but the output is comming as blank. I have 2 files in particular folder. when i run the job, it is showing 2 rows have been processed but the output is blank.

In the director i am able to see warning message:
DataStage Job 1171 Phantom 8454
Program "JOB.607259350.DT.1461263254.TRANS1": Line 49,
Available memory exceeded. Unable to continue processing record.
Program "JOB.607259350.DT.1461263254.TRANS1": Line 49,
Available memory exceeded. Unable to continue processing record.
DataStage Phantom Finished

Please suggest me how to resolve this error.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try processing fewer and/or smaller files, find some solution that does not require a Folder stage (which tries to keep the entire files in memory) - perhaps using a loop in a job sequence, or put more memory in the server.
Search the forum for more ideas.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dilip.datastage
Participant
Posts: 22
Joined: Wed Aug 15, 2007 10:59 pm
Location: Bangalore

Post by dilip.datastage »

Thank you ray. I implemented with unix command LS
Post Reply