To configure DB2, you need to:
IBM WebSphere Application Server V4.0 requires JDBC 2.0, whereas the default installation of IBM DB2 V7.2.1 uses JDBC 1.2. To update the DB2 JDBC level, complete the following steps:
- Stop the DB2 JDBC Applet Server Windows service:
- Open a Services window by clicking Start>Settings>Control Panel>Administrative Tools>Services. Then look for the "DB2 JDBC Applet Server" and stop it.
- Or, use this command:
D:\>net stop "DB2 JDBC Applet Server" - In a command window, change to the D:\SQLLIB\java12 directory where you installed DB2 and type the following command:
\SQLLIB\java12 \ >usejdbc2.batNote: If the output of usejdbc2 indicates that any of the files failed to copy successfully, then the JDBC2 update failed. If this occurs, stop all DB2 services and then repeat the steps above. If you see any "access denied" or "process cannot access..." errors and the JDBC Applet Server is indeed not running, then some other (non-DB2) process has locked the db2java.zip file.
- Start the DB2 JDBC Applet Server Windows service as follows:
- Either open a Services window by clicking Start>Settings>Control Panel>Administrative Tools>Services. Then look for the "DB2 JDBC Applet Server" and start it.
- Or, use this command:
D:\>net start "DB2 JDBC Applet Server" - Check the contents of the D:\SQLLIB\java12\inuse file. If JDBC 2.0 is being used, the file will contain JDBC 2.0.
Configure the TCPIP communication mode
The DB2 server might need to be reconfigured to use TCP/IP as its primary communication method:
- Open a DB2 command window by clicking Start>Programs>IBM DB2>Command Window.
- Check whether TCPIP is the current DB2 communication method. The following command should return a value of TCPIP:
D:\>db2set DB2COMM. - The output should show TCPIP as one of the protocols. If not, reset the DB2COMM DB2 environment variable:
D:\>db2set DB2COMM=TCPIP. - Close the DB2 command window.