DB2 Connector

naveen.p · Post by **naveen.p** » Mon Feb 02, 2015 2:14 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 02, 2015 3:51 pm

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?

naveen.p · Post by **naveen.p** » Mon Feb 02, 2015 4:32 pm

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

qt_ky · Post by **qt_ky** » Mon Feb 02, 2015 4:39 pm

Back to Ray's questions: any Transformer constraint or DB2 reject link?

naveen.p · Post by **naveen.p** » Mon Feb 02, 2015 4:46 pm

Sorry...I missed that question.

There is no constraint before the data is loaded.

There is no reject link in DB2 connector stage.

vinothkumar · Post by **vinothkumar** » Tue Feb 03, 2015 2:01 am

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.