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/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 > > >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