Create DB2 Data Source for WebSphere Application Server
How to create a DB2 Data Source for Websphere Application Server:
Step 1: Click on Resource -> JDBC -> JDBC Provider -> New
Confirm that the scope of the JDBC Connection is correct -> Node level.
Step 2: Complete the JDBC Provider Fields.
- Database type : DB2
- Provider type: DB2 Universal JDBC Driver Provider
- Implementation Type: XA data source
- Name: DB2 Universal JDBC Driver Provider (XA)
Click Next to complete the next step. Specify the class path to DB2, which will be at C:\IBM\SQLLIB\java
Step 3: Click Finish and confirm JDBC Provider was successfully created. Next step is to create the Data Source. Click on the new JDBC Provider and click on ‘Data Source’ and select ‘New’ to create a new Data Source. Below is the information that needs to be completed.
Step 6. Test Data Source Connection. Select Data Source and click ‘Test Connection’ button. Confirm connection was successful else check all fields.