How to handle scratch space error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
avik
Participant
Posts: 2
Joined: Thu Apr 23, 2009 8:40 am

How to handle scratch space error

Post by avik »

Hi,
When using merge stage with a large volume of data I am getting scratch space error.How can I resolve this issue?
I don't have any admin privilage.
Is there any environment variable by which we can increase the scratch space?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You would either need to request the size of your scratch area be increased or point your job to a different, meaning larger area.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The only way that scratch space can be increased is to use a configuration file that specifies more scratch space.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
avik
Participant
Posts: 2
Joined: Thu Apr 23, 2009 8:40 am

regarding scratch space

Post by avik »

ray.wurlod wrote:The only way that scratch space can be increased is to use a configuration file that specifies more scratch space. ...
Hi,
Thanks for your reply.
Can you please let me know which configuration file needs to be changed and the exact procedure?
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The default configuration file is called default.apt. Other configuration files may exist on your system. They can be seen using the Configurations editor (available from the Tools menu in Designer). Whether you can edit or create configuration files is dependent on security at your site. As for what to include, consult the manuals and involve your UNIX system administrator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply