DSXchange

Whoa, do the math about how many simultaneous jobs are being run. Try calling the 9 control jobs one after the other making sure that ALL the jobs are not being initialized/run at once. DSWaitForJob() helps if you have not included it yet in your job control yet. How about the default timeout constr...

It will depend on how you are incrementally loading the tables and the priorities of your updates/inserts. If they are handled separately, then it is possible to use a transaction size >0 but if the updates depend on inserts being there first, then it may create a problem, but I'm not too sure on th...

An easy way to achieve this would be to create a shared container having a triggered input from the jobs you are trying to audit. I'm afraid this would be just patchwork, but it still works. Include a few parameters which you can tune to the stages and links that are in the job and then use the BASI...

Have you tried tweaking the Transaction size and Array size? This would only work if your reads are being performed at a good speed. Take Sainath's advice of writing to a local seq. file and checking the speed of the reads. If they are fine and the main botttleneck is the Oci9i stage, then I suggest...

Have you tried tweaking the Transaction size and Array size? This would only work if your reads are being performed at a good speed. Take Sainath's advice of writing to a local seq. file and checking the speed of the reads. If they are fine and the main botttleneck is the Oci9i stage, then I suggest...

Multiple Clients for DS can be installed on the same machine. You just have to install the two different clients in separate directories. I have 6.1 and 7.1.r1 running on the same machine. You can simplify the switching over of the clients by using the clientSwitcher service. Under Unix, you can cre...

Thanks Ray

I was not aware of dssh. I am able to compile and include my basic programs now.

Hi, I am a newbie to BASIC programming in DataStage Server Edition 7.1.r1. I am unable to invoke the basic interpreter from the command line. I get an error saying unble to invoke .VOC file. Same error when I try to invoke CREATE.FILE. Any help will be appreciated. A basic idea about the command str...