Re: Connection Manager and I4GL
2009/8/13 Obnoxio The Clown <obnoxio@serendipita.com>: > Keith Simmons wrote: >> All >> >> Following 'recent' issues (this week and 15 months ago !!) management >> have decided we need some fail-over mechanism in place for when the >> database 'locks up'. >> IDS HDR is the obvious candidate but I need to get my head around how >> an application can seamlessly fail-over from primary to secondary. I'm >> investigating Connection Manager for our ancillary applications that >> use ODBC/JDBC/PHP etc., but the application that runs our busines is >> written in I4GL running on 'green screens'. My understanding is that >> Connection Manager cannot be used with I4GL, is this correct? If so >> does any one know of an application that provides similar >> functionality to enable auto-switching between databases, how do other >> people get around this issue? >> Thanks. > > None of these will fail over without some application coding. In your > particular case, I'd guess setting up HDR in a group and connecting to > the group would be the easiest, although you'd still have to code the > reconnect / retry into your code. ;o( > > I can't see any reason why you couldn't use the CM with 4GL, but I have > to say I've never tried it (or even thought of trying it.) > > -- > 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. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Red Book SG24-7488-01, Informix Dynamic Server 11: Extending Availability and Replication specifically states client applications need to be using CSDK 3.5 in order to use CM, I did not think I4GL used any form of CSDK, and even if it does, the version of I4GL released afer CSDK 3.5 (which therefore might contain it) is not available for AIX !!! I can stand user sessions being terminated provided they could log in straight away to the backup engine without any administrator intervention either on the server, the PC or the DNS/hosts setup. Keith
Keith Simmons wrote: > 2009/8/13 Obnoxio The Clown <obnoxio@serendipita.com>: >> Keith Simmons wrote: >>> All >>> >>> Following 'recent' issues (this week and 15 months ago !!) management >>> have decided we need some fail-over mechanism in place for when the >>> database 'locks up'. >>> IDS HDR is the obvious candidate but I need to get my head around how >>> an application can seamlessly fail-over from primary to secondary. I'm >>> investigating Connection Manager for our ancillary applications that >>> use ODBC/JDBC/PHP etc., but the application that runs our busines is >>> written in I4GL running on 'green screens'. My understanding is that >>> Connection Manager cannot be used with I4GL, is this correct? If so >>> does any one know of an application that provides similar >>> functionality to enable auto-switching between databases, how do other >>> people get around this issue? >>> Thanks. >> None of these will fail over without some application coding. In your >> particular case, I'd guess setting up HDR in a group and connecting to >> the group would be the easiest, although you'd still have to code the >> reconnect / retry into your code. ;o( >> >> I can't see any reason why you couldn't use the CM with 4GL, but I have >> to say I've never tried it (or even thought of trying it.) >> >> -- >> 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. >> >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> > Red Book SG24-7488-01, Informix Dynamic Server 11: Extending > Availability and Replication specifically states client applications > need to be using CSDK 3.5 in order to use CM, I did not think I4GL > used any form of CSDK, and even if it does, the version of I4GL > released afer CSDK 3.5 (which therefore might contain it) is not > available for AIX !!! It does use CSDK as specified in the product release notes. It also should be compatible with a specific version *and above* This means you could install a newer CSDK on the same directory. (Cesar installed in a different one). You just need to follow the product installation order documented in the tools (4GL) release notes (CSDK should be installed after the 4GL product) Regards.