DSXchange

This shouldnt be just due to the DS upgrade. Check whether the table has any lock, and the job might be waiting for the lock to get relased.
Why cant you check the disk spcace?
What do you mean by central memory? Is it temp dirictory? If so what stops you to check the avaiability of space?

Are you getting the numbers for each partition, then you should be able to make up with the combinations of followings @PARTITIONNUM,@NUMPARTITIONS,@INROWNUM

Search for title "Capturing ORACLE error",Hope this should help your requriement.

http://www.datastagexchange.com/Newslet ... enting.htm
One such page.

So, will errors.txt gives the information about corrupted file? But it shows " Backing up <filename>". May I know what other reasons to get this errors, because, "UVFIXFILE <filename>" is giving not error to the hashed file that I got in the errors.txt. And May I know the actual syntax for backup us...

Search for another similar post in the topic "Warning during execution of StringToDecimal Function"

I guess, its your second post regarding the same issue. i know you havnt got any solution in the previous thread.
As suggested in the previous thread, have you tried to reset the job? Have you got "From the previous run.." log? If so what does it says?

balajisr wrote:It would be better if you could explain your requirement in detail.
Meena is correct loop activity is available in 7.5 only.

...and in further release.

Stages is GUI term used in front end, operator term used in the underlying design of datastage. For example, sort operator, funnel operator, sortfunnel operator... Can be explicitly available as a stage, or will be supplied by datastage along with other stages like, funnel, join, sequential file Sta...

the date , the currency code, the desired currency code and the sum This will be input. But you need to have a hash file (in your case) which holds the conversion rate for that date. So that you can do a lookup on the date and or the currency code to get the conversion rate for that poit of time. A...

Mukund - Can you pls delete the other duplicate post created.

ray.wurlod wrote:Yes, physical. Separate spindles.

Ray - Still I dont get why you suggested 24. For a case of 1 CPU per node and 8 such node, May I know what way does 24 disk access improves the preformance. I guess the read / write will be done serially, i.e., disk1 then disk2, then disk3...

I could vaguely recall, there was a post stating that, in some version of Server edition, you need to reconfigure the password for each time you move the code from one environment to another.

That was horrible.
Fortunately I got access to restart Unix server. As of now its going ok. Let me see, as you faced the same issue again on the next day..... Now I dont mind to find the root cause, but I wish it shouldnt continue.

wvandegaer - Do you got any updated on this?
Iam facing the same issue now. Version is 7.0 / unix.
I yet to restart datastage, but iam not sure I can restart unix server.