DB2 10 z/os to DB2 LUW database

Darren Kilpatrick

DB2 10 z/os to DB2 LUW database

Hello,

Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW (preferably AIX) database?  I thought DB2 for z/OS had everything to connect remotely as long as the communication database entries were set up correctly?  This could be a read or even merge (upsert) from DB2 z/OS to DB2 LUW, not just a load using cross-loader.   Thanks!

Daniel Luksetich

DB2 10 z/os to DB2 LUW database
(in response to Darren Kilpatrick)
Yes, I have done it. Even bound SPUFI, DSNTEP2, and DSNTIAUL to the AIX
database. I have set up two way communication between the two servers.
Works well.
Cheers,
Dan

On Tue, 18 Jun 2013 11:52:56 -0700 (MST), Darren Kilpatrick
<[login to unmask email]> wrote:
> Hello,
> Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW
> (preferably AIX) database? I thought DB2 for z/OS had everything to
> connect remotely as long as the communication database entries were set
up
> correctly? This could be a read or even merge (upsert) from DB2 z/OS to
> DB2 LUW, not just a load using cross-loader. Thanks!
>
>
> -----End Original Message-----

Charles Brown

DB2 10 z/os to DB2 LUW database
(in response to Daniel Luksetich)
Yes -- we were able to execute CICS transactions that read tables defined in LUW. This was just a proof of concept -- no intention to go forward with it.

It should work with a little bit of bind parameters changes.

Thx!!


Sent from my iPhone

On Jun 18, 2013, at 1:58 PM, Daniel Luksetich <[login to unmask email]> wrote:

Yes, I have done it. Even bound SPUFI, DSNTEP2, and DSNTIAUL to the AIX
database. I have set up two way communication between the two servers.
Works well.
Cheers,
Dan

On Tue, 18 Jun 2013 11:52:56 -0700 (MST), Darren Kilpatrick
<[login to unmask email]> wrote:
> Hello,
> Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW
> (preferably AIX) database? I thought DB2 for z/OS had everything to
> connect remotely as long as the communication database entries were set
up
> correctly? This could be a read or even merge (upsert) from DB2 z/OS to
> DB2 LUW, not just a load using cross-loader. Thanks!
>
>
> -----End Original Message-----

-----End Original Message-----

bernd oppolzer

DB2 10 z/os to DB2 LUW database
(in response to Darren Kilpatrick)
Yes. We have some batch programs that read data from DB2 LUW
and move them to a mainframe based table system. The data came
from mainframe DB2 some years before, but management decided that
the table creation process has to be moved to DB2 LUW (using some
Java GUI), and so the existing batch programs (written in C) that read the
DB2 data and build the (operative) table data simply was rebound to
the DB2 LUW database.

Another program which has to be treated the same way was a comparison
tool which compared the operative table data on the mainframe with the
DB2 LUW data on the Linux server (just to make sure if the deploying was
OK).

The were two major issues:

a) the subsystem names to do the CONNECTs to had only 4 chars (which was
OK for the mainframe DB2s, but this had to be extended to 8 chars for the
LUW subsystem names) - the subsystem names are (optional) JCL parameters
to the programs (keyword parameters with defaults) - they had to be expanded
in size.

b) the LUW subsystems had ASCII charset, so there were some issues with
ORDER BY. Although the ordering on the target table system (on the
mainframe)
is the same, of course, the comparison tool had some problems, because it
used ORDER BY on the DB2 side to guarantee the same ordering as on the
mainframe table side, and this didn't work with the ASCII DB2 tables on
LUW.
So we had to change the ORDER BY clauses in the comparison program
to get an EBCDIC ORDERing even on the ASCII tables of DB2 LUW.
This was possible by ordering some hex representation of the data - using
HEX(TRANSLATE(...)).

Kind regards

Bernd



Am 18.06.2013 20:52, schrieb Darren Kilpatrick:
>
> Hello,
>
> Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW
> (preferably AIX) database? I thought DB2 for z/OS had everything to
> connect remotely as long as the communication database entries were
> set up correctly? This could be a read or even merge (upsert) from
> DB2 z/OS to DB2 LUW, not just a load using cross-loader. Thanks!
>
>
> ------------------------------------------------------------------------
>

Philip Nelson

DB2 10 z/os to DB2 LUW database
(in response to Darren Kilpatrick)
Yes

We have ddf connections set up and access luw from a variety of programming
languages (mainly COBOL and REXX).

We even have bound the SPUFI packages against LUW databases so that some of
the old-timers don't need to use a GUI !!!

What's your issue ?
On 18 Jun 2013 19:53, "Darren Kilpatrick" <[login to unmask email]>
wrote:

> Hello,
>
> Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW
> (preferably AIX) database? I thought DB2 for z/OS had everything to
> connect remotely as long as the communication database entries were set up
> correctly? This could be a read or even merge (upsert) from DB2 z/OS to
> DB2 LUW, not just a load using cross-loader. Thanks!
>
> -----End Original Message-----
>

Darren Kilpatrick

DB2 10 z/os to DB2 LUW database
(in response to Philip Nelson)
Thanks for your response. We are looking to pull some data from LUW so we can run it through a series of programs that reside on the mainframe only. I am looking for how to set up the connection in the communication database and how to run the connect.

From: Philip Nelson [mailto:[login to unmask email]
Sent: Tuesday, June 18, 2013 08:53 PM
To: [login to unmask email] <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 10 z/os to DB2 LUW database


Yes

We have ddf connections set up and access luw from a variety of programming languages (mainly COBOL and REXX).

We even have bound the SPUFI packages against LUW databases so that some of the old-timers don't need to use a GUI !!!

What's your issue ?

On 18 Jun 2013 19:53, "Darren Kilpatrick" <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hello,

Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW (preferably AIX) database? I thought DB2 for z/OS had everything to connect remotely as long as the communication database entries were set up correctly? This could be a read or even merge (upsert) from DB2 z/OS to DB2 LUW, not just a load using cross-loader. Thanks!

-----End Original Message-----


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise be protected by law. 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.

Charles Brown

DB2 10 z/os to DB2 LUW database
(in response to Darren Kilpatrick)
If your objective is to establish connectivity from "Z" to LUW, here's a
cheat sheet that can make things work for you. It has worked for me over the
years on all versions - check it out!

http://www.ibm.com/developerworks/data/library/techarticle/0310chong/0310cho
ng.html

Hope it helps.

Thx!!

From: Kilpatrick, Darren [mailto:[login to unmask email]
Sent: Tuesday, June 18, 2013 9:59 PM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 10 z/os to DB2 LUW database



Thanks for your response. We are looking to pull some data from LUW so we
can run it through a series of programs that reside on the mainframe only. I
am looking for how to set up the connection in the communication database
and how to run the connect.


From: Philip Nelson [mailto:[login to unmask email]
Sent: Tuesday, June 18, 2013 08:53 PM
To: [login to unmask email] <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 10 z/os to DB2 LUW database


Yes

We have ddf connections set up and access luw from a variety of programming
languages (mainly COBOL and REXX).

We even have bound the SPUFI packages against LUW databases so that some of
the old-timers don't need to use a GUI !!!

What's your issue ?

On 18 Jun 2013 19:53, "Darren Kilpatrick" <[login to unmask email]>
wrote:

Hello,

Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW
(preferably AIX) database? I thought DB2 for z/OS had everything to connect
remotely as long as the communication database entries were set up
correctly? This could be a read or even merge (upsert) from DB2 z/OS to DB2
LUW, not just a load using cross-loader. Thanks!



-----End Original Message-----




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise be protected by law. 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.



-----End Original Message-----

Govind Chettiar

RE: DB2 10 z/os to DB2 LUW database
(in response to Darren Kilpatrick)


I haven't looked at Charles Brown's link so perhaps it's saying what I'm saying...you can set up aliases in your zOS catalog to your remote tables and thus eschew explicit connect syntax in  your programs (or have to specify location in SPUFI).


In Reply to Darren Kilpatrick:

Thanks for your response. We are looking to pull some data from LUW so we can run it through a series of programs that reside on the mainframe only. I am looking for how to set up the connection in the communication database and how to run the connect.

From: Philip Nelson [mailto:[login to unmask email]
Sent: Tuesday, June 18, 2013 08:53 PM
To: [login to unmask email] <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 10 z/os to DB2 LUW database


Yes

We have ddf connections set up and access luw from a variety of programming languages (mainly COBOL and REXX).

We even have bound the SPUFI packages against LUW databases so that some of the old-timers don't need to use a GUI !!!

What's your issue ?

On 18 Jun 2013 19:53, "Darren Kilpatrick" <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hello,

Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW (preferably AIX) database? I thought DB2 for z/OS had everything to connect remotely as long as the communication database entries were set up correctly? This could be a read or even merge (upsert) from DB2 z/OS to DB2 LUW, not just a load using cross-loader. Thanks!

-----End Original Message-----


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise be protected by law. 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.