Prev: reorg pending table
Next: Does a backup capture binds?
From: chuck on 5 May 2010 15:47
Hi,
I'm getting acquainted with Federated data. In this context I've a
question. On LUW I can create nicknames for tables on DB2 for zOS .
What is the equivalent action on DB2 for zOS? How do I refer to a
table on an LUW DB2 instance? Do I use alias? If so how do I create
this? I don't want to explicitly connect from my application (Cobol)
if I don't have to.
Thanks!
From: Anwei Shen on 6 May 2010 12:27
On May 5, 3:47 pm, chuck <charles.levi...(a)gmail.com> wrote:
> Hi,
> I'm getting acquainted with Federated data.  In this context I've a
> question.  On LUW I can create nicknames for tables on DB2 for zOS .
> What is the equivalent action on DB2 for zOS?  How do I refer to a
> table on an LUW DB2 instance?  Do I use alias?  If so how do I create
> this?  I don't want to explicitly connect from my application (Cobol)
> if I don't have to.
> Thanks!

Not sure how zOS support Federation, but you can connect to UDB
directly from Cobol.
From: chuck on 6 May 2010 13:51
On May 6, 12:27 pm, Anwei Shen <shenan...(a)gmail.com> wrote:
> On May 5, 3:47 pm, chuck <charles.levi...(a)gmail.com> wrote:
>
> > Hi,
> > I'm getting acquainted with Federated data.  In this context I've a
> > question.  On LUW I can create nicknames for tables on DB2 for zOS .
> > What is the equivalent action on DB2 for zOS?  How do I refer to a
> > table on an LUW DB2 instance?  Do I use alias?  If so how do I create
> > this?  I don't want to explicitly connect from my application (Cobol)
> > if I don't have to.
> > Thanks!
>
> Not sure how zOS support Federation, but you can connect to UDB
> directly from Cobol.

Yes that's true by making the requisite entries in the CDB
(SYSIBM.IPNAMES and SYSIBM.LOCATIONS etc) I can connect to LUW. But
how can I join a zOS table with an LUW table from a Cobol program on
the mainframe (I could define nicknames for the zOS Db2 tables on LUW
and accomplish but that seems roundabout!)
From: Larry on 6 May 2010 20:36
chuck wrote:
> On May 6, 12:27 pm, Anwei Shen <shenan...(a)gmail.com> wrote:
>> On May 5, 3:47 pm, chuck <charles.levi...(a)gmail.com> wrote:
>>
>>> Hi,
>>> I'm getting acquainted with Federated data. In this context I've a
>>> question. On LUW I can create nicknames for tables on DB2 for zOS .
>>> What is the equivalent action on DB2 for zOS? How do I refer to a
>>> table on an LUW DB2 instance? Do I use alias? If so how do I create
>>> this? I don't want to explicitly connect from my application (Cobol)
>>> if I don't have to.
>>> Thanks!
>> Not sure how zOS support Federation, but you can connect to UDB
>> directly from Cobol.
>
> Yes that's true by making the requisite entries in the CDB
> (SYSIBM.IPNAMES and SYSIBM.LOCATIONS etc) I can connect to LUW. But
> how can I join a zOS table with an LUW table from a Cobol program on
> the mainframe (I could define nicknames for the zOS Db2 tables on LUW
> and accomplish but that seems roundabout!)
The only thing you could EXPLORE (and I'm not sure if this would work)
is to set up a Federation Server on LUW with a Federated database
defined "in front of" two DB2 for LUW databases. Then, you can set up
that Federated database as a DRDA-AS to be served by the DB2 on z/OS as
a DRDA-AR. I know that I've seen this kind of environment set up when a
mainframe DB2 app requires access to a non DB2 LUW db (e.g. Oracle) via
Infosphere Federation Server.

Larry Edelstein

--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
 | 
Pages: 1
Prev: reorg pending table
Next: Does a backup capture binds?