Hi Guys,
has anybody had experience of the potential performance improvements in DS 7.01 over DS7? Of particular interest to our implementation are:
(1) varchar source fields (30% improvement quoted I think!)
(2) DB2 connection enhancements
Regards
Simon
Search found 4 matches
- Tue Mar 23, 2004 9:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Version 7.01 with varchars
- Replies: 0
- Views: 851
- Fri Mar 12, 2004 10:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Link Partitioning/Collecting or Coded Round Robin Partitions
- Replies: 7
- Views: 3539
I have each job set with the appropriate properties in terms of multiple instancing and inter-process buffering. Are you guys talking about a Control job calling these 4-5 identical jobs (with different selection criteria) or executing them as 5 separate jobs from director? In fact does it make a di...
- Fri Mar 12, 2004 10:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Link Partitioning/Collecting or Coded Round Robin Partitions
- Replies: 7
- Views: 3539
Ok, thanks for the advice. I will try this and get back to you early next week with my findings. It is also worth mentioning that the SQL Bulk Loader seems fine in this process in terms of performance. I have heard a lot on this forum suggesting that the Bulk Loaders with DataStage are very poorly d...
- Thu Mar 11, 2004 9:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Link Partitioning/Collecting or Coded Round Robin Partitions
- Replies: 7
- Views: 3539
Link Partitioning/Collecting or Coded Round Robin Partitions
All, I am attaining 5,000 Rows Per Second (I know it's bytes that really matter) from DB2 (Using DB2/UDB Object) through and IPC and out to a SQL Bulk/Load Object in DataStage. I am looking to introduce a parallel alternative (Do not have PX yet) in order to use more than 1 CPU (I have 8 in total). ...