By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,993 Members | 1,947 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,993 IT Pros & Developers. It's quick & easy.

federation between MF subsystems

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.