Gateway ...
Can anyone give me there impressions of the gateway products ... I need to get a bunch of IDS data into DB2 on the mainframe ... and back to IDS ... Developers are wanting to look at IDS data from DB2 and vice versa ... IDS ... 11.50.fc3 - Aix 5.3 DB2 v8 - OS 360 If someone else has a better solution please let me know .... Thanks for any and all help ... Peter Logan Senior Database Administrator Phone: 616/878-8309
Peter_Logan@spartanstores.com wrote: > Can anyone give me there impressions of the gateway products ... I need > to get a bunch of IDS data into DB2 on the mainframe ... and back to IDS > .... Developers are wanting to look at IDS data from DB2 and vice versa > .... > > IDS ... 11.50.fc3 - Aix 5.3 > > DB2 v8 - OS 360 > > If someone else has a better solution please let me know .... You *should* be able to just use the CSDK (or JDBC or ODBC). The CSDK has got DRDA built into it now. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Thanks ... does anyone have this working ... and does anyone know where it's documented ..which manual ... Thanks again .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: ids@iiug.org Date: 02/24/2009 04:19 PM Subject: Re: Gateway ... [15010] Sent by: ids-bounces@iiug.org Peter_Logan@spartanstores.com wrote: > Can anyone give me there impressions of the gateway products ... I need > to get a bunch of IDS data into DB2 on the mainframe ... and back to IDS > .... Developers are wanting to look at IDS data from DB2 and vice versa > .... > > IDS ... 11.50.fc3 - Aix 5.3 > > DB2 v8 - OS 360 > > If someone else has a better solution please let me know .... You *should* be able to just use the CSDK (or JDBC or ODBC). The CSDK has got DRDA built into it now. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
You can use the Informix gateway product and set it up in a "distributed" mode. Details can be found in this URL. http://www-01.ibm.com/software/data/informix/pubs/library/entgw_73.html However, if you can use Java, then the latest common driver, IBM Driver for JDBC and SQLJ (http://www-01.ibm.com/software/data/informix/ids/ad/java.html) can be used for interaction with both Informix and DB2 systems (LUW and z/OS). You need to get data into the client and then push it over to the other system. Note that you will need the appropriate license file to work with the z/OS system if you choose this alternative. VG.
In the administrator guide, check the client server comunications chapter. It has a section dedicated to DRDA. You have to setup an IDS port for use with this protocol. Then you can do as Gopal told you... Currently we cannot run distributed queries between the two servers, so you have to put the data through the client... Regards. On Tue, Feb 24, 2009 at 10:12 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Thanks ... does anyone have this working ... and does anyone know where > it's documented ..which manual ... Thanks again .... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > From: > "Obnoxio The Clown" <obnoxio@serendipita.com> > To: > ids@iiug.org > Date: > 02/24/2009 04:19 PM > Subject: > Re: Gateway ... [15010] > Sent by: > ids-bounces@iiug.org > > Peter_Logan@spartanstores.com wrote: > > Can anyone give me there impressions of the gateway products ... I need > > to get a bunch of IDS data into DB2 on the mainframe ... and back to IDS > > > .... Developers are wanting to look at IDS data from DB2 and vice versa > > .... > > > > IDS ... 11.50.fc3 - Aix 5.3 > > > > DB2 v8 - OS 360 > > > > If someone else has a better solution please let me know .... > > You *should* be able to just use the CSDK (or JDBC or ODBC). The CSDK > has got DRDA built into it now. > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016e6de17a7029b020463b397d6