SV: [DB2-L] Connectivity between DB2 sub systems in zOS

Hanne Lyssand

SV: [DB2-L] Connectivity between DB2 sub systems in zOS
We are doing this both with datasharing and with plain TCPIP connect.
You have to have TCPIP installed, but I guess you have?

The command:
-DIS DDF

Will give you the ip-adress and port

DSNL080I -DB2P DSNLTDDF DISPLAY DDF REPORT FOLLOWS:
DSNL081I STATUS=STARTD
DSNL082I LOCATION LUNAME GENERICLU
DSNL083I LLLLLLLLDB2P XXXXXX.YYYYYYY -NONE
DSNL084I TCPPORT=446 SECPORT=0 RESPORT=447 IPNAME=-NONE
DSNL085I IPADDR=::123.45.678.000
DSNL086I SQL DOMAIN=xxx002.yyy.no
DSNL086I RESYNC DOMAIN=xxx002.yyy.no
DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE

You have to do this inserts:

INSERT INTO SYSIBM.LOCATIONS
(LOCATION, LINKNAME, PORT)
VALUES ('LLLLLLLLDB2P', 'YYYYYYYY', '446');

INSERT INTO SYSIBM.IPNAMES
(LINKNAME,SECURITY_OUT,IPADDR)
VALUES ('YYYYYYYY','A','123.45.678.000');


Check your setting for zparm:
TCPALVER=YES/NO - if you will use user/password or keep the current user

If you have NO, you have to use this insert
INSERT INTO SYSIBM.USERNAMES
(LINKNAME,TYPE,AUTHID,NEWAUTHID,PASSWORD)
VALUES ('YYYYYYYY','O','','user','password');

And change the A to O in SECURITY_OUT in the insert on IPNAMES

Stopp and start DDF and you should be good to go.

BIND PACKAGE(LLLLLLLLDB2P.collid) -

IN other SQL:

SELECT *
FROM LLLLLLLLDB2P.myowner.mytable

Best recards
Hanne

_____________________________________________________________________

* 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 Hanne Lyssand)
>I disagree Ted. Data-sharing is a more complicated means of connecting
2 subsystems.

You're entitled to your opinion.
I didn't do it directly, myself; the DBA's and SYSPROG's that did it 15 years ago, at a bank I worked for found it relatively easy.
Simpler than IMSPLEX, and infinitely less complex than CICSPLEX.

I was the project lead, and the WLM guy on the project.
-
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

David Seibert

Re: Connectivity between DB2 sub systems in zOS
(in response to Ted MacNEIL)
Hello again Ted,

See the simple few steps described by Hanne & by Kirk.
As long as TCPIP is enabled, with 2 or 3 rows inserted into the CDB,
you're up and running with DRDA /DDF.
You can be all set in a couple minutes.

Setting up data-sharing seems a tiny bit more involved than that.

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 12:45 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS

>I disagree Ted. Data-sharing is a more complicated means of connecting
2 subsystems.

You're entitled to your opinion.
I didn't do it directly, myself; the DBA's and SYSPROG's that did it 15
years ago, at a bank I worked for found it relatively easy.
Simpler than IMSPLEX, and infinitely less complex than CICSPLEX.

I was the project lead, and the WLM guy on the project.
-
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

Edward Long

Re: Connectivity between DB2 sub systems in zOS
(in response to David Seibert)
I concur with Mr. Seibert. Data Sharing is much trickier than DDF.Edward Long




________________________________
From: "Seibert, Dave" <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, January 21, 2010 2:00:11 PM
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS

Hello again Ted,

See the simple few steps described by Hanne & by Kirk.
As long as TCPIP is enabled, with 2 or 3 rows inserted into the CDB,
you're up and running with DRDA /DDF.
You can be all set in a couple minutes. 

Setting up data-sharing seems a tiny bit more involved than that.

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 12:45 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS

>I disagree Ted.  Data-sharing is a more complicated means of connecting
2 subsystems.

You're entitled to your opinion.
I didn't do it directly, myself; the DBA's and SYSPROG's that did it 15
years ago, at a bank I worked for found it relatively easy.
Simpler than IMSPLEX, and infinitely less complex than CICSPLEX.

I was the project lead, and the WLM guy on the project.
-
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


_____________________________________________________________________

* 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

Peter Suhner

Re: Connectivity between DB2 sub systems in zOS
(in response to Edward Long)


Well, apart from discussions on which feature is more complicated to have up and running, they actually provide quite different functionality.



Of course DataSharing will allow you to directly share the same set of
user data, including catalog and directory. IMHO this is less a feature
which I would use to interconnect two DB2 subsystems than to enhance
availability and throughput.



If the intention is to simply access some data on a remote DB2 system
(be it on z/OS or LUW), I'd basically go for DDF. Unless your
requirement tends towards sharing a good part of the data of these
disparate systems.





Peter Suhner

Date: Thu, 21 Jan 2010 11:46:24 -0800
From: [login to unmask email]
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS
To: [login to unmask email]




I concur with Mr. Seibert. Data Sharing is much trickier than DDF.Edward Long






From: "Seibert, Dave" <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, January 21, 2010 2:00:11 PM
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS

Hello again Ted,

See the simple few steps described by Hanne & by Kirk.
As long as TCPIP is enabled, with 2 or 3 rows inserted into the CDB,
you're up and running with DRDA /DDF.
You can be all set in a couple minutes.

Setting up data-sharing seems a tiny bit more involved than that.

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 12:45 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Connectivity between DB2 sub systems in zOS

>I disagree Ted. Data-sharing is a more complicated means of connecting
2 subsystems.

You're entitled to your opinion.
I didn't do it directly, myself; the DBA's and SYSPROG's that did it 15
years ago, at a bank I worked for found it relatively easy.
Simpler than IMSPLEX, and infinitely less complex than CICSPLEX.

I was the project lead, and the WLM guy on the project.
-
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







The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.


_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010
_____________________________________________________________________

* 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

Hanne Lyssand

SV: [DB2-L] Connectivity between DB2 sub systems in zOS
(in response to Peter Suhner)
Datasharing is more complicated, but you get so much more. With connect if DB2 go down, the connection is gone to so both DB2's have to be up an running.
To add a member to a datasharing group is not so complicated, it's the first 2 that give you most problems.

Hanne

_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Roy Boxwell

Re: SV: [DB2-L] Connectivity between DB2 sub systems in zOS
(in response to Hanne Lyssand)
worse its creating one DS out of two single DB2 sub-systems...Just think
of two tables with the same name but different columns or sometimes even
worse two tables with the same name and columns but different
"meanings"....the possibilities are nearly endless when you "merge" DB2
subsystems...good work for an external contractor though!
But back to the original point -> Yep TCP/IP with DDF is the way to go!



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Hanne Lyssand <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
22.01.2010 13:30
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
[DB2-L] SV: [DB2-L] Connectivity between DB2 sub systems in zOS






Datasharing is more complicated, but you get so much more. With connect if
DB2 go down, the connection is gone to so both DB2’s have to be up an
running.
To add a member to a datasharing group is not so complicated, it’s the
first 2 that give you most problems.

Hanne



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

Balachandran Chandrasekaran1

Re: Connectivity between DB2 sub systems in zOS
(in response to Roy Boxwell)
Please have a look at =>
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.dshare/zint.htm#zint









Ramachandran A <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
21/01/2010 18:02
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] 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


_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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: SV: [DB2-L] Connectivity between DB2 sub systems in zOS
(in response to Balachandran Chandrasekaran1)
>To add a member to a datasharing group is not so complicated, it’s the first 2 that give you most problems.

If any at all. (8-{]}
We were lucky, when we implemented it, we were building from scratch, rather than trying to connect two existing.

-
Too busy driving to stop for gas!