Hi,
If your DB2 instance is on the same machine, use the App Driver
(COM.ibm.db2.jdbc.app.DB2Driver) and the JDBC url will be
"jdbc:db2:database"
If it is on a different machine, use the Net Driver
(COM.ibm.db2.jdbc.net.DB2Driver) and the JDBC url is
"jdbc:db2://host:port/database "
You need to run the Java listener and depending on it's port you can specify
the port.
db2jstrt [port] has to be run on the server machine. Run this if your
process list does not show db2jd running.
By default, the port is 6789.
Note that you can use the app driver when the db2 and client are on
different machines if you have installed and configured DB2's CAE.
For a straightforward installation on the same machine, both drivers will
work.
Could you please look at the web resources like the one below before asking
this question.
http://www-4.ibm.com/software/data/db2/java/
Also, a better place to ask such a question would be in one of the
newsgroups on
news://news.software.ibm.com
-- Aravind
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Murali Ravipudi
> Sent: Thursday, 1 June 2000 15:38
> To: [EMAIL PROTECTED]
> Subject: OT - DB2 connection params
>
>
> Hi all,
>
> Sorry for the OT msg, but I dont have anyone else to ask!!
> I am working with Websphere and VAJ with DB2.
> Trying to figure out the jdbc URL format and port number to give
> in the url
> for DB2.
> Particularly the port number... I did not give any port no when setting up
> DB2, so I searched the docs for any mention of the port number...
> but couldnt find any...
>
> any pointers/help...
>
>
> tia,
> Murali
>
> ==================================================================
> =========
> To unsubscribe, send email to [EMAIL PROTECTED] and include
> in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".