Solved

URGENT: DB2 connect problem

Posted on 2013-12-27
1
4,201 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 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 Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now