DSXchange

Well, even if you copy the file containing the log, you won't be able to exploit it or read it. It is write in Basic Universe format.

What do you want to do more precisely.

Martin.

You cannot compare two dates in a filter. Use a transformer and the fonction DaySinceFromDate(date1,date2)

You can compare 2 dates in a filter stage only if the second date is explicitly specify. ex : DaySinceFromDate(date1,'2009-02-27')

Martin

APT_CombinedOperatorController group two or more process in an unique operator.

Does your two instance of the job treats a similar number of rows ?

Martin.

Well, I have a problem, and I have no idea where it could come from. A DB2 Enterprise Stage read a table. The table contains dates. When I do a view data, all the dates are '1901-01-01' the default value. but when I do a CAST(column AS CHAR(10)), I obtain the good value but in the format 'MM/DD/YYYY...

In order to have better design of the job.. 1. There is join stage in the job...It is advised that is you are having huge unsorted data, u can use lookup stage.. ( of course ..here the other link where you are putting the join should have less rows which can fit in your physical memory or performan...

Hi, A job cause me a huge grief because of the use of sorts. I explain me : In my job, I have a input with a huge numbers of lines ordered by col1. Then, i make an inner join and an agregation on col1,col2,col3,col4. So i use a sort stage (key sort col1,col2,col3,col4) with col1 previously sorted. S...

Hi,

I want to use the PreviousWeekdayFromDate function, but when I compile the routine I have the following error :
"Array 'PreviousWeekdayFromDate' never dimensioned"

Do you have any idea ?
Have i forgot an include in my routine ?

thanks,

Martin.

Hi, I developped a routine to audit the execution of a sequencer. So, this routine, get all jobs and determine jobs that ran. For this jobs, I check the logs to display warning and fatal error in a file. this is classical. But when I developped and test this routine, It took 2 minutes. Today this ro...

Have you exactly the same key in the same order. I mean the same fields AND the same order ? This warning said much more that you could think. First, this warning means that your logic of traitement is wrong (your sorts) , but Datastage can correct it. It means that the work is not done correctly or...

Hi,

The configuration of datastage is DATASTAGE + FEDERATION SERVER

The connection to DB2 database was maded by DB2 UDP Enterprise Stage. But this stage is not supported by federation server, so I have to use the DB2 UDP API stage.

Can i use the RCP in this stage ?

thanks,
Martin.

Hi,

I know it was a old post, It was exactly the probleme I have.


I don't understand the instruction 6 : "source the dsenv" what does it mean?
What do I have to do ?

thanks,
Martin.

ok, so I try to use entire partitionning in input of the lookup and performance decrease, so I will keep the same partitionning and the warning.


ps : for the DS 7.6 version, the last post of this topic mentionned it (viewtopic.php?t=101149). Certainly, not PX.

Hi, I have a Datastage job design, like that or something like that : INPUT --> SORT+HASH PARTITION --> TRANSFORMER(partition : SAME, no sort) --> LOOKUP (partition : SAME, no sort) --> AGREGATION (partition SAME, no sort)--> OUTPUT First, I partition and sort data, and I want to keep the partition ...

Hi, i have a problem with an agregation. I need to agregate 400 billions rows to 2 billions rows and figure out 20 indicators. The performance are poor in Datastage because I must use the sort mode. (sort 400 billions rows, hum..!). So, I decide to extract, transform my data and load the rows in DB2...

Hello, I want to agregate a fact table (DB2 table). Basically, it will be that : Agregate Key (6 columns) sum(champ1) sum(champ2) max(champ3) max(champ4) min(champ3) min(champ4) count (distinct champ7) count (distinct champ8) In fact, there is 50 SUM, 10 MIN, 10 MAX and 2 COUNT DISTINCT. and the tab...