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.
Search found 27 matches
- Tue Jan 10, 2017 9:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
- Thu Dec 08, 2016 1:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
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...
- Thu Dec 08, 2016 1:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
- Thu Dec 08, 2016 12:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
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...
- Thu Dec 08, 2016 12:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
- Tue Dec 06, 2016 11:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
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...
- Tue Dec 06, 2016 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
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...
- Tue Dec 06, 2016 8:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue with DataStage 9.1 Server Jobs
- Replies: 12
- Views: 13305
Performance Issue with DataStage 9.1 Server Jobs
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...
- Mon Mar 09, 2015 9:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration of Datastage Server 8.1 to Datastage Server 8.5
- Replies: 4
- Views: 5161
Issue Resolved
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 ...
- Tue Feb 10, 2015 10:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration of Datastage Server 8.1 to Datastage Server 8.5
- Replies: 4
- Views: 5161
- Tue Feb 10, 2015 9:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration of Datastage Server 8.1 to Datastage Server 8.5
- Replies: 4
- Views: 5161
Migration of Datastage Server 8.1 to Datastage Server 8.5
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...
- Tue Oct 14, 2014 3:49 pm
- Forum: General
- Topic: Triggering the same job n no of times at the same time
- Replies: 5
- Views: 2737
- Tue Oct 14, 2014 3:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting/Updating hashed file across diff servers
- Replies: 8
- Views: 6732
Inserting/Updating hashed file across diff servers
Thanks everyone. I used common unix file server for both the projects to overcome this issue.
- Fri Sep 05, 2014 12:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting/Updating hashed file across diff servers
- Replies: 8
- Views: 6732
- Fri Sep 05, 2014 10:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Inserting/Updating hashed file across diff servers
- Replies: 8
- Views: 6732