There are also lists that are specific to CICS and DB2 that may be helpful
To join, if you have not done, go to these URLs.
Post by Edgington, Jerry-----Original Message-----
Behalf Of Nelson, Judith
Sent: Tuesday, September 19, 2017 10:00 AM
Subject: Re: LPAR to LPAR access
Thank you Jerry!
Judith Nelson
-----Original Message-----
Behalf Of Edgington, Jerry
Sent: Tuesday, September 19, 2017 11:25 AM
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-----
Behalf Of Edgington, Jerry
Sent: Tuesday, September 19, 2017 12:23 PM
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-----
Behalf Of Nelson, Judith
Sent: Tuesday, September 19, 2017 11:53 AM
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-----
Behalf Of Edgington, Jerry
Sent: Tuesday, September 19, 2017 9:17 AM
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-----
Behalf Of Nelson, Judith
Sent: Tuesday, September 19, 2017 10:14 AM
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
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
________________________________
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
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
________________________________
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
________________________________
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
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