Hi,
I have a problem in datastage server job-memory issue.Please find below the detailed description:
There exists a job which has many routines involved in connecting to the SQL Server 2000 database.Apart from that this job calls other 10-12 server jobs in sequence.It is told that the main job is consuming more than 50% of the DataStage memory hut there is no issue regarding execution time.PLease sugggest how to handle this issue and how to trace the memory read.
Thank you.
Regards,
Venkat
Job consuming more memory
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why? Memory is a resource to be used. Is there spare memory available? Then don't worry about it.
You have not told us much about these jobs. Do they use hashed file cache, do they do sorting, are there any Aggregator stages? These are just some of the components that will make larger demands on memory than other stage types. What else is happening on the machine? In particular, is there a database server there?
You have not told us much about these jobs. Do they use hashed file cache, do they do sorting, are there any Aggregator stages? These are just some of the components that will make larger demands on memory than other stage types. What else is happening on the machine? In particular, is there a database server there?
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.