473,372 Members | 1,016 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Oracle to DB2 DRDA connectivity

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.COM
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

Jun 15 '07 #1
5 7702
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.COM
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
Jun 15 '07 #2
Not a peep, even when I set diaglevel to 4.

Jun 15 '07 #3
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.
Jun 15 '07 #4
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.COM
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
Jun 15 '07 #5
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
Jun 15 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
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...
1
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...
5
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...
63
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...
1
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...
8
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...
3
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:
19
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.