RE: IDS 9.20.UC4 Error Message
Starts from a spurious "Error Writing 'Universal Server Message Log' errno = 0" after upgrading from IDS 7.3 to 9.20.UC4; it's confirmed as a bogus/cosmetic message Informix planned to fix in 9.3x (permissions on online.log were also suggested as a check). The thread then turns into a warning about 9.20 on AIX 4.3.2: poor performance under load, varchar-related crashes (fixed in UC4X1) and bad tempdb page headers, leading one poster to roll back to 7.31.UC7. Another saw slowdowns only after upgrading ESQL/C and 4GL (7.30.UC4), with the case still open at Informix, plus a complaint that GL_DATETIME overrides per-variable datetime qualifiers. No resolution is recorded for the performance or GL_DATETIME issues.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Are these issues concerning for AIX particular or for 9.2 in general??? (Hopefully, for AIX in particular . . . ) > -----Original Message----- > From: Jay Konigsberg [mailto:JayKonigsberg@email.msn.com] > Sent: Thursday, September 21, 2000 11:41 PM > To: informix-list@iiug.org > Subject: Re: IDS 9.20.UC4 Error Message > > > This is a bogus error message. Informix knows about it and > will fix it in > 9.3x. > > However, I should warn you: Informix 9.20.UC4 for AIX 4.3.2 > has several > MAJOR bugs. After spending > three months on 9.20.UC4 (& UC4X1) we are reverting back to 7.31.UC7. > > Informix tech support has (finally) admitted that to do the > same job, 9.2 > uses more resources than 7.3. > > The three worst things about 9.2: > - performance under load is poor and it loads up easily. > - engine crashes is you use a lot of varchars (fixed with > the UC4X1 > release) > - there is a problem with the tempdbs writing a bad page > header (crashes > applications, not the engine). > > Unless you have the money to spend on extra hardware, the 9.2 > release isn't > worth it. > > (Note, I will miss Java SP's, fuzzy checkpoints, 128 char > filenames & a few > other really nice features. > Its just not ready yet) > > "Jonathan Leffler" <jleffler@earthlink.net> wrote in message > news:39C89B1D.E3EC79CC@earthlink.net... > > "howard.jones" wrote: > > > > > I have just upgraded one of our systems from IDS 7.3 to > IDS 9.20.UC4. > All > > > went according to plan except we now get the following > error when we > reset > > > the engine. > > > > > > "Error Writing 'Universal Server Message Log' errno = > 0/informix/online.log > > > Error Writing 'Universal Server Message Log' errno = > 0/informix/online.log" > > > > > > Can anyone shed any light? > > > > What are the permissions on /informix/online.log? > > > > > > Reporting errno=0 is odd, at best. > > > > -- > > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > > Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN > > #include <disclaimer.h> > > > > > >
The performance issues are generic to 9.20, it is the reason they are holding up 9.3. The rest may very well be problems with the AIX port. "John Carlson" <John_Carlson@whsmithusa.com> wrote in message news:8qggce$qne$1@news.xmission.com... > > Are these issues concerning for AIX particular or for 9.2 in general??? > > (Hopefully, for AIX in particular . . . ) > > > -----Original Message----- > > From: Jay Konigsberg [mailto:JayKonigsberg@email.msn.com] > > Sent: Thursday, September 21, 2000 11:41 PM > > To: informix-list@iiug.org > > Subject: Re: IDS 9.20.UC4 Error Message > > > > > > This is a bogus error message. Informix knows about it and > > will fix it in > > 9.3x. > > > > However, I should warn you: Informix 9.20.UC4 for AIX 4.3.2 > > has several > > MAJOR bugs. After spending > > three months on 9.20.UC4 (& UC4X1) we are reverting back to 7.31.UC7. > > > > Informix tech support has (finally) admitted that to do the > > same job, 9.2 > > uses more resources than 7.3. > > > > The three worst things about 9.2: > > - performance under load is poor and it loads up easily. > > - engine crashes is you use a lot of varchars (fixed with > > the UC4X1 > > release) > > - there is a problem with the tempdbs writing a bad page > > header (crashes > > applications, not the engine). > > > > Unless you have the money to spend on extra hardware, the 9.2 > > release isn't > > worth it. > > > > (Note, I will miss Java SP's, fuzzy checkpoints, 128 char > > filenames & a few > > other really nice features. > > Its just not ready yet) > > > > "Jonathan Leffler" <jleffler@earthlink.net> wrote in message > > news:39C89B1D.E3EC79CC@earthlink.net... > > > "howard.jones" wrote: > > > > > > > I have just upgraded one of our systems from IDS 7.3 to > > IDS 9.20.UC4. > > All > > > > went according to plan except we now get the following > > error when we > > reset > > > > the engine. > > > > > > > > "Error Writing 'Universal Server Message Log' errno = > > 0/informix/online.log > > > > Error Writing 'Universal Server Message Log' errno = > > 0/informix/online.log" > > > > > > > > Can anyone shed any light? > > > > > > What are the permissions on /informix/online.log? > > > > > > > > > Reporting errno=0 is odd, at best. > > > > > > -- > > > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > > > Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN > > > #include <disclaimer.h> > > > > > > > > > >
Jay Konigsberg wrote in message ... >The performance issues are generic to 9.20, it is the reason they are >holding up 9.3. The rest may very well be problems with the AIX port. > Have you tried 9.21?
"smooth1" <smooth1@iclway.co.uk> wrote in message news:39d275cd$1_2@news2.vip.uk.com... > > Jay Konigsberg wrote in message ... > >The performance issues are generic to 9.20, it is the reason they are > >holding up 9.3. The rest may very well be problems with the AIX port. > > > > Have you tried 9.21? > No, we finished the rollback to 7.31 last Friday night. I'm running a commerce web site and require stability and performance through the Christmas period. Besides, 9.21 was never ported to AIX.
"Jay Konigsberg" <JayKonigsberg@email.msn.com> wrote: >The performance issues are generic to 9.20, it is the reason they are >holding up 9.3. The rest may very well be problems with the AIX port. > We udgraded our AIX from 7.22 to 9.20 in two steps, first the engine then ESQL/C and 4GL (from 6 to 7). We have the very same problems, especially on mass-selects, but they didn't start *until we installed the new ESQL/4GL*. When we only upgraded the engine there were no problem (of a performance nature, some of the other changes meant we had to do some tweaks). The case is currently at Informix for evaluation in a testcase. What irritates me more is the way GL_DATETIME overrides the <from> and <to> tags on CURRENT, making GL_DATETIME totally useless, well I'll properly have to get used to have the year in front even though it is vary unDanish. //FETheodorsen Finn E. Theodorsen///finn@theodorsen.org///AtCbM///Legend#60219605 J-M-B Type: INTP. Homepage: http://www.theodorsen.org All advertisments sent to the above address will be treated as requests for computer support, and charged accordingly. Sending these kind of messages equals an acceptance of these terms. The minimum fee is $500.
Which version of 4gl did you go to 7..??.??? 7.30.UC4 is the latest and should be the most stable. Finn E. Theodorsen wrote in message <39d82798.2035012@news.uni2.dk>... >"Jay Konigsberg" <JayKonigsberg@email.msn.com> wrote: > >>The performance issues are generic to 9.20, it is the reason they are >>holding up 9.3. The rest may very well be problems with the AIX port. >> > >We udgraded our AIX from 7.22 to 9.20 in two steps, first the engine >then ESQL/C and 4GL (from 6 to 7). > >We have the very same problems, especially on mass-selects, >but they didn't start *until we installed the new ESQL/4GL*. > >When we only upgraded the engine there were no problem >(of a performance nature, some of the other changes meant >we had to do some tweaks). > >The case is currently at Informix for evaluation in a testcase. > >What irritates me more is the way GL_DATETIME overrides >the <from> and <to> tags on CURRENT, making GL_DATETIME >totally useless, well I'll properly have to get used to have the year >in front even though it is vary unDanish. > >//FETheodorsen > > > >Finn E. Theodorsen///finn@theodorsen.org///AtCbM///Legend#60219605 >J-M-B Type: INTP. Homepage: http://www.theodorsen.org > >All advertisments sent to the above address will be >treated as requests for computer support, and charged >accordingly. Sending these kind of messages equals an >acceptance of these terms. The minimum fee is $500.
About the GL_DATETIME bug Err?? Can you give me an example?? > >Finn E. Theodorsen///finn@theodorsen.org///AtCbM///Legend#60219605 >J-M-B Type: INTP. Homepage: http://www.theodorsen.org > >All advertisments sent to the above address will be >treated as requests for computer support, and charged >accordingly. Sending these kind of messages equals an >acceptance of these terms. The minimum fee is $500.
"smooth1" <smooth1@iclway.co.uk> wrote: > >Which version of 4gl did you go to > >7..??.??? > >7.30.UC4 is the latest and should be the most stable. > 7.30 UC4 exatcly and 9.30 UC1 in ESQL Finn E. Theodorsen///finn@theodorsen.org///AtCbM///Legend#60219605 J-M-B Type: INTP. Homepage: http://www.theodorsen.org All advertisments sent to the above address will be treated as requests for computer support, and charged accordingly. Sending these kind of messages equals an acceptance of these terms. The minimum fee is $500.
"smooth1" <smooth1@iclway.co.uk> wrote: > >About the GL_DATETIME bug >Err?? Can you give me an example?? > > GL_DATETIME="%d-%m-%Y %H:%M:%s" a.out Now input from eg. a form into a variable of type datetime year to year, width a field width of 4 will look funny. Current hour to minute gives the full year etc. as given in the GL_DATETIME etc. If GL_DATETIME isnt defined the standard format is used where no other is given, but any use of <variable> hour to minute etc. functions as it should. But as soon as GL_DATETIME is defined it is used everywhere, even when you try just to use a limited scope of fields. Try eg. define a datetime hour to minute b char(20) let a = current hour to minute display a let b = a display b let b = current year to year display b both with and wothout a GL_DATETIME //Finn Finn E. Theodorsen///finn@theodorsen.org///AtCbM///Legend#60219605 J-M-B Type: INTP. Homepage: http://www.theodorsen.org All advertisments sent to the above address will be treated as requests for computer support, and charged accordingly. Sending these kind of messages equals an acceptance of these terms. The minimum fee is $500.