Verifying the DB2 CAE installation
Once the DB2 CAE has been installed, verify it is working as follows:
1. Log in as the DB2 instance owner, db2inst1.
2. Access the SAMPLE database in the backend server with the following
commands in the order presented:
db2 catalog tcpip node bdtest3 remote 9.3.240.222 server 50000
db2 catalog database sample at node bdtest3
Figure 41 shows the result of running these commands.
[db2inst1@bdtest2 db2inst1]$ db2 catalog tcpip node bdtest3 remote
9.3.240.222 server 50000
DB20000I The CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is refreshed.
[db2inst1@bdtest2 db2inst1]$ db2 catalog database sample at node
bdtest3
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is refreshed.
Figure 41. Cataloging the SAMPLE database on the front end server
3. Verify the connection with the
db2 connect
command as follows:
db2 connect to sample user db2inst1 using ibmdb2
4. Finally, verify that an SQL select statement works by issuing the following
command:
db2  select * from department 
See Figure 10 on page 18 for a example of the result set for this query.
Modifying IBM WebSphere configuration files
We must add the DB2 classpath for db2java.zip to the WebSphere
Java.classpath parameter. Do this as follows:
1. The boostrap.properties file is located on the front end server in directory
/opt/IBMWebAS/properties.
2. Log on as root, edit this file, and find the following entry:
Java.classpath
3. Add the following path to this entry:
/usr/IBMdb2/V6.1/Java/db2Java.zip
Chapter 2. Setup and configuration
47




  

Home

About Services Network Support FAQ Order Contact
 

Linux Web Hosting

Our partners:Jsp Web Hosting Unlimited Web Hosting Cheapest Web Hosting  Java Web Hosting Web Templates Best Web Templates PHP Mysql Web Hosting Interland Web Hosting Cheap Web Hosting PHP Web Hosting Tomcat Web Hosting Quality Web Hosting Best Web Hosting  Mac Web Hosting 

Lunarwebhost.net  Business web hosting division of Vision Web Hosting Inc. All rights reserved