acceessing Mainframe DB2 database by using DB2 stage

mallikharjuna · Post by **mallikharjuna** » Mon Mar 08, 2010 2:52 pm

Hi,

is it possible to acceess Mainframe DB2 database by using DB2 stage.if possible please explain how to do?

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Mar 08, 2010 4:12 pm

That's basically the correct answer. The DB2/UDB Enterprise stage only supports DB2 on the same platform type. If you want to go to AS/400 or mainframe you need the DB2 API stage (which is why it still exists in parallel jobs).

In version 8.1 the DB2 Connector stage allegedly works to other platform types, but I have not seen this in operation so can not comment.

dsedi · Post by **dsedi** » Mon Mar 08, 2010 4:32 pm

Ray Thanks for the clarification. Appreciate that.

mallikharjuna · Post by **mallikharjuna** » Mon Mar 08, 2010 11:45 pm

Thanks dsedi and Ray

mallikharjuna · Post by **mallikharjuna** » Tue Mar 09, 2010 2:31 pm

is it possible to connect by using ODBC?

bobyon · Post by **bobyon** » Fri Jul 16, 2010 8:58 am

Yes, it is possible to access mainframe DB2 tables with and ODBC stage. Just be sure you have setup the .odbc.ini and uvodbc.config files correctly.