I ran into a "Out of Memory" problem when I am trying to run a QS Match from the DS Plugin. We tested this with low volumes and it worked, but when we are sending 2 mil. records the "uvsh.exe" process reaches the 2 GIG limit on the memory and stops.
The same match process works flawless from the QS GUI.
Thanks..
Running QS match through DS Plugin
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
If I had a dollar for every time I've heard "it's works from the QS gui" I'd be a rich man. Things can get flaky when you try and combine QS and DS, it is can be less robust then QS on its own. You need to experiment and play around with some of your settings in your DataStage job. Have a look at the performance tab on your DS job properties. You can switch between In Process and Inter process, you can also change your buffer size. You can also switch your QS mode between batch and transaction.
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