Hi All,
How do I release the scratch space used by datastage.
For example I am using a remove duplicate stage to remove some duplicate row and for this I need to sort the input stream. When I am sorting the input stream, datastage use the scratch space for that ( 20 Million rows). But my requirement is after this remove duplicate stage I need to release the scratch space used by this sorting, because rest of my job not using this.
Is there any way to do it in datastage?
I don't know it, please help.
Release Scratch
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Does Remove Duplicates use much scratch space? I would have thought when the data was already sorted it would only need a small amount of scratch space. The Sort stage wont remove the scratch files until it has passed on all rows which will probably be just before the job finishes.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
No. The sort using expected scratch space, but I need to know is there any way around in datastage to remove/release the scratch space after this Remove Duplicate stage. Because we have couple of other sorting logic after this stage. I want to release the release/remove the scratch space used in this stage.vmcburney wrote:Does Remove Duplicates use much scratch space? I would have thought when the data was already sorted it would only need a small amount of scratch space. The Sort stage wont remove the scratch files ...
Thanks
Girija S