z/OS batch Cobol to remote z/OS DB2

Brad Wissink

z/OS batch Cobol to remote z/OS DB2
We have two lpars, running separate z/OS images as monoplexes. Lpar1 does not have DB2 where Lpar2 does have DB2. What I want to do is to have a batch program, preferable COBOL, on Lpar1 connect and retrieve data from DB2 on Lpar2? Is this possible? What are my options?

Brad Wissink


The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

Phil Grainger

z/OS batch Cobol to remote z/OS DB2
(in response to Brad Wissink)
Hi Brad

With standard IBM software the only way to connect to a remote Db2 is via a local Db2

Sorry

BUT there may just be ISV software that can help you do this .....

Phil Grainger
BMC Software

Sent using OWA for iPad
________________________________
From: Wissink, Brad <[login to unmask email]>
Sent: 21 September 2017 19:32:57
To: [login to unmask email]
Subject: [DB2-L] - z/OS batch Cobol to remote z/OS DB2

We have two lpars, running separate z/OS images as monoplexes. Lpar1 does not have DB2 where Lpar2 does have DB2. What I want to do is to have a batch program, preferable COBOL, on Lpar1 connect and retrieve data from DB2 on Lpar2? Is this possible? What are my options?

Brad Wissink


The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.

James Campbell

z/OS batch Cobol to remote z/OS DB2
(in response to Phil Grainger)
True for most languages .

JDBC with z/OS Application Connectivity to DB2 for z/OS is a different story. (or so I have
been led to believe)
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/java/src/tpc/imjcc_jccinst
allwithoutdb2z.html


James Campbell

On 21 Sep 2017 at 19:28, Grainger, Phil wrote:

>
> Hi Brad
>
> With standard IBM software the only way to connect to a remote Db2 is via a local Db2
>
> Sorry
>
> BUT there may just be ISV software that can help you do this .....
>
> Phil Grainger
> BMC Software
>
> Sent using OWA for iPad
>
> From: Wissink, Brad <[login to unmask email]>
> Sent: 21 September 2017 19:32:57
> To: [login to unmask email]
> Subject: [DB2-L] - z/OS batch Cobol to remote z/OS DB2
>  
> We have two lpars, running separate z/OS images as monoplexes.  Lpar1 does not have DB2
> where Lpar2 does have DB2.  What I want to do is to have a batch program, preferable COBOL,
> on Lpar1 connect and retrieve data from DB2 on Lpar2?   Is this possible?  What are my options?
>  
> Brad Wissink
>

---
This email has been checked for viruses by AVG.
http://www.avg.com