Search found 4992 matches
- Tue Jun 24, 2008 9:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp on Condition
- Replies: 5
- Views: 1987
- Tue Jun 24, 2008 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Import SQL Server metadata
- Replies: 1
- Views: 1006
- Tue Jun 24, 2008 9:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Any Good Documentation on Best Practices
- Replies: 8
- Views: 3810
One of the difficulties is how the ETL is going to be used. One good practice for ETL in a data warehouse of small volume and large processing window won't apply to a high volume and small processing window. You may have to factor in staff competency and ability to maintain the code. If your source ...
- Mon Jun 23, 2008 2:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Jobs are hanging can't kill PID
- Replies: 4
- Views: 2661
Your post sheds more light. Once jobs are done the STOP button doesn't really work anymore while 3rd party external processing are running. So, if you're doing Routine calls to go out and run shell scripts, connect to databases via command line, etc, you're in a blackout zone. Until those commands r...
- Mon Jun 23, 2008 12:46 pm
- Forum: General
- Topic: Transformer Stage hangs
- Replies: 1
- Views: 1448
- Mon Jun 23, 2008 12:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Jobs are hanging can't kill PID
- Replies: 4
- Views: 2661
Rather than hanging could it be writing out its write-delayed hashed files? As for killing/stopping jobs, the Director STOP button is the first best recommendation. Usually a Task Manager kill is the second last thing to do, right before a server reboot. Try the STOP button, try the Cleanup Resource...
- Mon Jun 23, 2008 12:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clean up resources
- Replies: 4
- Views: 1721
- Mon Jun 23, 2008 12:25 pm
- Forum: General
- Topic: Stopped job runs in background
- Replies: 2
- Views: 1367
- Tue May 13, 2008 1:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed file optimization
- Replies: 1
- Views: 1424
Keep it simple. Always use DYNAMIC, for tuning, pretty much setting a minimum modulus should be about it. Don't overcalculate it, just simply set it high enough to keep from dynamically resizing. A modulus of 200K is a 400M DATA file, 300K is 600M, 400K is 800M, get the pattern? Just size higher tha...
- Thu May 08, 2008 7:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence calling stored procedure is never ending
- Replies: 3
- Views: 1528
- Thu May 08, 2008 7:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence calling stored procedure is never ending
- Replies: 3
- Views: 1528
- Thu May 08, 2008 7:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: what is difference between datastage TX and data stage EE
- Replies: 1
- Views: 1298
- Thu May 08, 2008 7:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Never use basic transformers!!!
- Replies: 22
- Views: 9343
Unless, of course, you install a full DataStage Engine on every machine. Talk to your account rep - they'd LOVE to hear from you ($$$$$$). Only on each SMP machine in the cluster - the MPP are out of consideration. I doubt anyone will pay to license a DS Engine on every phyiscal machine in the SMP ...
- Wed May 07, 2008 3:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Never use basic transformers!!!
- Replies: 22
- Views: 9343
- Wed May 07, 2008 2:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Executable file of a DS Job
- Replies: 26
- Views: 21572