468,554 Members | 1,891 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

federation between MF subsystems

can't find in the RedBook, or scouring this NG, a simple
yes/no answer to the question:

given mountains of existing COBOL programs which have read/written
to multiple schemas, but in one z/OS(v7) instance, whether
Information Integrator exists for that platform, and would
allow reading/writing to schemas in multiple instances.

the doc reads (to me) like II sends all data through an LUW
instance.

it is a puzzlement.

thanks,
btdb

Nov 12 '05 #1
3 1614
btdb;
If you wish to simply be able to access multiple subsystems (the 390
equivalent to instances?), information integrator should not be
necessary. I believe DDF (Distributed Data Facility) should give you
what you're looking for. It's been a while since I've worked in a
mainframe COBOL shop, but we used to move pretty seemlessly between
subsystems using DDF and nicknames to minimize code changes.

Information Integrator should only be necessary if you want to have
access to non-DRDA (read that IBM DB2) databases. Federation is
included in the LUW product and allows access to 390 data. Not sure
about federation FROM the 390 platform, but we do federation from LUW
TO the mainframe.

Pete H

Nov 12 '05 #2
Me again... Here's a link to a good DDF redbook:
http://publib-b.boulder.ibm.com/abst...6952.html?Open

Title is "Distributed Functions of DB2 for z/OS and OS/390" and its
dated July 2003, so should be relevant to your issues.

Pete H

Nov 12 '05 #3
well, been looking at the other docs, but i don't see anything
like the following:

active connection: SubSysBob
StoredProcedure: SPUpdate

in SPUpdate,

insert into SchOne.table1 (select * from SchTwo.tableZ);

now we want (logically)

insert into SubSysDave.SchOne.table1 (select * from
SubSysBob.SchTwo.tableZ);

configuring DDF will allow us to pass in as parameters/argurments the
SubSystem
name and the Schema name?? we currently call the SP from a java
servlet, and
do pass in the Schema names. our COBOL folk, who melded the SP from
that
mountain of programs, seem to think it ain't doable.

thanks,
btdb

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by RavenCross | last post: by
14 posts views Thread by spencer | last post: by
3 posts views Thread by Baski | last post: by
2 posts views Thread by bspdan | last post: by
5 posts views Thread by BobTheDataBaseBoy | last post: by
reply views Thread by vbace2 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.