DataSource configuration guide

This page describes how to create the DB2 data source in WAS/WPS 6.0.2.
Step 1: Create the J2C authentication alias for the database

1 Login the WAS console, click "Security" - > "GlobalSecurity" -> "Authentication" -> "JAAS Configuration" -> "J2C Authentication data";
2 Click "New", input "MTPDBAuthAlias" as the "Alias", the database user name and password in "User ID" and "Password" feilds, for example "db2admin" and "db2admin" are the user id and password of our local database;

Step 2: Create the DB2 JDBC Provider if there is no such one

1 Click "Resources" -> "JDBC Providers" in the left navigation bar; the existing JDBC providers will be listed;
2 If there has the JDBC provider for DB2 (such as "DB2 JDBC2-compliant Provider " or "DB2 Universal JDBC Driver provider"), then do not need to create it again, skip this step and go to "Step 3"; Otherwise continue;
3 Click "New" button; select "DB2" as Database type, "DB2 Universal JDBC Driver provider" as Provider type, "Connection pool data source" as Implementation type.
4 Click "Next", this page shows the path of the DB2 JDBC driver; The path is defined with the variable "DB2UNIVERSAL_JDBC_DRIVER_PATH";
5 Click "Finish", and then save the changes to the master configuration.
6 Click "Environment" -> "WebSpehre variables" in the left navigation bar; find the value of viarable "UNIVERSAL_JDBC_DRIVER_PATH"; make sure the value is the correct location that DB2 driver jar/zip files exist; for example "C:\IBM\SQLLIB\java";

Step 3: Create the Data source

1 Click "Resources" -> "JDBC Providers" in the left navigation bar; the existing JDBC providers will be listed;
2 Click the DB2 JDBC driver that you just created or has existed, then click the "Data sources" link;
3 Click "New" button, input "MTPDS" as the name, "jdbc/MTPDS" as the "JNDI name"; in the drop down list "Component-managed authentication alias", select "yourNodeName/MTPDBAuthAlias"; in "Database name", input the name of the database: "MTPDB";
4 If the driver is of JDBC type 4 ("DB2 Universal JDBC Driver provider"), you also need to input the server name and port number, like "localhost" and "50000";
5 Click "Save" to save the settings, and then save the changes to the master configuration.
Step 3: Test the data source

1 Click "Resources" -> "JDBC Providers" in the left navigation bar; the existing JDBC providers will be listed;
2 Click the DB2 JDBC driver that you just created or has existed, then click the "Data sources" link;
3 Select "MTPDS", and then click "Test connection" button. The result will be shown, if the test is failed, go back again to check if there is anything wrong.