DSXchange

Had to bump this topic.

Any idea anyone?

Each time I run my job, I get my hashed file corrupted and have to rename it so I can run the job again.

Now I had recreated the job from zero... hope that works

Yes, job is running fine when i put a row limit of 1.

Yep, the first time my Hash file WAS bigger than 2 GB, so i deleted all unnecesary columns and cheked the "minimize space" option. This made the Hash file 779 MB now (I can check that just before it is deleted). Then I thought it could be corrupted, so I changed the Hash file name so a new...

Just some aditional info. When the job is running and I display the "performance statistics", i can see the job reaches a point in which it stops writting data and the job seems to freeze for like 30 minutes. This occurs when writting the Hash reaches the last row. Then the error jumps. Ad...

Hi all, I am having an error when writting to a Hash file and then reading it in a server job. Log goes as follows: Abnormal termination of stage J_LLAMADAINTERNA_3_T..Transformer_8 detected From previous run DataStage Job 3788 Phantom 4816 Unhandled exception raised at address 0x10143204 : Access v...

You were right, it was a server job so i worked with the OConv function. I got the date like this: Oconv(Div(VARIABLE+63226800,86400),"D4/YMD") Ang got the time like this: Oconv(Mod(VARIABLE-18000,86400), "MTS") There was a difference between Unix time (number of seconds since 19...

You were right chulett, it seems that the merge state uses more space than it looks.
I deleted some unnecesary colums in one of the files and freed some space in the disk and then it worked fine. Seems that 10 GB free space was not enough.

Thanks

Hi: I am having trouble with a job that uses the merge stage. The job is like this: Merge --> Sequential file I am merging two files (one is 2GB while the other is 300 KB) and I am getting the following error after reaching 20 million rows aprox (which i guess is when the stage finishes merging the ...

I'm having the same performance issue, any help on this?. EJS. I have 2 database stages First database stage contains a number field called IP_NUMBER. Second database stage contains fields called IP_FROM IP_TO COUNTRY_NAME COUNTRY_CODE DOMAIN_NAME I have done a sparse lookup and a query in the datab...