By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Db2jdbcBind

P: n/a
Hello,

I encounter problems with a java application which connects to DB2.
The problem only occurs with DB2 v7, in v8 all is fine. I know that
I think that I can solve my problem using "db2jdbcbind", but I am
not able to find this executable.

Could you indicate me where I can find it ?

Thanks in advance,

Jean-marc Noury

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
It's in sqllib/bin directory of a DB2 v8.x client or server
installation...

Dario

Nov 12 '05 #2

P: n/a
"Dario" <db*****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
It's in sqllib/bin directory of a DB2 v8.x client or server
installation...


Hi Dario,

thank you very much for your reply. Actually, this
is also what i thought, but unfortunately, my sqllib/bin directory
(DB2 V8.1) does not contain this executable :-(
(Installation done on a Win32 environment)

Is it possible that this executable only comes with a certain fixpack,
not installed on my machine ?

Do you know a way where I can find this executable (win32 version)?

Thanks;

Jean-marc

Nov 12 '05 #3

P: n/a
"jean-marc" <aa@BB.com> wrote in message
news:43***********************@news.skynet.be...
"Dario" <db*****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
It's in sqllib/bin directory of a DB2 v8.x client or server
installation...


Hi Dario,

thank you very much for your reply. Actually, this
is also what i thought, but unfortunately, my sqllib/bin directory
(DB2 V8.1) does not contain this executable :-(
(Installation done on a Win32 environment)

Is it possible that this executable only comes with a certain fixpack,
not installed on my machine ?

Do you know a way where I can find this executable (win32 version)?


Me again
If someone could send me this executable, it would be very nice.

(no_spam_)jm******@viveo-cognitive-systems.com
Jean-marc Noury
Nov 12 '05 #4

P: n/a
Looking at the online DB2 Infocenter seems "db2jdbcbind" was introduced
with FP1.
Reading the DB2 docs:

"...
JDBC and CLI share the same packages. If the CLI packages have already
been bound to a database, then it is not necessary to run this utility
and vice versa.
...."

Now you can try different options:

1. Bind your db2 v8 client to your v7 server.
2. Apply the last FP (FP10) and use db2jdbcbind utility.
3. Use the new Type 4 JDBC Drivers (db2jcc.jar, db2jcc_license_cu.jar)
and bind your driver using:

java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://server:port/database
-user user-ID -password password

Yo can download T4 drivers from:
http://www14.software.ibm.com/webapp...0W42&S_CMP=&s=
Hope this help,
Dario

Nov 12 '05 #5

P: n/a
"Dario" <db*****@gmail.com> a écrit dans le message de
news:11*********************@z14g2000cwz.googlegro ups.com...
Looking at the online DB2 Infocenter seems "db2jdbcbind" was introduced
with FP1.
Reading the DB2 docs:

"...
JDBC and CLI share the same packages. If the CLI packages have already
been bound to a database, then it is not necessary to run this utility
and vice versa.
..."

Now you can try different options:

1. Bind your db2 v8 client to your v7 server.
2. Apply the last FP (FP10) and use db2jdbcbind utility.
3. Use the new Type 4 JDBC Drivers (db2jcc.jar, db2jcc_license_cu.jar)
and bind your driver using:

java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://server:port/database
-user user-ID -password password

Yo can download T4 drivers from:
http://www14.software.ibm.com/webapp...0W42&S_CMP=&s=


Hi Dario,

Thank you very much, this was indeed very helpfull. I did use
option 3 and this solves my problem!

Once again, many thanks :-)

Kind regards,

--
Jean-marc

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.