I created this guide to help people prepare for connecting to DB2 Express from WAS 8.x

http://www-01.ibm.com/software/data/db2/express/

gunzip db2_v101_linuxia32_expc.tar.gz

tar -xvf db2_v101_linuxia32_expc.ta

/var/apps/db2_install/expc

./db2setup

I just used password since this is a lab

I used password again

I used password again

Click Finish

Installing IBM Data Studio

Now we are going to install the IBM Data Studio

gunzip ibm_data_studio_standalone_linux_V311.tar.gz

tar -xvf ibm_data_studio_standalone_linux_V311.tar

Running the IBM Data Studio Admin Client

cd /opt/IBM/DSAC3.1.1

./datastudio

In local VM this option crashed with a core dump? Must be something to do with Java/browser?

Anyway I then decided to install the SAMPE data base using command line tools

ftp://ftp.software.ibm.com/software/data/db2/express-c/wiki/GettingStartedwithDB2Express-C_V95-en.pdf

Login into the Linux machine as dbinst1 with an X11 session

Run the first steps console to create the SAMPLES Database

file:///opt/ibm/db2/V10.1/doc/prodcd/en_US/first_steps/FS_welcome.html

Preparing for a DB” JDBC Provider in WAS 8.x

Path to the DB2 Client Libraries: by default these libraries are in /opt/ibm/db2/V10.1/java on the server where you installed DB2 Express. WebSphere Application Server will need db2jcc.jar, db2jcc_license_cu.jar.

Creating a JDBC Provider in WAS 8.x

We presume you have installed WebSphere Application Server 8.x

Edit the class path

${DB2_JCC_DRIVER_PATH}/db2jcc4.jar

${DB2_JCC_DRIVER_PATH}/db2jcc_license_cu.jar

Click Apply, then Next

Click Finish, then Save

Result …

Create a J2C Alias for use with the Datasource

We need o remember that DB” uses operating system users. I used db2inst1 as this is the user we used earlier to create the SAMPLE DB2 database using the First Steps Console.

We can create more users later as required, this will be covered in another article.

Result after saving

Create JDBC Datasource using the J2C Alias

I have chosen to use Cell scope as my nodes are not runnining my WAS ND Cell, and I just want to test connectivity to the drivers

Click Finish and then Save

Test connection…

This error was because me modified the class path, but did not allow the wizard to create the Was variables.

If we look at the provider again we can see that the class path refers to ${DB2_JCC_DRIVER_PATH} we need to create the variable at call cope.

We can see it is blank, due to the way I edited in the wizard. The reason for this is that when WAS is shipped it presumes that certain other products such as DB2 (non express) are used by default and so we need to always setup the provider to suit open-source or express type situations.

Let us update the variable with the correct path. Typically this is : /opt/ibm/db2/V10.1/java for DB2 Express C

/opt/ibm/db2/V10.1/java

Click Apply and Save

Re-test Datasource

The test connection operation failed for data source DB2 SAMPLE DB on server dmgr at node Cell01Dmgr01 with the following exception: java.sql.SQLInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.13.127] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4,214. View JVM logs for further details.

This is because I made a spelling in my J2C alias it should have been db2inst1 not dbinst1.

Once corrected we get a successful test

Reference:

http://blog.webspheretools.com/2012/10/27/installing-db2-express-websphere-application-server-8-5/

http://tldp.org/HOWTO/DB2-HOWTO/planning.html#AEN205

http://publib.boulder.ibm.com/infocenter/dstudio/v3r1/index.jsp?topic=%2Fcom.ibm.datatools.ds.release.doc%2Ftopics%2Fgetstarted.html

http://edin.no-ip.com/blog/hswong3i/db2-express-c-10-1-ubuntu-12-04-howto

Facebooktwittergoogle_plusredditpinterestlinkedinmail

Leave a Reply