federation between MF subsystems

BobTheDatabaseBoy

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

peteh

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

peteh

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

BobTheDatabaseBoy

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