Page 1 of 1
DB2 CONNECTOR - Without Cataloging
Posted: Mon Mar 30, 2015 11:50 am
by smile8work
Hi,
Is there any way that I can connect to DB2 databases without cataloging it in system just like how it works in the Oracle connector where even though you do not have a tnsentry but you will be able to connect to Oracle database.
Thanks
Rajan
Posted: Mon Mar 30, 2015 8:09 pm
by qt_ky
You could use the ODBC Connector stage with the ODBC DB2 wire protocol driver. It does not require a DB2 client to be installed, but it does require an ODBC data source to be defined in the .odbc.ini file.
I have heard that newer releases, such as DataStage 11.3.x, also allow for using JDBC connections. That may be another option, if true, although I'm not sure which stage type you may have to use with it.
Posted: Tue Mar 31, 2015 9:24 am
by AshishDevassy
ODBC connector.
But in order to do that you will need an entry in the ini file.
Re: DB2 CONNECTOR - Without Cataloging
Posted: Tue Mar 31, 2015 12:44 pm
by electajay
smile8work wrote:Hi,
Is there any way that I can connect to DB2 databases without cataloging it in system just like how it works in the Oracle connector where even though you do not have a tnsentry but you will be able to connect to Oracle database.
Thanks
Rajan
what is stopping you in doing cataloging ? its pretty simple and there is no way you can connect to db2 with out using odbc or db2 catalogging.
Re: DB2 CONNECTOR - Without Cataloging
Posted: Tue Mar 31, 2015 12:45 pm
by electajay
smile8work wrote:Hi,
Is there any way that I can connect to DB2 databases without cataloging it in system just like how it works in the Oracle connector where even though you do not have a tnsentry but you will be able to connect to Oracle database.
Thanks
Rajan
what is stopping you in doing cataloging ? its pretty simple and there is no way you can connect to db2 with out using odbc or db2 catalogging.