URGENT: DB2 connect problem

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!
ralph_reaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
giltjrConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.