Connectivity between DB2 sub systems in zOS

Rams A

Connectivity between DB2 sub systems in zOS
Dear list,

Our project needs to establish connectivity between two DB2 sub
systems which are running on two different zOS systems in the same
sysplex. But I am not sure this feature is available or not.

Can anyone suggest some inputs on this same.

Thanks in advance.

Regards,
Rams.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Ted MacNEIL

Re: Connectivity between DB2 sub systems in zOS
(in response to Rams A)
>Our project needs to establish connectivity between two DB2 sub
systems which are running on two different zOS systems in the same
sysplex.

The simplest is a DB2PLEX, building a DB2 sharing group.

>But I am not sure this feature is available or not.

Somebody should be doing research before asking their questions.
The feature has been around for 15+ years.

I have no problem answering questions, but I have issues with answering questions from people who go to a list first, rather than looking things up!
-
Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Kirk Hampton

Re: Connectivity between DB2 sub systems in zOS
(in response to David Seibert)
Good morning Rams,
The feature you are looking for is called Distributed Data Facility
(DDF)
and is included in DB2 for z/OS, and most likely is already active and
available on your two subsystems. You should probably just have to
insert
the proper entries in SYSIBM.LOCATIONS and SYSIBM.LUNAMES to make the
subsystems known to each other.

However, one question, or word of caution. Are these two subsystems both
production, or are you trying to connect a development system to
production?
That can be dangerous. And if they are both production, why were they
never connected before?


J Kirk Hampton
Sr. Specialist - Mainframe
HCL Technologies America
Mesquite Data Center
972-216-3119

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ramachandran
A
Sent: Thursday, January 21, 2010 6:32 AM
To: Hampton, Kirk
Subject: Connectivity between DB2 sub systems in zOS

Dear list,

Our project needs to establish connectivity between two DB2 sub
systems which are running on two different zOS systems in the same
sysplex. But I am not sure this feature is available or not.

Can anyone suggest some inputs on this same.

Thanks in advance.

Regards,
Rams.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions
Journal
Technical atricles from world famous authors in DB2's most prestigious,
peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L


Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

David Seibert

Re: Connectivity between DB2 sub systems in zOS
(in response to Ted MacNEIL)
I disagree Ted. Data-sharing is a more complicated means of connecting
2 subsystems.

I suggest the simplest method is using DRDA to define DDF connections
between the 2 subsystems.

Rams, go to the DB2 information center for the DB2 version you have and
search for Connecting Distributed database systems.

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Thursday, January 21, 2010 9:17 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS

>Our project needs to establish connectivity between two DB2 sub
systems which are running on two different zOS systems in the same
sysplex.

The simplest is a DB2PLEX, building a DB2 sharing group.

>But I am not sure this feature is available or not.

Somebody should be doing research before asking their questions.
The feature has been around for 15+ years.

I have no problem answering questions, but I have issues with answering
questions from people who go to a list first, rather than looking things
up!
-
Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions
Journal
Technical atricles from world famous authors in DB2's most prestigious,
peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L