DSXchange

How about if I have multiple reference lookup hashed files. In what order does it get loaded into memory ? For example... Hash1 Hash3 Hash5 | | | SeqFile--->Trn1------>Trn2---->Trn3---->SeqFile | | Hash2 Hash4 I am not able to get the picture right. Hash1 and Has2 lookedup from Trn1 and Hash3 and Ha...

I have not done anything yet. I am just trying to understand the process well before making changes. Another question. This may be basic. Anyway, How does the caching works in hashed files ? Meaning when I have multiple reference lookups in the process does the first hashed file gets loaded into mem...

Ray, Thanks for the info. I need some help here to make the changes to uvconfig file. Below are the current setting on uvconfig file... DISKCACHE -1 DCBLOCKSIZE 16 DCMODULUS 256 DCMAXPCT 80 DCFLUSHPCT 80 DCCATALOGPCT 50 1. If I set the DISKCACHE to 512 would that enough for system cache or public sh...

Thanks for the reply. I have another question here. In my process I do a lookup on same hashed file in three different transforms passing different values does that mean that It's going to load as many times memory ? In the first transform I have three reference lookups, second transform also has 3 ...

Ray Thanks for the info. But I am not getting this warning on that particular 1100 MB file rather I am getting it in different file. One other thing is we don't have the same problem in Production. How is it possible ? Do I miss something here ? I calculated the file size by adding data.30 file and ...

Hi I am looking for some advice on Hashed file Preload file to memory option. I am getting the warning message as following...I know that this is just a warning message.But I am looking for a way to avoid this. "add_to_heap() - Unable to allocate memory" I am getting this warning for a Has...

Hi We got the following error. but when we reran it just ran fine. src_van_PolicyChanges_mrg..Sort_18: Error in merging files Internal Error: in DSCRestoreRowFromBuf Job Design is given below... SeqFile1 SeqFile2---->Link Collector---->Sort Stage---->AggregatorStage--->SeqFile SeqFile3 Sort Stage Ma...

I am sorry for not making it clear in my first post. Let me try again... Setup is that DataStage jobs are run from Shell Script using a Third Party Scheduler. There is one common Shell Script which runs all the Jobs. Scenario is that I have a multi instance job to run. Problem is that the scheduler ...

Am I not clear with the question ? I was expecting some ideas...

I am facing a problem while running the multi instance job from the scheduler. Scheduler kicks off the DataStage Jobs using shell script. In this case, one instance of the Seq job is failed so it's not able to start the other instance. But If I put the RESET step in the script before running the job...

Hi I am getting some strange errors with my DataStage job. We execute DS jobs from a third party scheduler using shell scripts. One day job completes without any issues but next day it gives error message like this "Job must be reset before it can run." I just reran the job it ran fine. On...

Kenneth I am not sure if you can make sense out of this...I selected the code tag and pasted it but it comes like this...FYI...This is not the screenshot when I had problems. It's just sample...If the hdisk3 is 100% then my job is running slow...I believe that means there is high I/O. If that's corr...

Can anyone tell me how can I paste a screen here ?

Thanks

Yes. I do. I had them as my second option. I got more respect for you guys ! :D

Hi I am trying to narrowdown the cause for one of my job which finishes quick in one day and takes long time on the other day. I did topas as my OS is AIX...I need some help in interpreting the results...I think we have 8 CPU's on the server. I see only less numbers in CPU% column but Disk busy colu...