This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Problem while connecting to db2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic

Problem while connecting to db2

Prema Durai

Joined: Aug 27, 2009
Posts: 10
While connecting to db2 from the WAS admin console , following error occurs:

The test connection operation failed for data source Agcy Dwld DS on server server1 at node cvdxe106429-027Node04 with the following exception: java.sql.SQLException: DB2 SQL error: SQLCODE: -5042, SQLSTATE: , SQLERRMC: ;1208;N4EACE ;TDH1;QDB2; ; ; ;1208; ;DSRA0010E: SQL State = , Error Code = -5,042. View JVM logs for further details.

How could this be resolved
Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

Prema, you already posted this question in the Websphere forum. One copy of a question is enough. I'm closing this.
I agree. Here's the link:
subject: Problem while connecting to db2
Similar Threads
DB2 SQL error: SQLCODE: -8002
Problem while connecting to db2
Problem connecting to DB2 using Squirrel Database Client
Error Connecting To DB2
Not connecting to SQL*plus