asked on

DB2 v8.1: Can't find usejdbc2 script

I can't find the script usejdbc2. I installed DB2 and created an instance: ./db2icrt -u adm instance. Then I ran the script, db2profile, to set the environment variables. The next step was to run the script usejdbc2 to append the paths with the correct driver for DB2. This is suppose to be located in /sqllib/java12, but it isn't. I've tried to search for the source code or a downloadable script, but came up empty. I checked the CLASSPATH, and it is pointing at the directory /sqllib/java/db2java.zip, and it needs to be ../java12/db2java.zip. Does the script just change that path to point to /sqllib/java12/db2java.zip?

ASKER CERTIFIED SOLUTION

pluim

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pretzyl1

ASKER

That's what I ended up doing and didn't get any problems. So you just reassured that what I am doing is right. Thanks.

Next problem :-) ...

I am using cygwin to setup DB2 and am having a little problem. First I right-click "systems" and add a new server. Once I do that, I right-click the server name and click "attach". It then prompts me for the Database Administrator name and password. I am assuming it is the instance user's name and password. Even if it isn't, I tried all the ones I could think of, so the name and password aren't the issue (unless there is something I am missing). Could I have configured DB2 incorrectly? I've tried all that I can think of, but will still try to google it more. Thanks for your help!