?
Solved

URGENT: DB2 connect problem

Posted on 2013-12-27
1
Medium Priority
?
5,025 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
1 Comment
 
LVL 57

Accepted Solution

by:
giltjr earned 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Learn about cloud computing and its benefits for small business owners.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

601 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