DB2-Oracle Gateway



IBM's flagship relational database management system

DB2-Oracle Gateway

Postby raghav08 » Thu Mar 01, 2012 2:27 pm

Hello,

In our system an Oracale DB (UNIX) connected to Mainframe DB2 thru ODBC called Oracle Gateway. We can find the following In mainframe system log

USER=ORACLE1 CONNECTION-ID=DB2CALL CORRELATION-ID=ORPRDSGW
JOBNAME=ORPRDSGW ASID=0116 TCB=00898988.

Please let me know what's USER=ORACLE1 in the above statement.

ORACLE1 id is no where defined in Mainframe or Oracle DB, from where ORACLE1 coming in to picture.

Thanks.
raghav08
 
Posts: 18
Joined: Wed Oct 27, 2010 5:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2-Oracle Gateway

Postby BillyBoyo » Thu Mar 01, 2012 2:38 pm

Is there really no message number? Have you tried the Oracle Gateway documentation? Or the vendor? You mainframe security system must be aware of this, have you tried those in your support responsible for security?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: DB2-Oracle Gateway

Postby raghav08 » Thu Mar 01, 2012 4:21 pm

Hi,

DB2 DBA & RACF admin said that ORACLE1 id not defined in Mainframe, at the same time Oracle DBA said the same.

Mainframe is host for Oracle Gateway, the uid/password defined in Oracle DB to connect mainframe is not the id ORACLE1

This issue started when Oracle Gateway got upgrade to higher version in Mainframe.
raghav08
 
Posts: 18
Joined: Wed Oct 27, 2010 5:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2-Oracle Gateway

Postby BillyBoyo » Thu Mar 01, 2012 4:24 pm

So talk to the vendor's support. Or get any/all of the above to do it, as they are certainly interested in the answer and may be able to handle the more technical nature of what they are told than you can, as it is their job to do so.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post