Regaining Scaratch disk space

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Regaining Scaratch disk space

Post by pandeesh »

Currently my scratch disk is 73% utilized.
I am able to see lot of temp files in side the scratch path.
Can i simply remove all the files ?
What those files are exactly?
The issue is at this time, if i run any job which processes more than 2 billion records, the job gets aborted with write failed,file full errors.
The following errrors are:

Code: Select all

Unable to allocate communication process.
Short read
Socket on non socket
All those reveal the scratch disk space issue.
My question is, i need to increase the size of scratch disk or can i regain the space which is already used?

Thanks
pandeeswaran
chandra.shekhar@tcs.com
Premium Member
Premium Member
Posts: 353
Joined: Mon Jan 17, 2011 5:03 am
Location: Mumbai, India

Post by chandra.shekhar@tcs.com »

What is the size of the scratch disk?
Thanx and Regards,
ETL User
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

This is the size of scratch disk

Code: Select all

FileSystem                              1K-blocks   used         Availability     USE%
/dev/mxse/vshared-vl1          20642428    14213512   5380340         73%
How we can regain the used space??

Thanks
pandeeswaran
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

How I can find that?
In my previous post I have posted the size of the path which is mentioned as scratch disk in my configuration file.

Thanks
pandeeswaran
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Of course, you could always increase scratch space - more is better. And clearing it can be simple if it is dedicated scratch space. Does DataStage share that space with other applications? If not, if all that plays there are DataStage jobs, whenever there is a quiet moment when nothing is running you know you can scrape out any leftover debris from that space.
-craig

"You can never have too many knives" -- Logan Nine Fingers
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

Thanks Craig!!
As per my understanding, if none of the jobs are running in the environment , then scratch disk directory should 0% used.
Am I correct?

Thanks
pandeeswaran
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ideally, yes, in a perfect world.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Start with the oldest files first. Delete them first.
Mamu Kim
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

Thanks for your inputs!!
But in my case,the jobs are running in grid environment,
So, i am not able to see the actual scratch disk path.
In the configuration file, the path is mentioned as "/a/Datastage/Scratch"
But actually there is no such path in my unix server.
I believe that directory is located in some other server.
Thanks
pandeeswaran
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Contact your datastage administrator and have them look at the mounts. They can see what jobs are currently running and the age of the left-over files in scratch.

An aborted job does not always clean up scratch files.

You admin team would have access to the compute nodes in your grid.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

:idea:

Write jobs that never abort.
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