DSXchange

Thank you for the replies, to answer the concern that the hash file is used for permanent storage, no it is not. The scenario is as follows. We have a Unidata database, created by third party software, in the 30 gb range, the powers that be decided that this was not easily accessable and that it sho...

It has been suggested to us that Creating our hash files with the minumum modulus set to the current size listed from ANALYZE.FILE will improve our performance since the file will not need to be resized as much as it otherwise would. (it grows daily) This seems to have been working for us, but now t...

Thanks, once I was able to find the pdf on the cd it explained exactly what I needed to do and teh job will now compile.

I am trying to copy files using the command stage, when Igo to compile this I get the message Invalid Data Type COMMAND.RTNCODE followed by the output link name. I have this going into an Oracle 9i stage, where I disregard the input stream altogather and execute a stored procedure that works on the ...

Are you saying that you are running approximately 30 separate jobs at any time during this processing phase? If so, that's the problem there. Using Server, you should limit yourself to a very low number of jobs at a time per CPU. Maybe even 1 if it's CPU intensive. Maybe less if you have a very slo...

I'm posting this to get a general feel for how adequate/inadequate the server is that we are running Datastage on, without going into the detail of monitoring io/cpu/etc on the server. We have a collection of about 136 jobs that runs nightly and extracts over 30 gb of data from a Unidata database an...