db2 JDBC - connect to informix

Posted in 2012

Topics: Connectivity: ODBC / JDBC / .NET

Cesar Inacio Martins — Fri, 07 Dec 2012 19:39:49 — source: IIUG Forums & Mailing Lists

Hi, Is possible use db2 JDBC to connect to Informix ? (ifx 11.50) The db2 driver what I download is v10.1fp1_jdbc_sqlj.tar.gz I want to connectto Informix using db2 driver into sql client toolwhat don't have support to Informix, just db2. I don't want use Optim Studio becauseisn't good... and Server Studio priceis high...

↪ replying to Cesar Inacio Martins

Art Kagel — Fri, 07 Dec 2012 19:44:34 — source: IIUG Forums & Mailing Lists

You can certainly connect using DB2s DRDA protocol and the DB2 JDBC driver. You will have to configure an sqlhosts entry for drda protocol (ondrsoc IB, but look in the Administrator's Guide to be sure) on a separate port from the one used for Informix native (SQLI) protocol. That does not mean that whatever server management/admin tool from db2 you are trying to use will actually be able to do anything, however, due to the difference in schema, catalog table structure, admin tools and protocols, etc. but it's worth a try. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 7, 2012 at 2:39 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi, > > Is possible use db2 JDBC to connect to Informix ? (ifx 11.50) > The db2 driver what I download is v10.1fp1_jdbc_sqlj.tar.gz > > I want to connectto Informix using db2 driver into sql client toolwhat > don't have support to Informix, just db2. > > I don't want use Optim Studio becauseisn't good... and Server Studio > priceis high... > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340ef1af8cf704d048710f

↪ replying to Art Kagel

Cesar Inacio Martins — Mon, 10 Dec 2012 10:13:33 — source: IIUG Forums & Mailing Lists

Thanks Art , I forgot to mention before... I desire avoid include a drda listener, what I believed isn't possible. Right? On 7/12/2012 17:44, Art Kagel wrote: > You can certainly connect using DB2s DRDA protocol and the DB2 JDBC > driver. You will have to configure an sqlhosts entry for drda protocol > (ondrsoc IB, but look in the Administrator's Guide to be sure) on a > separate port from the one used for Informix native (SQLI) protocol. > > That does not mean that whatever server management/admin tool from db2 you > are trying to use will actually be able to do anything, however, due to the > difference in schema, catalog table structure, admin tools and protocols, > etc. but it's worth a try. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Fri, Dec 7, 2012 at 2:39 PM, Cesar Inacio Martins < > cesar_inacio_martins@yahoo.com.br> wrote: > >> Hi, >> >> Is possible use db2 JDBC to connect to Informix ? (ifx 11.50) >> The db2 driver what I download is v10.1fp1_jdbc_sqlj.tar.gz >> >> I want to connectto Informix using db2 driver into sql client toolwhat >> don't have support to Informix, just db2. >> >> I don't want use Optim Studio becauseisn't good... and Server Studio >> priceis high... >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --14dae9340ef1af8cf704d048710f > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Art Kagel

Art Kagel — Mon, 10 Dec 2012 10:43:51 — source: IIUG Forums & Mailing Lists

Correct. Art On Dec 10, 2012 5:13 AM, "Cesar Inacio Martins" < cesar_inacio_martins@yahoo.com.br> wrote: > Thanks Art , > > I forgot to mention before... I desire avoid include a drda listener, what > I believed isn't possible. > Right? > > > On 7/12/2012 17:44, Art Kagel wrote: > > You can certainly connect using DB2s DRDA protocol and the DB2 JDBC > driver. You will have to configure an sqlhosts entry for drda protocol > (ondrsoc IB, but look in the Administrator's Guide to be sure) on a > separate port from the one used for Informix native (SQLI) protocol. > > That does not mean that whatever server management/admin tool from db2 you > are trying to use will actually be able to do anything, however, due to the > difference in schema, catalog table structure, admin tools and protocols, > etc. but it's worth a try. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Fri, Dec 7, 2012 at 2:39 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > > > Hi, > > Is possible use db2 JDBC to connect to Informix ? (ifx 11.50) > The db2 driver what I download is v10.1fp1_jdbc_sqlj.tar.gz > > I want to connectto Informix using db2 driver into sql client toolwhat > don't have support to Informix, just db2. > > I don't want use Optim Studio becauseisn't good... and Server Studio > priceis high... > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > --14dae9340ef1af8cf704d048710f > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --14dae9340bef7b3b6404d07d3da9