Page 1 of 1

DB2-Oracle Gateway

PostPosted: Thu Mar 01, 2012 2:27 pm
by raghav08
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.

Re: DB2-Oracle Gateway

PostPosted: Thu Mar 01, 2012 2:38 pm
by BillyBoyo
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?

Re: DB2-Oracle Gateway

PostPosted: Thu Mar 01, 2012 4:21 pm
by raghav08
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.

Re: DB2-Oracle Gateway

PostPosted: Thu Mar 01, 2012 4:24 pm
by BillyBoyo
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.