Tuesday, July 11, 2006

DB2 Solaris db2profile and usejdbc2

e.g. DB2 instance db2inst1

To use JDBC 2.0, in the /export/home/db2inst1/.profile

add ". /export/home/db2inst1/sqllib/java12/usejdbc2".

the usejdbc2 script has some bug, remove these lines related to AIX and HP-UX.

For user "replica" to connect to db2 databases via JDBC, in the /export/home/replica/.profile, add

# The following three lines have been added by UDB DB2.
if [ -f /export/home/db2inst1/sqllib/db2profile ]; then
. /export/home/db2inst1/sqllib/db2profile
. /export/home/db2inst1/sqllib/java12/usejdbc2
fi

No comments: