Search found 6 matches

by Loobian
Mon Jul 03, 2006 12:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Levels of Sequences - Performance
Replies: 6
Views: 2373

Hi Craig, I'm sure about the P3/500 but you have 2GB instead of previous answer. I'm working in Windows and the only way i can determine the correct run sequence it's to create a several of sequence (increasing the number of sequence as a way to decrease simultaneous job executions); But, my guess i...
by Loobian
Mon Jul 03, 2006 11:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Levels of Sequences - Performance
Replies: 6
Views: 2373

Levels of Sequences - Performance

Hi Craig, We are talking about 20 jobs tops, however in normal conditions we have about 3 to 5; The curious thing about it, is that when performed execute in director one by one (not the all set) they run just fine, but all at the "same time" performance goes down completely. I've broke se...
by Loobian
Mon Jul 03, 2006 11:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Levels of Sequences - Performance
Replies: 6
Views: 2373

Levels of Sequences - Performance

Hi all, Is there any relation to the number of sequences inside another sequences and slow performance? I've a major sequence who controls severals levels of sequences below, in some cases up to 6 levels can this compromise performance? example ("S_" means sequence): 1. S_global 1.1 S_1.te...
by Loobian
Thu Apr 13, 2006 7:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Qtd Limits
Replies: 10
Views: 5220

Hi, My "S" directory is on the network. The job is about loading from one hash file at the same directory(!), then it performs a couple of lookups and output the result to both informix table (works fine) and another hash in that (same) directory (abort). I find it hard to understand, my f...
by Loobian
Thu Apr 13, 2006 5:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Qtd Limits
Replies: 10
Views: 5220

Hi ArndW, At the time this error occurs, i've already created about 200 hash in the same directory/with various method (standard/not standard - altering the min modulus atribute with various values). So i'm not suspecting of window drives... could it be cache limits? Thanks I've never encountered th...
by Loobian
Wed Oct 26, 2005 2:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File update
Replies: 5
Views: 2141

Hash File update

Hi all, I want to create an hash file with 3 fields but only one key. I also want that every time i load records into the hash, if the key's already there, no insertions/update will be made. i want to keep loading records and maintain the first (distinct) record (without modification) per key in the...