DB2 Connector Internals

SwathiCh · Post by **SwathiCh** » Tue Apr 29, 2014 4:18 pm

Hi All,

Can any one help me how DB2 or Oracle Connector stages work on Backend? Manual is saying it is using APIs but not mentioned what APIs it is really calling for DB2?

I see on DB side, it is triggering some packages/procedures when I run the job but any one having the list of all procedures it calls when we try to Insert/Update/Delete on DB from DB2 connector?

Thanks..

ray.wurlod · Post by **ray.wurlod** » Tue Apr 29, 2014 6:03 pm

You will get some idea by downloading some of the other Connector stage types from developerWorks - some of them even include source code.

From memory, the DB2 API is very similar to the ODBC API.

SwathiCh · Post by **SwathiCh** » Wed Apr 30, 2014 8:11 am

Thanks Ray for Information.

I searched IBM.DeveloperWorks to find the APIs, but I couldn't find any.

Can you route me to the page from where can I download APIs?

And also may I know where can I find ODBC API information...Thanks.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 30, 2014 4:43 pm

The ODBC API is published by Microsoft Corporation. I'll have to research the link to developerWorks - don't have it with me.

nagikondaveti · Post by **nagikondaveti** » Thu May 01, 2014 10:40 am

Ray,
Is there any way to edit stages like DB2 connector?

Example, logging property set to NO by default. I would like to change it to YES so that my developers dont have to change it every time when they create new jobs.

ray.wurlod · Post by **ray.wurlod** » Thu May 01, 2014 3:06 pm

I don't believe there is any way to change default property settings in out-of-the-box stages (in general - though the Sequential File stage does allow default format to be selected).

SwathiCh · Post by **SwathiCh** » Fri May 02, 2014 12:31 pm

Thank you Ray for the Information.

I verified the ODBC API's code. It looks like we are calling Java classes on backend from connector stages.

So If I have 4 node configuration file, then each session will create a separate java class instance and that java instance process the data row by row it receives from ETL job?? Or is there any buffer collector which collect all data from ETL job by session and invoke java class to process all data at once?