Thank you Jerry! Judith Nelson
-----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Edgington, Jerry Sent: Tuesday, September 19, 2017 11:25 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: LPAR to LPAR access Sorry Judith, Our email system modifies the URL. I think this link should help with the setup of remote database from DB2 on z/OS. www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/dshare/src/tpc/db2z_sysibmlocationsds.html, Here is the BMC tool www.bmc.com/it-solutions/subsystem-optimizer.html -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Edgington, Jerry Sent: Tuesday, September 19, 2017 12:23 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: LPAR to LPAR access Judith, I think this link should help with the setup of remote database from DB2 on z/OS. https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSEPEK-5F11.0.0_dshare_src_tpc_db2z-5Fsysibmlocationsds.html&d=DwIFAg&c=WUZzGzAb7_N4DvMsVhUlFrsw4WYzLoMP5bgx2U7ydPE&r=gEY-_N3_t4QXFrS5e-OgAibMMWGnLPFFfmDVHG_3lz4&m=Q2qvjC85EobRWAgHVl-yX2v319f6i9cuTloWg-wjmsE&s=sJBowoFLA-8ocnbEpqCKvSdFmT2s355DrFGS5qkZq7M&e= Here is the BMC tool https://urldefense.proofpoint.com/v2/url?u=http-3A__www.bmc.com_it-2Dsolutions_subsystem-2Doptimizer.html&d=DwIFAg&c=WUZzGzAb7_N4DvMsVhUlFrsw4WYzLoMP5bgx2U7ydPE&r=gEY-_N3_t4QXFrS5e-OgAibMMWGnLPFFfmDVHG_3lz4&m=Q2qvjC85EobRWAgHVl-yX2v319f6i9cuTloWg-wjmsE&s=8dcWbFRJZ5UFFIwGKMcoOv5gW9_-1ldLc-jEYbQmIgw&e= Jerry -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Nelson, Judith Sent: Tuesday, September 19, 2017 11:53 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: LPAR to LPAR access Hi Jerry, You are correct with your assumption. :) If I set up the database as remote, wouldn't I still need some kind of a client to connect to it? Could you let me know which product from BMC would do this? Thank you, Judith Nelson -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Edgington, Jerry Sent: Tuesday, September 19, 2017 9:17 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: LPAR to LPAR access Judith, I know of a couple of ways to get batch and CICS to access a remote DB2, which is what you are asking, I believe, because you don't want to setup a DB2 data sharing. 1) Within DB2, you can setup a database as a remote. DB2 admin should know how to do this. 2) BMC has a product that would allow CICS/Batch to connect to a remote DB2, like it is locally attached Jerry -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Nelson, Judith Sent: Tuesday, September 19, 2017 10:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: LPAR to LPAR access Hi, I am trying to find the best solution for the following problem. We have two LPARs, one of them has DB2 running, the other one hasn't. We do not have a SYSPLEX. We now want to access DB2 data in batch and through CICS, from the LPAR that doesn't have DB2 on it. For the batch side, I looked at ODBC, but I couldn't find anything how to set this up from another z/OS. I have set up a simple IPIC connection to connect CICS - CICS across LPAR's. The CICS's are talking. :) Does anyone have any ideas that could help me? Judith Nelson | Senior Systems Programmer Sammons(r) Financial Group Member Companies One Sammons Plaza | Sioux Falls, SD 57193 Phone: (605) 373-2321 jnel...@sfgmembers.com<mailto:jnel...@sfgmembers.com> 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. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ________________________________ This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is confidential and protected by law from unauthorized disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ________________________________ This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is confidential and protected by law from unauthorized disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ________________________________ This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is confidential and protected by law from unauthorized disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
