Testing the connection to the database

How to test the connection to your database.

About this task

After you have created a data source and connection pool, and set the custom properties, test the connection to your database.

To test the connection to your database:

In the Integrated Solutions Console, open Resources > JDBC and click Data sources.
Select the check box next to the data source you want to test and click Test connection.
The status of the connection is indicated at the top of the screen.
Potential connection errors might be:
- Java class ..com.ibm.db2.jcc is not found
  Check that the jcc drivers classpath is correctly set.
- Null Userid is not supported — SQL ERRORCODE 4461
  Authentication has failed. Check that the JAAS-J2C Authentication credentials are correct.