DB2 2.1.2 via Java, in a distributed environment 
Author Message
 DB2 2.1.2 via Java, in a distributed environment

I'm trying to get an app to be able to randomly access one of close to 300
installations of this version of DB2, usnig Java/JDBC.  My DBA tells me
that the only way to do that is by entering all the nodes as aliases in the
CAE.  It's logistically impractical to do that, though, given the wide
distribution of this application.

I had thought about writing a C interface between the Java call and the
connection to the remote dbs.  However, I don't know if that would also
require that CAE be installed, or just some run-time libraries.  The desire
is to be able to make a direct connection to the remote db on port whatever
(3700? 3701?), and execute the dynamic SQL.  A major obstacle with that,
however, is that the SDK we licensed from IBM is fror OS/2, and teh app
needs to run on Windows. :(

Does anyone have any ideas on how this may be done?  Our current mechanism
is to use rexec to access the remote node and execute a dbmucmd on it, and
parse the results..  This is, of course, an unsatisfactory method which I
would like to dispense with.  We are *scheduled* to move to v5.2, but when
that would happen is anybody's guess.

Matthew Vanecek
perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
For 93 million miles, there is nothing between the sun and my shadow except
me. I'm always getting in the way of something...

Wed, 05 Mar 2003 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Distributed DB2 - Oracle/Oracle - Oracle/DB2 - DB2/DB2

2. Inserting date-Field in DB2 via the Data Environment designer in VB

3. distributed DB2 7.2 installation over existing DB2 6.1 fails

4. Oracle/XA + Java [was: Oracle: Java + distributed transactions (CORBA OTS + 2PC)]

5. ---JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA---

6. Accesing DB2 on 0S/390 via DB2 Connect

7. Access to DB2 for OS/390 via DB2 Connect

8. DB2 OS/390 crashing after connection via DB2 Connect

9. MO-ST LOUIS-99224--DB2-Java-JavaBeans-ORACLE-PL/SQL-Java P/A

10. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client

11. Using MSDE in a distributed environment

12. Distributed Environment

Powered by phpBB® Forum Software