datastage server occuping more space
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
datastage server occuping more space
My data stage server occupies more space when ever I run the jobs which results in disk space errors always
why is this happening?
can anyone provide a solution for this situation?
why is this happening?
can anyone provide a solution for this situation?
Regards,
Kenny
Kenny
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Does it happen in jobs with Join Stage or LookUp Stages? I saw the same error in the past when I was getting Cartesian products out of a join Stage due to bad data. The process ended up using all the space defined within the config file and ran out of space and eventually aborted. What is the volume of the data you are processing? Can you provide a sample job design or other specifications from the job that is failing?
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Yes,I use lookup stages in my jobs and I get this error only at these stages.
After deleting some of the files in the server I get space and they run again with no errors,but later I get the same error.
The volume of data is around 1.5 million records.My jobs have lookup's used for databases and copy stages.
After deleting some of the files in the server I get space and they run again with no errors,but later I get the same error.
The volume of data is around 1.5 million records.My jobs have lookup's used for databases and copy stages.
Regards,
Kenny
Kenny
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: datastage server occuping more space
OMG they've killed Kenny!kennyapril wrote:My data stage server occupies more space when ever I run the jobs which results in disk space errors always
why is this happening?
can anyone provide a solution for this situation?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In Designer, use Tools > Configuration
Open the default configuration file and save as a different name.
Edit the configuration file to specify different conditions. Save and check.
Open the default configuration file and save as a different name.
Edit the configuration file to specify different conditions. Save and check.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.