RE: Oracle 12 <-> DB2

  • From: "Reen, Elizabeth " <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "elizabeth.reen" for DMARC)
  • To: "'rob@xxxxxxxxxxxxxxxx'" <rob@xxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 9 Jun 2017 13:29:22 +0000

Golden Gate just moves data.  It doesn’t run any code.

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930  (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Rob Lockard
Sent: Thursday, June 08, 2017 5:15 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle 12 <-> DB2


Will Golden Gate call stored procedures on DB2? We have a lot of PL/SQL 
packages in Oracle that are calling stored procedures on DB2.

On 6/8/2017 5:08 PM, Andrew Kerber wrote:
Golden Gate will work with DB2

Sent from my iPhone

On Jun 8, 2017, at 12:37 PM, Stefan Knecht 
<knecht.stefan@xxxxxxxxx<mailto:knecht.stefan@xxxxxxxxx>> wrote:
Oracle Gateway can connect to DB2:

http://www.oracle.com/technetwork/database/gateways/index.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_technetwork_database_gateways_index.html&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=ApfmAYG36JWAlYtFdxAzAmPE8vi_wwS1dvjlGNg1-Yw&e=>



On Fri, Jun 9, 2017 at 12:30 AM, rob 
oraclewizard.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__oraclewizard.com&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=6-KsFlDrmfNjJ-qKtPAmCyoZJve_xgDZ3dvPAyoBNP0&e=>
 <rob@xxxxxxxxxxxxxxxx<mailto:rob@xxxxxxxxxxxxxxxx>> wrote:

Does anyone know of a product that will give bi-directional communications from 
Oracle 12.2 to DB2 on System-Z. Oracle is calling a DB2 stored procedure that 
returns results. Right now we are using Start Quest to do this, The shop is 
upgrading from Oracle 10g -> 12.2, and can not get the Star Quest product to 
work. Thanks -Rob




--

================================

"The question isn't who is going to let me; it's who is going to stop me."

Ayn Rand

Robert P. Lockard

www.oraclewizard.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oraclewizard.com&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=7_PS27XbhdcbTkPmMkdZxC-AvaXsdFLE-PxbIDSUcwA&e=>

(c) 571.276.4790

Twitter: @YourNavionPilot

Other related posts: