I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc.b.DisconnectException: The application server rejected
establishment of the connection. An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. What am I
missing? I0INTEST is a valid table as I can run a query against it in
DB2 Connect. I'm trying to establish a connection via SquirrelSQL as
well. 8 3740
On Feb 2, 9:17 am, cwhan...@gmail.com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc.b.DisconnectException: The application server rejected
establishment of the connection. An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. What am I
missing? I0INTEST is a valid table as I can run a query against it in
DB2 Connect. I'm trying to establish a connection via SquirrelSQL as
well.
You shouldn't specify any table name in your connection information.
As the error message says, the connection attempt is interpreting
your 'IOINTEST' string as the database name. The real database name
is what you need to put there.
Joe Weinstein at BEA Systems
I need to make a correction to my problem description. I0INTEST is
the name of the Database.
On Feb 2, 1:30*pm, "joeNOS...@bea.com" <joe.weinst...@gmail.com>
wrote:
On Feb 2, 9:17 am, cwhan...@gmail.com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc.b.DisconnectException: The application server rejected
establishment of the connection. *An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. *What am I
missing? *I0INTEST is a valid table as I can run a query against it in
DB2 Connect. *I'm trying to establish a connection via SquirrelSQL *as
well.
You shouldn't specify any table name in your connection information.
As the error message says, the connection attempt is interpreting
your 'IOINTEST' string as the database name. The real database name
is what you need to put there.
Joe Weinstein at BEA Systems
cw******@gmail.com wrote:
I need to make a correction to my problem description. I0INTEST is
the name of the Database.
On Feb 2, 1:30Â*pm, "joeNOS...@bea.com" <joe.weinst...@gmail.com>
wrote:
>On Feb 2, 9:17 am, cwhan...@gmail.com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc.b.DisconnectException: The application server rejected
establishment of the connection. Â*An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. Â*What am I
missing? Â*I0INTEST is a valid table as I can run a query against it in
DB2 Connect. Â*I'm trying to establish a connection via SquirrelSQL Â*as
well.
You shouldn't specify any table name in your connection information. As the error message says, the connection attempt is interpreting your 'IOINTEST' string as the database name. The real database name is what you need to put there. Joe Weinstein at BEA Systems
From my dim and distant recollections of DB2 on Z/OS a database resides
inside a DB2 subsystem and you connect to the subsystem. Is IOINTEST a DB2
Database or a DB2 subsystem?
Colin
Firstly what type of JDBC driver are you using (Type2 / Type4)? Have
you tried to take a jcc trace to find out where the error is coming
from?
Cheers,
On Feb 6, 3:36 am, Colin Booth <colinsbo...@gmail.comwrote:
cwhan...@gmail.com wrote:
I need to make a correction to my problem description. I0INTEST is
the name of the Database.
On Feb 2, 1:30 pm, "joeNOS...@bea.com" <joe.weinst...@gmail.com>
wrote:
On Feb 2, 9:17 am, cwhan...@gmail.com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc.b.DisconnectException: The application server rejected
establishment of the connection. An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. What am I
missing? I0INTEST is a valid table as I can run a query against it in
DB2 Connect. I'm trying to establish a connection via SquirrelSQL as
well.
You shouldn't specify any table name in your connection information.
As the error message says, the connection attempt is interpreting
your 'IOINTEST' string as the database name. The real database name
is what you need to put there.
Joe Weinstein at BEA Systems
From my dim and distant recollections of DB2 on Z/OS a database resides
inside a DB2 subsystem and you connect to the subsystem. Is IOINTEST a DB2
Database or a DB2 subsystem?
Colin
I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture
2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying
to connect to zOS instance of DB2 from Windwos & I do not have DB2
Connect installed on this PC. You do not need DB2 Connect with a type
4 driver. Correct?
On Feb 5, 3:50*pm, "db2st...@gmail.com" <db2st...@gmail.comwrote:
Firstly what type of JDBC driver are you using (Type2 / Type4)? *Have
you tried to take a jcc trace to find out where the error is coming
from?
Please contact me. I'd like to send you a test program.... to see
where/what the issue is.
Cheers,
On Feb 6, 10:39 am, cwhan...@gmail.com wrote:
I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture
2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying
to connect to zOS instance of DB2 from Windwos & I do not have DB2
Connect installed on this PC. You do not need DB2 Connect with a type
4 driver. Correct?
On Feb 5, 3:50 pm, "db2st...@gmail.com" <db2st...@gmail.comwrote:
Firstly what type of JDBC driver are you using (Type2 / Type4)? Have
you tried to take a jcc trace to find out where the error is coming
from?
cw******@gmail.com wrote:
I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture
2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying
to connect to zOS instance of DB2 from Windwos & I do not have DB2
Connect installed on this PC. You do not need DB2 Connect with a type
4 driver. Correct?
On Feb 5, 3:50 pm, "db2st...@gmail.com" <db2st...@gmail.comwrote:
>Firstly what type of JDBC driver are you using (Type2 / Type4)? Have you tried to take a jcc trace to find out where the error is coming from?
Double check the DCS entry on your DB2 Connect installation (db2 list
dcs directory) and make sure your providing JCC the "Target database
name" and not the local database alias. db******@gmail.com wrote:
Please contact me. I'd like to send you a test program.... to see
where/what the issue is.
Cheers,
On Feb 6, 10:39 am, cwhan...@gmail.com wrote:
>I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying to connect to zOS instance of DB2 from Windwos & I do not have DB2 Connect installed on this PC. You do not need DB2 Connect with a type 4 driver. Correct?
On Feb 5, 3:50 pm, "db2st...@gmail.com" <db2st...@gmail.comwrote:
Firstly what type of JDBC driver are you using (Type2 / Type4)? Have
you tried to take a jcc trace to find out where the error is coming
from?
Talk to your Z/OS DBA. They will be able to tell you what you need to do. It
is quite common for names of 'databases' and 'instances' to be given alises
in DB2 connect or on DB2 clients. You need to know what is defined on Z/OS.
You also need to know if the security system (RACF or equivalent) will let
you in.
Colin This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Axel Dachtler |
last post by:
Hello,
my Java-program can't load the JDBC driver.
I always get a java.lang.NoClassDefFoundError when I run it.
The JDBC Driver is in the directory: C:\programs\ora92\jdbc\lib
I think I...
|
by: sridhar nagabhurshana |
last post by:
hello
I am trying to connect to mysql database using connector/J jdbc driver
this is my code
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
|
by: Priya |
last post by:
Hi,
I am having some problem with DB2 Universal JDBC driver.
1. The method getColumnType(columnNumber)of ResultSetMetaData always
returns zero.
2. The method getColumnDisplaySize(ColumnNum)...
|
by: Dani |
last post by:
Hi everyone
Description of the problem:
Using a PreparedStatement to write down an integer (int) plus a
timestamp for testing purposes. When read out again the integer looks
very different. We...
|
by: Bing |
last post by:
Hi,
I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar
and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x
environment and WebSphere application Server 5.0.2...
|
by: Raquel |
last post by:
Read this about the Universal JDBC Driver....
"In a Type 2 mode, the Universal JDBC driver provides local
application performance gains (because it avoids using TCP/IP protocol
to communicate to...
|
by: Kris Jurka |
last post by:
The JDBC driver has been moved out of the main source tree to a gborg
project. This change will only affect new major releases. The 7.4 series
will continue to be maintained in the main tree. ...
|
by: Dino Nardini |
last post by:
Hey folks,
I'm currently evaluating an upgrade path from our current ColdFusion 5 /
PostgreSQL setup to ColdFusion MX / PostgreSQL. In the current setup,
we're using the Merant ODBC driver for...
|
by: raj singh |
last post by:
Hi,
i am raj singh.I am using type 4 jdbc driver with db2
but its not working its giving the message "required user
property not set". the environment variable is set properly
with jar files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |