Page 1 of 1

Running QS match through DS Plugin

Posted: Fri Apr 09, 2004 9:38 am
by PilotBaha
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..

Posted: Mon Apr 12, 2004 5:41 pm
by vmcburney
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.