Search found 22 matches
- Thu Mar 18, 2010 9:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Creation Bogging Down Server
- Replies: 13
- Views: 4958
- Thu Mar 18, 2010 9:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Creation Bogging Down Server
- Replies: 13
- Views: 4958
- Wed Mar 17, 2010 9:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Creation Bogging Down Server
- Replies: 13
- Views: 4958
- Wed Mar 17, 2010 9:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Creation Bogging Down Server
- Replies: 13
- Views: 4958
- Wed Mar 17, 2010 8:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Creation Bogging Down Server
- Replies: 13
- Views: 4958
- Tue Mar 16, 2010 2:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File Creation Bogging Down Server
- Replies: 13
- Views: 4958
Hashed File Creation Bogging Down Server
We have a UNIX server split into zones (all on Solaris 10). On one zone is DataStage, on the other is our reporting application. I've found that when creating large hashed files (>20 MB or so), the performance on the entire server suffers (the reporting app slows down, it takes significantly longer ...
- Thu Mar 05, 2009 4:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Designer hangs when opening DRS stage
- Replies: 6
- Views: 2586
Great success! The Windows guys here suggested using Revo Uninstaller (freeware available at http://www.revouninstaller.com/), and I was able to get back into DRS stages again. Revo only works if the program you want to clean up is currently installed, so I had to reinstall DS in order to uninstall ...
- Thu Mar 05, 2009 2:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Designer hangs when opening DRS stage
- Replies: 6
- Views: 2586
- Thu Mar 05, 2009 1:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Designer hangs when opening DRS stage
- Replies: 6
- Views: 2586
- Thu Mar 05, 2009 12:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Designer hangs when opening DRS stage
- Replies: 6
- Views: 2586
Designer hangs when opening DRS stage
I'm running into a peculiar issue with Designer. I am unable to open DRS stages now. Any other stages are fine (I've tested transform, hashed file, sequential file, merge, ODBC, Oracle, UniVerse, etc.), but Designer hangs if I try to open a DRS stage. I can switch to that window, but I can't close i...
- Thu Jun 12, 2008 7:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to capture deletes incrementally
- Replies: 4
- Views: 2677
Thanks for the replies, everyone. I think we're probably going to end up flagging the deleted rows in fact tables. I just wanted to get some options from people that have actually dealt with this before, so I appreciate the suggestions. If I have any issues with the implementation, I'll either open ...
- Wed Jun 11, 2008 1:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to capture deletes incrementally
- Replies: 4
- Views: 2677
How to capture deletes incrementally
First of all, I apologize if this has been discussed here before. In looking through other topics regarding change data detection, I wasn't able to find an answer to what I'm looking for, but I may have missed it somewhere. If so, please point me in that direction. Most posts that I saw regarding de...
- Tue Mar 11, 2008 1:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Converting one row into multiple rows
- Replies: 9
- Views: 2893
Not all of the rows from table A are joined to table B -- just the unique ones, which is less than 12,000. So the performance is pretty good. It took less than 3 minutes to read the 1.2 million rows from the database and write to a hashed file, then a couple seconds to read 12,000 rows from the hash...
- Tue Mar 11, 2008 1:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Converting one row into multiple rows
- Replies: 9
- Views: 2893
- Tue Mar 11, 2008 12:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Converting one row into multiple rows
- Replies: 9
- Views: 2893