DSXchange

Hello Everyone,

We are going to try the following options on the hashed files.

1. Minimum modulus size to be assessed and changed
2. Changing the group size for the dynamic hashed file to 2 from 1.

All of the suggestions were already tried in my project and it dint help. http://www.dsxchange.com/viewtopic.php?t=152133 http://www.dsxchange.com/viewtopic.php?t=154037 Summary: 1. The issue is with the server jobs alone and thre are no parallel jobs in my project. 2. We are not using Operational D...

Thank you.! I have onboarded IBM on this topic. I will check the links and get back to you folks.

I'm working on the hashed file design. meanwhile, I'd like to get a feel around the UVConfig file values. I have listed the important values down below. Do you see any issues with that/=...? DS8.5 DS9.1 MFILES 150 MFILES 200 T30FILE 512 T30FILE 600 OPENCHK 1 OPENCHK 1 WIDE0 3dc00000 WIDE0 3dc00000 U...

The performance with 8.5 version is 35 mins and 90 mins with 9.1.2 version.

Thanks,
Saran

Here are my answers: 1. It runs almost twice as long as the 8.5 version. 2. We use our own surrogate key logic. I have routine, which calls the surrogate key file and generates the maximum value. Hash file logic: Look up the surrkey hash value, if value present then dont create new key, if not go to...

Hello Chulett, The server jobs are running for a longer time than 8.5 edition. here is the scenario, 1. If the jobs are not concurrent than the performance is good, 2. But when the jobs are running in parallel the run time is more than the 8.5 server edition. Please note, in 8.5 under the same scena...

Hello All, Thank for reading this read and here is the summary of the issue I am facing in production. Recently we've move from datastage 8.5 server edition to 9.1.2 server edition. But few of the jobs are running longer than expected in 9.1.2 edition. Summary: 1. Latest ODBC driver is used 2. Opera...

Hello Everyone, The installation of 8.5 server edition (Fix Pack 3) completed. We were able to migrate the 8.1 components and the jobs are running successfully without any issues. Hashed files and other stages are working fine. I could say, you can just import the dsx files from 8.1 into 8.5 and it ...

Yes Chulett.

IBM Datastage Version was installed along with Oracle EPM Peoplesoft 9.1 and it does not support versions higher than 8.5 at the moment. As the Version 8.1 EOS by April month end, We are trying to finish the upgrade before April.

Hello Everyone, We are planning for a migration of Server jobs from Datastage Server 8.1 to Datastage Server 8.5 Server. I was collecting data points related to this migration. I've searched through forums and touchbased with IBM on the migration. Meanwhile, I would like to get few inputs,suggestion...

ray.wurlod wrote:What happened to your "in parallel" requirement? ...

Sorry for the late response Ray. The unix scripts interval is so quick and we dint have to run the jobs in parallel.

Thanks everyone. I used common unix file server for both the projects to overcome this issue.

I know, I agree with you and I had the same point in my mind that, to use common file server where the hashed file will be accessed by both the servers. I'm just trying to see, how far we can go.

Thanks a lot anyway. I will keep this thread open for some days.

Hi Chulett,

I need keep them in synch at any point in time, becuase there is counter in the hashed file used to create surrogate keys. My goal is to process the load in the two environements at the same time but keeping the keys in synch.

Did I make it clear..?