DSXchange

hi !

I want before job to change reading cash from 128 mb to 1gb to use it for hash file reading and after job return it to 128 mb.

Is theris any way to do it ?

I tried and havnt finde anything

Write output : I remove the write stage Errors : I have 5% of rows are written in ErrorTable according to my logic Network/CPU : This is the only Job I run . I am still within development and dont have multiple job My cash is 256 mb . and enabling it isnt help . I still see the same thing : decreasi...

Hi !

I want to know if there is possibility to find out description of some results GetDSJobInfo returns .

For example , JOBSTATUS is returned as 2 . How to know what is the 2 ?

ArndW!!!

I did some checks and I found out that the overall job speed not depend on write target . I remove the write and still the speed decreasing from 2000 to 200 rows per sec.

Any ideas how to speed up it ?

Hi !

I want to build job that runs and create statistaics . For some jobs its write the rows are read or written to some links.

I want to do it after the some jobs are completed.

Is there is anyway to do it ? May be it was discussed as gie me link please.

You think that the bootlenck is the output or target stage?

Hi !

I have problem with reading speed from hash file.
I write it as Dynamic 30 General

When I use it The speed are high in the beginning and decrease rapidly so that i am affraid that it goes to 0.

I use 256 mb cash and the size of Hash is 2 GB

Does anybody can help me ?

How I need to define the key expression (L1.Col1 and L2.Col2) ?

I HAVE TWO COLUMNS Col1 and Col2 in one primary link. In Hash file I have Col3
I want to do lookup Col1 against Col3 and Col2 against Col3

May I to do it with one Hash ?

Yea I thought about it . My DBA said that data already sorted. May be it's not true ? You say If one row is not in order The aggregator is terminated ?

Its really help


I STILL NEED HELP

I want to execute BAT file within DS .I s there is any BASIC COmand for this ?

Hi !

Does anybody can help me . I want to call PGM DB2 routine , give it 4 parameters and get on result

Now I get another error

LoadDW_FACT_VISITS..AggregateVisits: Row out of sequence
At row 841992, link "LinkFromVA"
Row out of sequence