Page 1 of 1
DB2 Connector
Posted: Mon Feb 02, 2015 2:14 pm
by naveen.p
Hi Experts,
Please help me with this weird scenario.
We are trying to load data from complex flat file to DB2 Table and we use DB2 Connector Stage with Update and Insert option.
There were 97 records as input but unable to find these records in the table.
There are no log information too.
Thanks,
Naveen
Posted: Mon Feb 02, 2015 3:51 pm
by ray.wurlod
Did you run the job? (Have to ask.)
Did the job itself report row counts into the DB2 Connector?
If 0, is there a constraint in the Transformer stage that might prevent the rows from being sent (I'm assuming here that you have a Transformer stage)?
Do you have a reject link for the DB2 Connector stage?
Posted: Mon Feb 02, 2015 4:32 pm
by naveen.p
Hi Ray,
Yes. Job ran successfully with no warnings.
DB2 Connector log information
Input 0 consumed 97 records.
Number of records inserted : 0
Number of records deleted : 0
Number of records updated : 0
Posted: Mon Feb 02, 2015 4:39 pm
by qt_ky
Back to Ray's questions: any Transformer constraint or DB2 reject link?
Posted: Mon Feb 02, 2015 4:46 pm
by naveen.p
Sorry...I missed that question.
There is no constraint before the data is loaded.
There is no reject link in DB2 connector stage.
Posted: Tue Feb 03, 2015 2:01 am
by vinothkumar
Can you see all records are passing to target in your designer window(through performace stats) . If yes, add a reject link to target connector stage and check. Also check in director log for any messages related to rejects.