Hi,
We have a different problem with DSDB2PX Stage.
When I queiried from DB2 database, rowcount is 35 M.
but when i transferred with using DSDB2PX stage, rowcount is 33 M.
also there is no warning or another information on job log.
My job is like this.
DSDB2PX------->Transformer-------->Oracle
On DB2 there are 35M data but when i transferred it with datastage, rowcount is 33M.( this count is not only oracle tablse count, i saw the same number in the log )
DB2 Stage retrieves data less then database !
do you have an idea, how can it be ?
is there a limit for dsdb2px stage ?
DB2 v 9.5 on AIX
Datastage Enterprise wit PX 8.0 on AIX
Oracle 10g on AIX (Not important)
Less row count with DSDB2PX Stage
Moderators: chulett, rschirm, roy
My Select Query is:ArndW wrote:There is no limit in that sense in DataStage. What is your SELECT clause? Could rows be dropping from the Transform stage? ...
SELECT
DATE('01.' || RIGHT(DIGITS(AY),2) || '.' || RIGHT(DIGITS(YIL),4)) + 1 MONTH - 1 DAY AS DONEM,
MUSTERI_NO AS MUSTERI_NO,
URUN_KD_OR AS URUN_KODU,
SUM(VASATI) AS VASATI,
SUM(KAR) AS KAR,
SUM(FAIZ_GELIRI) AS FAIZ_GELIRI,
SUM(FAIZ_GIDERI) AS FAIZ_GIDERI
FROM
SMODEL.ABM_KAROZET_ABMTA
WHERE
YIL = #YIL#
AND
AY = #AY#
GROUP BY
DATE('01.' || RIGHT(DIGITS(AY),2) || '.' || RIGHT(DIGITS(YIL),4)) + 1 MONTH - 1 DAY,
MUSTERI_NO,
URUN_KD_OR
;
This query returns 35M rows on Toad for DB2,
same query on datastage , DSDB2PX Stage retrieves 33M.
All links have 33M rows
There is not any reject or dropping row.
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia