Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

URGENT: DB2 connect problem

Posted on 2013-12-27
1
Medium Priority
?
4,732 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 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Learn about cloud computing and its benefits for small business owners.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

721 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