Solved

URGENT: DB2 connect problem

Posted on 2013-12-27
1
4,593 Views
Last Modified: 2014-01-03
Hi experts,
my db2 client is installed in the directory C:\DB2INST:

(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.8

I've problems to connect to the database DB2 from SQL Developer, below are the steps that I have done:

- I added (in SQL Developer) the following jdbc driver from the directory C:\DB2INST\java
db2jcc4.jar
db2jcc.jar
db2jcc_license_cisuz.jar
db2jcc_license_cu.jar

- These are the connection parameters that I used:
Hostname: test.local
Port: 1600
Dbname: TESTDB2
Username: test
password: test

Test connection: Status: Success

BUT when I try to blow up the connection to view the tables I get the following errors:

An error was encountered performing the requested operation:
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=3.64.114
Vendor code -204

An error was encountered performing the requested operation:
DB2 SQL Error: SQLCODE=-516, SQLSTATE=26501, SQLERRMC=null, DRIVER=3.64.114
Vendor code -516

An error was encountered performing the requested operation:
DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.64.114
Vendor code -514


also if I try to run the query: SELECT * FROM SYSCAT.SCHEMATA; I get these errors:
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=3.64.114


Anyone have any idea how I can fix this connection problem?

Thanks in advance!
0
Comment
Question by:ralph_rea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 57

Accepted Solution

by:
giltjr earned 500 total points
ID: 39743090
Does the userid test have the needed access to query those tables?  I don't think that is a security issue, but you never know.  

Do you have any schema defined?

Below are what IBM's says the errors are.

According to:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fn204.htm

Means the object that is identified by name is not defined.

And a -516 means:

THE DESCRIBE STATEMENT DOES NOT SPECIFY A PREPARED STATEMENT

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fn516.htm
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Learn about cloud computing and its benefits for small business owners.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question