IDS Forum

Re: OS 390 accessing Informix v9.40 on AIX

Posted By: Peter_Logan@spartanstores.com
Date: Tuesday, 5 September 2006, at 9:32 a.m.

In Response To: Re: OS 390 accessing Informix v9.40 on AIX (Richard Snoke)

For OS/390 on a mainframe ???

"Richard Snoke" <dsnoke@us.ibm.com>
Sent by: ids-bounces@iiug.org
09/05/2006 09:18 AM
Please respond to
ids@iiug.org

To
ids@iiug.org
cc

Subject
Re: OS 390 accessing Informix v9.40 on AIX [7429]

DB2 does have what you want. Its called the Websphere Information
Integrator. Don't ask about the naming.

The key is that you can install the Informix "wrapper" in DB2. That lets
you define DB2 nicknames for what you want to see in the Informix
database. Then you just use DB2 SQL statements to get at the live IDS
data.

The Informix wrapper is included in the base DB2 release beginning with
DB2 v8.2, I think. No extra software to purchase. You have to do a
custom install to get it however. Its not part of the typical
installation.

Cheers,
Dick Snoke
IBM Software Group - ChannelWorks
dsnoke@us.ibm.com
(404) 487-1595

"Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com>
Sent by: ids-bounces@iiug.org
09/05/2006 08:18 AM
Please respond to
ids@iiug.org

To
ids@iiug.org
cc

Subject
Re: OS 390 accessing Informix v9.40 on AIX [7426]

Yes ... the job currently looks at Db2 for the info...which is copied over

from Informix a few times a day. They are wanting something "real time"
..... Do you happen to know the name of the product that would let
Informix

look to Db2 as if it were part of Db2 .. the reverse to Gateway ....

Peter

"Jonathan Leffler" <jleffler.iiug@gmail.com>
Sent by: ids-bounces@iiug.org
09/02/2006 03:37 AM
Please respond to
ids@iiug.org

To
ids@iiug.org
cc

Subject
Re: OS 390 accessing Informix v9.40 on AIX [7409]

On 9/1/06, Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com>
wrote:
>
> Anybody know of a way to allow an OS 390 mainframe Cobol job access to
> Informix v9.40 on an Aix server. I'm assuming the only way is with the
> Informix Gateway product ... but just wondering if someone knows of
> another way ... The Cobol/CICS job needs to validate a record in the
> Informix database ... I'm trying to avoid copying the data over with
> batch jobs ... or via a product like Web Methods. What I want is to be
> able to read the IDS database from the mainframe...that's all ...
> shouldn't be that difficult .... any help would be appreciated.

Informix Gateway allows non-Informix DBMS too look like an Informix
DBMS; it might be used to connect from an AIX box to a zSeries
machine, but not AFAIK the other way around.

Does your COBOL program run against a DB2 database on the mainframe
too? Or is it going to run solely against the Informix database? If
it uses DB2, I think there may be ways for DB2 to access IDS via a
counterpart to Informix Gateway. If it uses just IDS, then the
'obvious' solution would be to use a non-existent (hypothetical) port
of ESQL/COBOL. I'm pretty sure that doesn't exist - ESQL/COBOL works
with Ryan-McFarland or MicroFocus COBOL only, and hasn't ever been
made available on CICS that I know of. You might find an answer via
II - Information Integration.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• OS 390 accessing Informix v9.40 on AIX
  Peter_Logan@spartanstores.com -- Friday, 1 September 2006, at 9:58 a.m.
  • Re: OS 390 accessing Informix v9.40 on AIX
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Friday, 1 September 2006, at 10:07 a.m.
    • Re: OS 390 accessing Informix v9.40 on AIX
      Peter_Logan@spartanstores.com -- Friday, 1 September 2006, at 10:40 a.m.
  • Re: OS 390 accessing Informix v9.40 on AIX
    Jonathan Leffler -- Saturday, 2 September 2006, at 3:37 a.m.
    • Re: OS 390 accessing Informix v9.40 on AIX
      Peter_Logan@spartanstores.com -- Tuesday, 5 September 2006, at 8:18 a.m.
      • Re: OS 390 accessing Informix v9.40 on AIX
        Richard Snoke -- Tuesday, 5 September 2006, at 9:18 a.m.
        • Re: OS 390 accessing Informix v9.40 on AIX
          Peter_Logan@spartanstores.com -- Tuesday, 5 September 2006, at 9:32 a.m.
          • Re: OS 390 accessing Informix v9.40 on AIX
            Richard Snoke -- Tuesday, 5 September 2006, at 11:20 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.