Hello,

I've a question concerning connecting to a AIX DB2 7 from a WebSphere
for OS/390 V4 application server. Today the application server only
connects to a local DB2 7 on the same LPAR. But now we have to
integrate a database running on AIX.

We understand that with the standard DB2 V7 for OS/390 JDBC-Driver a
remote connection to a AIX database isn't possible. So we thought
about using the DB2 V8 Type-4 JDBC-Driver additionally. But we think
that isn't possible, too, because

- In the WebSphere for z/OS documentation we found the note, that
coexistence between the db2j2classes.zip (old driver) and db2jcc.jar
(new type 4 driver) isn't possible. Additionally we don't think that
it's possible to connect to a DB2 V7 with the DB2 V8 driver.

- In the document "Assembling Java™ 2 Platform, Enterprise Edition
(J2EE™) Applications" in chapter 16 we found the note that with any
type 4 JDBC-driver two-phase-commit-protocol isn't supported. We need
2PC.

It's hard to believe that a connection is not possible. We also
thought about integrating the two databases on the database tier with
the "distributed data facility" of DB2 V7 for OS/390. But we did not
found a clear statement in the documentation if this is possible.

Additionally we came across RmiJdbc (see
http://rmijdbc.objectweb.org/). Has somebody experience in using this
open source product, especially on OS/390 and with two-phase-commit?

Thank you very munch in advance and kind regards,
Frank

[ Post a follow-up to this message ]

I believe that the StarSQL for Java JDBC driver should allow you to do what
you want, but you'd better check that directly with the vendor
(www.starquest.com). It does support 2PC.



Bob



"Frank Engelen" <frank.engelen@gmx.de> a écrit dans le message de
news:1cb4a8b.0405280037.14901aec@posting.google.com...
> Hello,
>
> I've a question concerning connecting to a AIX DB2 7 from a WebSphere
> for OS/390 V4 application server. Today the application server only
> connects to a local DB2 7 on the same LPAR. But now we have to
> integrate a database running on AIX.
>
> We understand that with the standard DB2 V7 for OS/390 JDBC-Driver a
> remote connection to a AIX database isn't possible. So we thought
> about using the DB2 V8 Type-4 JDBC-Driver additionally. But we think
> that isn't possible, too, because
>
> - In the WebSphere for z/OS documentation we found the note, that
> coexistence between the db2j2classes.zip (old driver) and db2jcc.jar
> (new type 4 driver) isn't possible. Additionally we don't think that
> it's possible to connect to a DB2 V7 with the DB2 V8 driver.
>
> - In the document "Assembling JavaT 2 Platform, Enterprise Edition
> (J2EET) Applications" in chapter 16 we found the note that with any
> type 4 JDBC-driver two-phase-commit-protocol isn't supported. We need
> 2PC.
>
> It's hard to believe that a connection is not possible. We also
> thought about integrating the two databases on the database tier with
> the "distributed data facility" of DB2 V7 for OS/390. But we did not
> found a clear statement in the documentation if this is possible.
>
> Additionally we came across RmiJdbc (see
> http://rmijdbc.objectweb.org/). Has somebody experience in using this
> Open Source product, especially on OS/390 and with two-phase-commit?
>
> Thank you very munch in advance and kind regards,
> Frank

[ Post a follow-up to this message ]

Configure the Local DB2 on OS/390 communication database to connect
to DB2 UDB on AIX. Once done, you should be able to access the DB2
on AIX as if it was local.

Sunit

"Frank Engelen" <frank.engelen@gmx.de> wrote in message
news:1cb4a8b.0405280037.14901aec@posting.google.com...
> Hello,
>
> I've a question concerning connecting to a AIX DB2 7 from a WebSphere
> for OS/390 V4 application server. Today the application server only
> connects to a local DB2 7 on the same LPAR. But now we have to
> integrate a database running on AIX.
>
> We understand that with the standard DB2 V7 for OS/390 JDBC-Driver a
> remote connection to a AIX database isn't possible. So we thought
> about using the DB2 V8 Type-4 JDBC-Driver additionally. But we think
> that isn't possible, too, because
>
> - In the WebSphere for z/OS documentation we found the note, that
> coexistence between the db2j2classes.zip (old driver) and db2jcc.jar
> (new type 4 driver) isn't possible. Additionally we don't think that
> it's possible to connect to a DB2 V7 with the DB2 V8 driver.
>
> - In the document "Assembling JavaT 2 Platform, Enterprise Edition
> (J2EET) Applications" in chapter 16 we found the note that with any
> type 4 JDBC-driver two-phase-commit-protocol isn't supported. We need
> 2PC.
>
> It's hard to believe that a connection is not possible. We also
> thought about integrating the two databases on the database tier with
> the "distributed data facility" of DB2 V7 for OS/390. But we did not
> found a clear statement in the documentation if this is possible.
>
> Additionally we came across RmiJdbc (see
> http://rmijdbc.objectweb.org/). Has somebody experience in using this
> Open Source product, especially on OS/390 and with two-phase-commit?
>
> Thank you very munch in advance and kind regards,
> Frank

[ Post a follow-up to this message ]