Creating a data datasource (JNDI) in RSA

1) Run Admin Console
2) Go to the "Environment" tab then "Websphere Variables"
3) Add "C:\Program Files\DB2\SQLLIB\java" to both DB2UNIVERSAL_JDBC_DRIVER_PATH and
DB2_JDBC_DRIVER_PATH. Save the changes.
db2jcc.jar, db2jcc_license_cu.jar, db2jcc_license_cisuz.jar need to be in this path
4) Resources ->JDBC ->JDBC Providers-> New
5) Specify the scope as "Node= WPWDCBRNode04, Server= serverl"

6) Fill out the following fields and then click next.
- Database Type- "DB2"
- Provider Type- "DB2 Universal JDBC Driver Provider"
- Implementation Type- "Connection pool data source"
- Name- "DB2 Universal JDBC Driver Provider"

7) Leave the fields blank and click next.

8) Review the summary page and then click "Finish"

9) Click Security> Secure administration, applications, and infrastructure.

10) Under Authentication, click Java Authentication and Authorization Service> J2C authentication data.

11) Create a new authentication alias and Fill out the fields "Alias", "User 10" and "Password" . Apply
and Save.

12) Click the JDBC Provider that was just created.

13) Once the page opens up, under "Additional Properties" click "Data sources" and then click "New"
(Or just go to Resources->JDBC->DataSources and click new to create new datasource. You will be given an option to choose the jdbc provider you created before.)

14) Under "JNDI Name" put "jdbc/testdb". Under component managed authentication alias, select the

previously created authentication alias.

15) Click "Next" and fill out the fields, click "Next" and then "Finish"

17) In the Data Source page go to "Custom Properties", then find the "current Schema" and change the

value to "TESTDBSCHEMA" then click "OK" and save your settings.