There are also lists that are specific to CICS and DB2 that may be helpful should you have more questions
To join, if you have not done, go to these URLs. For DB2 - www.idug.org CICS http://www.listserv.uga.edu/archives/cics-l.html > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Nelson, Judith > Sent: Tuesday, September 19, 2017 10:00 AM > To: [email protected] > Subject: Re: LPAR to LPAR access > > Thank you Jerry! > > Judith Nelson > > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Edgington, Jerry > Sent: Tuesday, September 19, 2017 11:25 AM > To: [email protected] > 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_sysi > bmlocationsds.html, > > Here is the BMC tool > www.bmc.com/it-solutions/subsystem-optimizer.html > > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Edgington, Jerry > Sent: Tuesday, September 19, 2017 12:23 PM > To: [email protected] > 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_N4DvMsVhUlFrsw4WYzLoMP5bgx2U7yd > PE&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:[email protected]] On > Behalf Of Nelson, Judith > Sent: Tuesday, September 19, 2017 11:53 AM > To: [email protected] > 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:[email protected]] On > Behalf Of Edgington, Jerry > Sent: Tuesday, September 19, 2017 9:17 AM > To: [email protected] > 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:[email protected]] On > Behalf Of Nelson, Judith > Sent: Tuesday, September 19, 2017 10:14 AM > To: [email protected] > 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 > [email protected]<mailto:[email protected]> > > > 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 > [email protected] 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 > [email protected] 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 > [email protected] 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 > [email protected] 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 > [email protected] 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 > [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
