uuaaa: [DB2-L] CICS on one system access DB2 data on another

Michael Kaplan

uuaaa: [DB2-L] CICS on one system access DB2 data on another
Hi,



.No problem for read only operations. However, do not expect the same
response time you would have on the same LPAR.

For update operations, I believe, two phase commit will be in affect, and
it is also should be OK.



As for set up, bind each of you plans defined in "dummy" DB2 ( which shares
the same LPAR with CICS) as running in CURRENT SERVER

of "real" DB2. Do not forget to specify * ( star) for location when you
bind collections for "dummy" DB2. The real collections have to be defined

in "real" DB2.



Note: it is NOT good solution for large transaction volume, even if you put
DDF in high priority ( which is not usually recommended for normal
processing).



Michael Kaplan

DBA DB2

Leumi Card



-----????? ??????-----
???: DB2 Data Base Discussion List [mailto:[login to unmask email] ??? GRESHAM,
DEBORAH B
????: ? 25 ????? 2009 20:34
??: [login to unmask email]
????: [DB2-L] CICS on one system access DB2 data on another



Good afternoon! One of my teammates has been asked to look into the
feasibility of running our CICS regions on only one z/OS system image. Some
transactions would need data from a DB2 subsystem running on a different
system image. We're considering DDF from a DB2 on the same image as CICS to
the other DB2. Could that help avoid rewriting the existing CICS programs?
Any references on setting this up? We'd appreciate any input from the list
about this.

Thanks,

Deborah


_____

< http://idug.org/lseu > IDUG 2009 - Europe * 5-9 October * Rome, Italy

< http://www.idug.org > IDUG.org was recently updated requiring members to
use a new password. You should have gotten an e-mail with the temporary
password assigned to your account. Please log in and update your member
profile. If you are not already an IDUG.org member, please register here.
< http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

James Campbell

Re: CICS on one system access DB2 data on another
(in response to Michael Kaplan)
I've done this with batch jobs
- run those transaction in a separate plan
- bind that plan (on the same system that the CICS in on) with  CURRENTSERVER(remote
DB2)
- bind the packages on both the local and remote DB2s
It should work.

James Campbell


On 25 Jan 2009 at 13:33, GRESHAM, DEBORAH B wrote:

>
> Good afternoon! One of my teammates has been asked to look into the feasibility of running our CICS
> regions on only one z/OS system image. Some transactions would need data from a DB2 subsystem
> running on a different system image. We´re considering DDF from a DB2 on the same image as CICS to the
> other DB2.Could that help avoid rewriting the existing CICS programs? Any references on setting this
> up?We´d appreciate any input from the list about this.
> Thanks,
> Deborah
>
>
>
> IDUG 2009 - Europe * 5-9 October * Rome, Italy
> IDUG.org was recently updated requiring members to use a new password. You should have
> gotten an e-mail with the temporary password assigned to your account. Please log in and update
> your member profile. If you are not already an IDUG.org member, please register here.

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Jim Tonchick

Re: CICS on one system access DB2 data on another
(in response to James Campbell)
Not possible.  A CICS can only connect to a single DB2 subsystem running on the same lpar.  Some shops use CICS remote program execution to route the UOW from the originating CICS region a remote CICS region running the program with the SQL so it can connect to DB2.  Either way you must have at least one CICS region running on the same lpar as the target DB2.

I have not checked into the possibility of a CICS Java application using JDBC to remotely access a DB2.  Someone in the community might be better aquainted with the possibility of this.

Jim Tonchick

-----Original Message-----
From: GRESHAM, DEBORAH B <[login to unmask email]>
To: [login to unmask email]
Sent: Sun, 25 Jan 2009 12:33 pm
Subject: [DB2-L] CICS on one system access DB2 data on another



Good afternoon!  One of my teammates has been asked to look into the feasibility of running our CICS regions on only one z/OS system image.  Some transactions would need data from a DB2 subsystem running on a different system image.  We’re considering DDF from a DB2 on the same image as CICS to the other DB2.  Could that help avoid rewriting the existing CICS programs?   Any references on setting this up?  We’d appreciate any input from the list about this.

Thanks,

Deborah




IDUG 2009 - Europe * 5-9 October * Rome, Italy
IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Pl
ease log in and update your member profile. If you are not already an IDUG.org member, please register here.


IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Jim Tonchick

Re: CICS on one system access DB2 data on another
(in response to Jim Tonchick)
The only problem with this is that it still requies a local DB2 to act as the application server to the remore DB2 database server.  I believe that the original idea was to have a CICS only lpar and a DB2 only lpar connect.

Jim  Tonchick

-----Original Message-----
From: James Campbell <[login to unmask email]>
To: [login to unmask email]
Sent: Sun, 25 Jan 2009 10:47 pm
Subject: Re: [DB2-L] CICS on one system access DB2 data on another



I've done this with batch jobs
run those transaction in a separate plan
bind that plan (on the same system that the CICS in on) with
CURRENTSERVER(remote
B2)
bind the packages on both the local and remote DB2s
t should work.
James Campbell

n 25 Jan 2009 at 13:33, GRESHAM, DEBORAH B wrote:
>
Good afternoon! One of my teammates has been asked to look into the
easibility of running our CICS
regions on only one z/OS system image. Some transactions would need data from
DB2 subsystem
running on a different system image. We´re considering DDF from a DB2 on the
ame image as CICS to the
other DB2.Could that help avoid rewriting the existing CICS programs? Any
eferences on setting this
up?We´d appreciate any input from the list about this.
Thanks,
Deborah



IDUG 2009 - Europe * 5-9 October * Rome, Italy
IDUG.org was recently updated requiring members to use a new password. You
hould have
gotten an e-mail with the temporary password assigned to your accou
nt. Please
og in and update
your member profile. If you are not already an IDUG.org member, please
egister here.
______________________________________________________________________
* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
_____________________________________________________________________


DUG.org was recently updated requiring members to use a new password. You
hould have gotten an e-mail with the temporary password assigned to your
ccount. Please log in and update your member profile. If you are not already an
DUG.org member, please register at http://www.idug.org/component/juser/register.html


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Hanne Lyssand

Re: CICS on one system access DB2 data on another
(in response to Jim Tonchick)
It's is possible and no rewrite is nessesary. You have to have one DB2 on the same lPAR as the cics. Bind plan in that DB2, use pklist to point to a package on another DB2. DDF will handle it all. IBM will absolutely say it is not a good idea, and I have a rough test that indicate the overhead to be around 50%. So don't do this for performance.

Best regards
Hanne Lyssand
Databaseadministrator

Fra: DB2 Data Base Discussion List [mailto:[login to unmask email] På vegne av GRESHAM, DEBORAH B
Sendt: 25. januar 2009 19:34
Til: [login to unmask email]
Emne: [DB2-L] CICS on one system access DB2 data on another


Good afternoon! One of my teammates has been asked to look into the feasibility of running our CICS regions on only one z/OS system image. Some transactions would need data from a DB2 subsystem running on a different system image. We're considering DDF from a DB2 on the same image as CICS to the other DB2. Could that help avoid rewriting the existing CICS programs? Any references on setting this up? We'd appreciate any input from the list about this.

Thanks,

Deborah

________________________________

IDUG 2009 - Europe * 5-9 October * Rome, Italy < http://idug.org/lseu >

IDUG.org <http://www.idug.org> was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.< http://www.idug.org/component/juser/register.html >


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html