DSXchange

I am not too sure if there are any solutions to this but when I open datastage director with categories turned off it takes about 5mins to display all the jobs. Is there any way to make this quicker?

These are the results I am getting from my hash file.... what does it all mean? I am really confused about the load factors???? >ANALYZE.FILE DAILY.SAVINGS File name .................. DAILY.SAVINGS Pathname ................... DAILY.SAVINGS File type .................. DYNAMIC Hashing Algorithm ......

does the analyze.file command work? Will it help in setting the minimum modulus?
Could someone please explain that to me?

How do I know what modulus I should set a dynamic hash file to?
Is there a formula to gain optimal performance?

Thanks everyone. I think I have what I need now... I will go away and try out some of your suggestions.

Thanks again
Brad

I am looking at speeding up my datastage jobs. I have already looked into the loading of the data and got that down to 40mins but my batch still runs for 4hours. Does anyone have any ideas on how to speed up datastage or make better use of memory available? It is all your calculation process. Test ...

Hi,

I am looking at speeding up my datastage jobs. I have already looked into the loading of the data and got that down to 40mins but my batch still runs for 4hours.
Does anyone have any ideas on how to speed up datastage or make better use of memory available?

Thanks
Brad