The following steps are only required for the first time deployment to the server:

1. Configure Environment Variables for DB2 Universal JDBC Drivers. From Admin Console, client Environment/WebSphere Variables. Make sure that the correct node is selected. Configure the following environment variables:

DB2UNIVERSAL_JDBC_DRIVER_PATH

UNIVERSAL_JDBC_DRIVER_PATH

2. Configure JDBC Providers: Click Resources/JDBC Providers. Make sure that the correct node is selected. If DB2 Universal JDBC Driver Provider is not already created, click New. From database type, select DB2. From provider type, select DB2 Universal JDBC Driver Provider. From implementation type, select “Connection Pool Datasource”. Click Next. Accept the default for Class Path and Native Library path. If the class name is not populated, enter “com.ibm.db2.jcc.DB2ConnectionPoolDataSource”.
3. Create J2C Authentication data: Click Security/Global security. Expand JAAS Configuration under Authentication on the right-hand-side. Click J2C Authentication data. Click new to create a new entry and set the follow parameters:

Alias:

Description:

User ID:

Password :

4. Create Data sources: From DB2 Universal JDBC Driver Provider screen, click “Data sources” under “Additional Properties”. Click New to create a new Datasource:

Name:

JNDI Name:

Component-managed authentication alias:

Fill the DB2 Universal data source properties with the information from prerequisite 3. Accept default for the rest of parameters.

Save the configuration. Click test connection to ensure that the DB2 connection is successful.

5. Deploy the enterprise application: Click Applications/Enterprise Applications. Click Install. Browse to the ear file and leave context root empty. Click Next. On override, select “Do not override existing bindings”. On Virtual Host, select “Use default virtual host name for web modules”. Enter the host name from prerequisite 1. Click Next. From installation options, do not pre-compile JSP. Select Distribute Application. Accept the default for the rest and click Next.
6. Map resource reference to Resources: The web service contains resource reference jdbc/Q2WSDatasourceReference. Clip MapResource reference to resources. Select the module, select the resource JNDI name from step 4, select user default method and select alias in step 2 in the authentication data entry.