KAIO

we are on AIX 5.3 (at some future point going to 6.1 i think) with informix version 10.fc9 (soon to go to version 11 FC6) and are using AIO. has anyone run into any issues turning on and using KAIO with either informix version using 5.3 for aix (or aix 6.1 for that matter)? years back we had kaio turned on but were using an older version of the DB and the OS was on HP-UX and ran into some issues when migrating to the new OS ( i think the log would say the dreaded "KAIO :out of resources). We are looking at going back to KAIO and looking for feedback, etc Thanks. Tom

That message means you haven't configured enough KAIO resources on your system. Check the product machine notes for details on how to configure it for the specific platform. Also look into FC7 when you plan the upgrade. It's a fixpack with no new features. I hope it to be a very stable release. I have customers running FC6W* without issues and FC7 should be very similar with just some more fixes. As with any other version (or product) please test and ask around by the time you move. Regards. On Sat, Jun 12, 2010 at 4:05 PM, Tom Lehr <tomcaml@gmail.com> wrote: > we are on AIX 5.3 (at some future point going to 6.1 i think) with > informix version 10.fc9 (soon to go to version 11 FC6) and are using > AIO. > has anyone run into any issues turning on and using KAIO with either > informix version using 5.3 for aix (or aix 6.1 for that matter)? > years back we had kaio turned on but were using an older version of > the DB and the OS was on HP-UX and ran into some issues when migrating > to the new OS ( i think the log would say the dreaded "KAIO :out of > resources). We are looking at going back to KAIO and looking for > feedback, etc > Thanks. Tom > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

On Jun 12, 6:21 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > That message means you haven't configured enough KAIO resources on your > system. Check the product machine notes for details on how to configure it > for the specific platform. > > Also look into FC7 when you plan the upgrade. It's a fixpack with no new > features. I hope it to be a very stable release. I have customers running > FC6W* without issues and FC7 should be very similar with just some more > fixes. As with any other version (or product) please test and ask around by > the time you move. > > Regards. > > > > > > On Sat, Jun 12, 2010 at 4:05 PM, Tom Lehr <tomc...@gmail.com> wrote: > > we are on AIX 5.3 (at some future point going to 6.1 i think) with > > informix version 10.fc9 (soon to go to version 11 FC6) and are using > > AIO. > > has anyone run into any issues turning on and using KAIO with either > > informix version using 5.3 for aix (or aix 6.1 for that matter)? > > years back we had kaio turned on but were using an older version of > > the DB and the OS was on HP-UX and ran into some issues when migrating > > to the new OS ( i think the log would say the dreaded "KAIO :out of > > resources). We are looking at going back to KAIO and looking for > > feedback, etc > > Thanks. Tom > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...- Hide quoted text - > > - Show quoted tenxt - Hi Fernando, did You experience any problems having 11.50FC6 (or in particular W4) (SLES 10.3). I'm on this since 3 weeks and we've noticed abnormal memory consumption for informix for sessions for dbworker thread against sysadmin database, IBM came back with no clear answer but sugested going to FC7 - which as You said is just a bunch of bufixes and no features (no new bugs then).

Did you set BATCHREAD_TABLE? If yes unset it. Other than that I haven't seen any problems... Whihc doesn't mean there aren't... Which memory pools do you see growing? Regards. On Sat, Jun 12, 2010 at 9:08 PM, Waldemar Znoinski <wznoinski@gmail.com>wrote: > On Jun 12, 6:21 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > > That message means you haven't configured enough KAIO resources on your > > system. Check the product machine notes for details on how to configure > it > > for the specific platform. > > > > Also look into FC7 when you plan the upgrade. It's a fixpack with no new > > features. I hope it to be a very stable release. I have customers running > > FC6W* without issues and FC7 should be very similar with just some more > > fixes. As with any other version (or product) please test and ask around > by > > the time you move. > > > > Regards. > > > > > > > > > > > > On Sat, Jun 12, 2010 at 4:05 PM, Tom Lehr <tomc...@gmail.com> wrote: > > > we are on AIX 5.3 (at some future point going to 6.1 i think) with > > > informix version 10.fc9 (soon to go to version 11 FC6) and are using > > > AIO. > > > has anyone run into any issues turning on and using KAIO with either > > > informix version using 5.3 for aix (or aix 6.1 for that matter)? > > > years back we had kaio turned on but were using an older version of > > > the DB and the OS was on HP-UX and ran into some issues when migrating > > > to the new OS ( i think the log would say the dreaded "KAIO :out of > > > resources). We are looking at going back to KAIO and looking for > > > feedback, etc > > > Thanks. Tom > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently...- Hide quoted text - > > > > - Show quoted tenxt - > > Hi Fernando, > did You experience any problems having 11.50FC6 (or in particular W4) > (SLES 10.3). > I'm on this since 3 weeks and we've noticed abnormal memory > consumption for informix for sessions for dbworker thread against > sysadmin database, IBM came back with no clear answer but sugested > going to FC7 - which as You said is just a bunch of bufixes and no > features (no new bugs then). > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

On Jun 12, 9:49 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > Did you set BATCHREAD_TABLE? If yes unset it. > Other than that I haven't seen any problems... Whihc doesn't mean there > aren't... Which memory pools do you see growing? > Regards. > > On Sat, Jun 12, 2010 at 9:08 PM, Waldemar Znoinski <wznoin...@gmail.com>wrote: > > > > > > > On Jun 12, 6:21 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > > > That message means you haven't configured enough KAIO resources on your > > > system. Check the product machine notes for details on how to configure > > it > > > for the specific platform. > > > > Also look into FC7 when you plan the upgrade. It's a fixpack with no new > > > features. I hope it to be a very stable release. I have customers running > > > FC6W* without issues and FC7 should be very similar with just some more > > > fixes. As with any other version (or product) please test and ask around > > by > > > the time you move. > > > > Regards. > > > > On Sat, Jun 12, 2010 at 4:05 PM, Tom Lehr <tomc...@gmail.com> wrote: > > > > we are on AIX 5.3 (at some future point going to 6.1 i think) with > > > > informix version 10.fc9 (soon to go to version 11 FC6) and are using > > > > AIO. > > > > has anyone run into any issues turning on and using KAIO with either > > > > informix version using 5.3 for aix (or aix 6.1 for that matter)? > > > > years back we had kaio turned on but were using an older version of > > > > the DB and the OS was on HP-UX and ran into some issues when migrating > > > > to the new OS ( i think the log would say the dreaded "KAIO :out of > > > > resources). We are looking at going back to KAIO and looking for > > > > feedback, etc > > > > Thanks. Tom > > > > _______________________________________________ > > > > Informix-list mailing list > > > > Informix-l...@iiug.org > > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > -- > > > Fernando Nunes > > > Portugal > > > >http://informix-technology.blogspot.com > > > My email works... but I don't check it frequently...- Hide quoted text - > > > > - Show quoted tenxt - > > > Hi Fernando, > > did You experience any problems having 11.50FC6 (or in particular W4) > > (SLES 10.3). > > I'm on this since 3 weeks and we've noticed abnormal memory > > consumption for informix for sessions for dbworker thread against > > sysadmin database, IBM came back with no clear answer but sugested > > going to FC7 - which as You said is just a bunch of bufixes and no > > features (no new bugs then). > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...- Hide quoted text - > > - Show quoted text - Thanks Fernando - I had it enabled since we upgraded to 11.50 and as agreed with support we tweak'ed this parameter. I just disabled it and bounced IDS, I'll let you know in few days did that help. cheers

I should have said this earlier... The parameter can be modified online although it does not affect the sessions already started. Regards. On Sun, Jun 13, 2010 at 10:42 PM, Waldemar Znoinski <wznoinski@gmail.com>wrote: > On Jun 12, 9:49 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > > Did you set BATCHREAD_TABLE? If yes unset it. > > Other than that I haven't seen any problems... Whihc doesn't mean there > > aren't... Which memory pools do you see growing? > > Regards. > > > > On Sat, Jun 12, 2010 at 9:08 PM, Waldemar Znoinski <wznoin...@gmail.com > >wrote: > > > > > > > > > > > > > On Jun 12, 6:21 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > > > > That message means you haven't configured enough KAIO resources on > your > > > > system. Check the product machine notes for details on how to > configure > > > it > > > > for the specific platform. > > > > > > Also look into FC7 when you plan the upgrade. It's a fixpack with no > new > > > > features. I hope it to be a very stable release. I have customers > running > > > > FC6W* without issues and FC7 should be very similar with just some > more > > > > fixes. As with any other version (or product) please test and ask > around > > > by > > > > the time you move. > > > > > > Regards. > > > > > > On Sat, Jun 12, 2010 at 4:05 PM, Tom Lehr <tomc...@gmail.com> wrote: > > > > > we are on AIX 5.3 (at some future point going to 6.1 i think) with > > > > > informix version 10.fc9 (soon to go to version 11 FC6) and are > using > > > > > AIO. > > > > > has anyone run into any issues turning on and using KAIO with > either > > > > > informix version using 5.3 for aix (or aix 6.1 for that matter)? > > > > > years back we had kaio turned on but were using an older version of > > > > > the DB and the OS was on HP-UX and ran into some issues when > migrating > > > > > to the new OS ( i think the log would say the dreaded "KAIO :out of > > > > > resources). We are looking at going back to KAIO and looking for > > > > > feedback, etc > > > > > Thanks. Tom > > > > > _______________________________________________ > > > > > Informix-list mailing list > > > > > Informix-l...@iiug.org > > > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > > > -- > > > > Fernando Nunes > > > > Portugal > > > > > >http://informix-technology.blogspot.com > > > > My email works... but I don't check it frequently...- Hide quoted > text - > > > > > > - Show quoted tenxt - > > > > > Hi Fernando, > > > did You experience any problems having 11.50FC6 (or in particular W4) > > > (SLES 10.3). > > > I'm on this since 3 weeks and we've noticed abnormal memory > > > consumption for informix for sessions for dbworker thread against > > > sysadmin database, IBM came back with no clear answer but sugested > > > going to FC7 - which as You said is just a bunch of bufixes and no > > > features (no new bugs then). > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently...- Hide quoted text - > > > > - Show quoted text - > > Thanks Fernando - I had it enabled since we upgraded to 11.50 and as > agreed with support we tweak'ed this parameter. I just disabled it and > bounced IDS, I'll let you know in few days did that help. > > cheers > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

Has anybody else out there run into this bug? I am running 11.50.FC6 on AIX 5.3 TL11. Case open with IBM for months now, no resolution. The APAR says it was fixed, but it is not and I can reproduce it at will. Joe Plugge **************************************************************** * * USERS AFFECTED: * * * IDS 11.10 and 11.50 users * * **************************************************************** * * PROBLEM DESCRIPTION: * * * In some cases the let statement inside the procedure which * * * is using the dynamic spl feature can give the -661 error * * **************************************************************** * * RECOMMENDATION: * * * Upgrade to IDS 11.50.xC5 and above. * * **************************************************************** Problem conclusion * Problem first fixed in IDS 11.50.xC4.