Hi Roger, Thanks for the head's-up. We are not in a Sysplex. Judith Nelson
-----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Roger Lowe Sent: Tuesday, September 19, 2017 7:47 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: LPAR to LPAR access Judith/Jerry, BMC's product (Subsystem Optimizer for zEnterprise "Subzero") requires a BASIC or PARALLEL Sysplex environment. Roger On Tue, 19 Sep 2017 23:30:13 +0000, Edgington, Jerry <jerry.edging...@kroger.com> wrote: >Yes, Judith. That is correct. I missed that in your email. However, I believe >the BMC tool allows you to connect CICS and maybe batch on one LPAR to DB2 on >another LPAR. > >-----Original Message----- >From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] >On Behalf Of Nelson, Judith >Sent: Tuesday, September 19, 2017 5:43 PM >To: IBM-MAIN@LISTSERV.UA.EDU >Subject: Re: LPAR to LPAR access > >Hi Jerry, >I have looked into the link to the remote database. As far as I >understand this is that requires a db2 instance on both LPAR's. :( > >Thank you, > >Judith Nelson > > >-----Original Message----- >From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] >On Behalf Of Nelson, Judith >Sent: Tuesday, September 19, 2017 12:00 PM >To: IBM-MAIN@LISTSERV.UA.EDU >Subject: Re: LPAR to LPAR access > >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/db2 >z_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_suppor >t_knowledgecenter_en_SSEPEK-5F11.0.0_dshare_src_tpc_db2z-5Fsysibmlocati >onsds.html&d=DwIFAg&c=WUZzGzAb7_N4DvMsVhUlFrsw4WYzLoMP5bgx2U7ydPE&r=gEY >-_N3_t4QXFrS5e-OgAibMMWGnLPFFfmDVHG_3lz4&m=Q2qvjC85EobRWAgHVl-yX2v319f6 >i9cuTloWg-wjmsE&s=sJBowoFLA-8ocnbEpqCKvSdFmT2s355DrFGS5qkZq7M&e= > >Here is the BMC tool >https://urldefense.proofpoint.com/v2/url?u=http-3A__www.bmc.com_it-2Dso >lutions_subsystem-2Doptimizer.html&d=DwIFAg&c=WUZzGzAb7_N4DvMsVhUlFrsw4 >WYzLoMP5bgx2U7ydPE&r=gEY-_N3_t4QXFrS5e-OgAibMMWGnLPFFfmDVHG_3lz4&m=Q2qv >jC85EobRWAgHVl-yX2v319f6i9cuTloWg-wjmsE&s=8dcWbFRJZ5UFFIwGKMcoOv5gW9_-1 >ldLc-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 > > >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 ---------------------------------------------------------------------- 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
