Factors to consider for Temporary Storage Space

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
pkothana
Participant
Posts: 50
Joined: Tue Oct 14, 2003 6:12 am

Factors to consider for Temporary Storage Space

Post by pkothana »

Hi All,

I have to check for the Temporary Storage space that will be required to run the jobs. I have around 10 Modules that will concurrently start running. Each module is taking records (in Millions...max 3.7 billion) as input in the fileset.
So for this I have to decide for the temporary space required that should be sufficient enough to handle all the jobs. So I just want to know, what are the factors to consider for the same? For Ex. what are the stages that require temporary space, does reading from a file or writing into a file also require temporary space, does writing into a Data Set also require temp space etc.
Also if somebody can tell me, when is the temporary space gets freed? What are the precautions to take so that we can minimize temporary space?

Appreciate your prompt help.

Thanks & Regards
Pinkesh
Post Reply