Helpful folks,
I am having a problem getting Oracle's Transparent Gateway for DRDA
product to interface with DB2 UDB for LUW 8.1.14.
The Gateway product is running on Linux and using DRDA protocol to
connect to my DB2 test server, which is running on Win2003. This test
server has recently been migrated to V8. It was previously on V7.2
FP5, and here is where the mystery lies.
For, when my test server wast at V7, the Oracle gateway was able to
connect and read data. But after I migrated to V8, it no longer works.
I have double-checked every dbm/db cfg parameter, env variable, host
file entries I can think of. They all seem identical to what I had in
V7.
The error that is produced is a 30020 sqlcode with 124c return code,
which indicates a syntax error in the data stream. However, the syntax
of the connection info did not change between V7 and V8. Here is the
full error produced by Transparent Gateway for DRDA:
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
OR************* ****@UDB.FADV.C OM
ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
TG4DRDA v10.2.0.3.0 grc=0, drc=-30020 (839C,0000), errp=GDJMRC
errmc=124C
ORA-02063: preceding 3 lines from UDB
On the initial connection to DB2, the Gateway binds a package in DB2.
The permissions (on thel login being used) for CONNECT and BIND
PACKAGE are also identical between V7 and V8.
My question, does anyone have any experience with this scenario, or,
is anyone aware of things that have changed in regard to DRDA
connectivity to V8 (defaults changing, new cfg parameters, etc.)
Any help or feedback would be greatly appreciated.
Thanks,
Sean
5  7776 
Scav wrote:
Helpful folks,
I am having a problem getting Oracle's Transparent Gateway for DRDA
product to interface with DB2 UDB for LUW 8.1.14.
The Gateway product is running on Linux and using DRDA protocol to
connect to my DB2 test server, which is running on Win2003. This test
server has recently been migrated to V8. It was previously on V7.2
FP5, and here is where the mystery lies.
For, when my test server wast at V7, the Oracle gateway was able to
connect and read data. But after I migrated to V8, it no longer works.
I have double-checked every dbm/db cfg parameter, env variable, host
file entries I can think of. They all seem identical to what I had in
V7.
The error that is produced is a 30020 sqlcode with 124c return code,
which indicates a syntax error in the data stream. However, the syntax
of the connection info did not change between V7 and V8. Here is the
full error produced by Transparent Gateway for DRDA:
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
OR************* ****@UDB.FADV.C OM
ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
TG4DRDA v10.2.0.3.0 grc=0, drc=-30020 (839C,0000), errp=GDJMRC
errmc=124C
ORA-02063: preceding 3 lines from UDB
On the initial connection to DB2, the Gateway binds a package in DB2.
The permissions (on thel login being used) for CONNECT and BIND
PACKAGE are also identical between V7 and V8.
My question, does anyone have any experience with this scenario, or,
is anyone aware of things that have changed in regard to DRDA
connectivity to V8 (defaults changing, new cfg parameters, etc.)
Any help or feedback would be greatly appreciated.
Thanks,
Sean
There is probably something wrong with the package bind.
Maybe you are hitting something similar to this: http://www-1.ibm.com/support/docview...id=swg1IY50531
Is there anything in DB2's diagnostic log?
--
Jeroen
Not a peep, even when I set diaglevel to 4.
Scav wrote:
Not a peep, even when I set diaglevel to 4.
I suggest you contact DB2 Service. A -30020 error indicates some DRDA
violation has occurred.
Scav wrote:
Helpful folks,
I am having a problem getting Oracle's Transparent Gateway for DRDA
product to interface with DB2 UDB for LUW 8.1.14.
The Gateway product is running on Linux and using DRDA protocol to
connect to my DB2 test server, which is running on Win2003. This test
server has recently been migrated to V8. It was previously on V7.2
FP5, and here is where the mystery lies.
For, when my test server wast at V7, the Oracle gateway was able to
connect and read data. But after I migrated to V8, it no longer works.
I have double-checked every dbm/db cfg parameter, env variable, host
file entries I can think of. They all seem identical to what I had in
V7.
The error that is produced is a 30020 sqlcode with 124c return code,
which indicates a syntax error in the data stream. However, the syntax
of the connection info did not change between V7 and V8. Here is the
full error produced by Transparent Gateway for DRDA:
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
OR************* ****@UDB.FADV.C OM
ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
TG4DRDA v10.2.0.3.0 grc=0, drc=-30020 (839C,0000), errp=GDJMRC
errmc=124C
ORA-02063: preceding 3 lines from UDB
On the initial connection to DB2, the Gateway binds a package in DB2.
The permissions (on thel login being used) for CONNECT and BIND
PACKAGE are also identical between V7 and V8.
My question, does anyone have any experience with this scenario, or,
is anyone aware of things that have changed in regard to DRDA
connectivity to V8 (defaults changing, new cfg parameters, etc.)
Any help or feedback would be greatly appreciated.
Thanks,
Sean
Can you collect db2drdat trace on your V8 server?
Open command window, issue:
db2drdat on
issue connect from Oracle gateway. When you get error, on Windows
machine issue:
db2drdat off
which creates file db2drdat.dmp
If it is not too big (it shouldn't - post it's contents - it is an ASCII
text file.
Jan M. Nelken
Scav wrote:
Not a peep, even when I set diaglevel to 4.
I assume the problem is on the Gateway side.
Did you follow the scenario described here: http://download-west.oracle.com/docs....htm#sthref974
More specifically:
- (re)creating the ORACLE2PC table before executing the DRDA package bind
- creating the data dictionary tables/views for UDB v8
HTH
--
Jeroen This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Alex |
last post by:
I have developed a VB application that uses Oracle 8i database for backend.
The database server is on the local network. From my development machine,
the application connects (via ODBC) to the database successfully. The
problem is that I want to install this application on several Windows 2000
client machines that do not have Oracle client installed (hence missing all
the ODBC connectivity support files/drivers). What is the minimum...
|
by: Ton |
last post by:
I have a question about connectivity between different databases.
Oracle, DB2400 and SQL_server.
It is easy to integrate application products that are running on
different DB platforms?
What products can be used to achieve this? Our consultant is
mentioning .NET but then we have to run everything on SQL server.
Currently we are running on Oracle but our third party generic
applications are first developed for SQL server and later...
|
by: Kona |
last post by:
Hello,
Is it right to tell that DB2 Connect has the same function that Oracle
Net ?
If I have an ODBC application is it also right to tell that I have 2
possibilities on my client workstation to acces a remote UDB database
on a Sun machine :
a) with a run-time client
b) with DB2 Connect Personnal Edition
Thank you
|
by: Nick Palmer |
last post by:
Hi all,
Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two
DB2 databases and I need to get access to the tables in one from the other.
In Oracle I would just create a DB Link between the two instances. Is such
a thing possible between two DB2 databases ?
Thanks in advance,
Nick
|
by: lovkeshanand |
last post by:
Dear All,
I am using the oracle transparent gateway connectivity with sql server
using tg4msql,as far as
settings are concerned those were set and Connectivity is working Fine,
and getting the response
from that server.
here is description what I done as:-There is a View on Sqlserver which
is Join of 6 tables and have
| | |
by: joe.weinstein |
last post by:
Hi, and thanks in advance. I am reading documentation for
a JDBC driver which uses DRDA to talk to DB2, but seems
to imply that some DB2 installations/configurations might
make DRDA access optional.
Joe Weinstein at BEA Systems
|
by: TOYSJAY |
last post by:
I would like to query an ORACLE 7.1 database on VMS from DB2 (IBM 390).
Appreciate any help on How to:
|
by: Gregor =?UTF-8?B?S292YcSN?= |
last post by:
Hi!
I'm using DB2 database on one server and ORACLE database on the second one.
I want to move some data from ORACLE database to DB2 database and update
some columns on ORACLE database so I know what rows were transfered. I'd
like to do this in a distributed XA transaction and Java. :)
How is this possible ?
Best regards,
Kovi
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
