Search found 4605 matches

by kduke
Wed May 04, 2005 9:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we replace hashed files using the UniVerse DB Stage?
Replies: 2
Views: 965

Yes. Hash files can be built with hash file stages and then accessed with UV stages. The difference is UV stages use SQL to select and update where hash file stages read and write in a more native method. Hash file stages should be faster. You can do things like multiple row lookups only with UV sta...
by kduke
Wed May 04, 2005 9:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashed file
Replies: 6
Views: 2069

Most of us use hash files to do all the lookups. Most use surrogate keys in all target tables. You will need to to build cross reference hash file lookups meaning the hash file has the old source key as the hash file key and it stores the surrogate key as a regular (not key) field. Does that make se...
by kduke
Wed May 04, 2005 9:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need info about uv command
Replies: 10
Views: 2542

Arnd

Just too fast for me.
by kduke
Wed May 04, 2005 9:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need info about uv command
Replies: 10
Views: 2542

The uv command is supposed to work in an account directory. An account is defined by 4 files VOC, VOCLIB, D_VOC and D_VOCLIB. If these files do not exist then it will create a new account. Universe has the ability to emulate other versions of Pick or Prime Information. All projects are setup as Idea...
by kduke
Wed May 04, 2005 5:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple server version in same host
Replies: 5
Views: 1967

Arnd

I think 4 was the same as Universe which is different than 7 so they could coexist.
by kduke
Tue May 03, 2005 6:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CPU performance maxing out in Designer
Replies: 5
Views: 1326

So far avoid 7.5.1. Go to 7.5 instead.
by kduke
Tue May 03, 2005 2:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashed file
Replies: 6
Views: 2069

What is your question?
by kduke
Tue May 03, 2005 2:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass values to job parameters in a sequencer
Replies: 16
Views: 5180

Describe how you do this in a shell script or post the code.
by kduke
Tue May 03, 2005 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple server version in same host
Replies: 5
Views: 1967

The client has nothing to do with the server setup except they need to match. I think what you want to do is possible. The shared memory is separate in these 2. The connection stuff is different listeners on separate ports. I would try it. Make sure you back up.
by kduke
Tue May 03, 2005 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Hashed File Calculator
Replies: 8
Views: 3065

Arnd beat me to the return. Too slow now a days.
by kduke
Tue May 03, 2005 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Hashed File Calculator
Replies: 8
Views: 3065

If you wish to use static hash files and not dynamic then it will help you select a modulo. I never use static hash files not worth the effort. Someone needs to maintain them and understand them long after I am gone from the project. Even worse is they can exist and be sized poorly and killing your ...
by kduke
Tue May 03, 2005 7:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage has a new name!
Replies: 9
Views: 2662

We get second billing to WebSphere. TX gets third billing. How long will that product last?
by kduke
Tue May 03, 2005 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CPU performance maxing out in Designer
Replies: 5
Views: 1326

Vincent

We are still having problems with 7.5.1. We now have a client side patch for the Designer. It is more stable but has other issues which they are working on. Let you know when we get it all fixed.
by kduke
Thu Apr 28, 2005 3:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command Stage
Replies: 6
Views: 1217

Switch it to routine stage and call ExecSH. you can use parameters with it.