Re: IDS 10 erratic run times and slow ontape

It could impact the "KAIO disabled" performance which was mentioned in the backup and restore comments. --- scottishpoet <dryburghj@yahoo.com> wrote: > if there is no performance problem (ie its not > eratic) then i don't > believechanging the AIO VPs will have any effect. > Don't really want to > make AIO eratic! > > > > > TBP wrote: > > Neil Truby wrote: > > >>Neil Truby wrote: > > >> > > >>>"Neil Truby" <neil.truby@ardenta.com> wrote in > message > > >>>news:3polnvFbicgoU1@individual.net... > > >>> > > >>>>"Neil Truby" <neil.truby@ardenta.com> wrote in > message > > >>>>news:3pliprFb403pU1@individual.net... > > >>>> > > >>>>>IDS 10.0FC3 on Solaris 2.9 > > >>>> > > >>>>I conclude that our problem is with kaio and > v10 at our installation. > > >>> > > >>>IBM case 439918 refers. We have been sent some > tuning suggestions for > > >>>the > > >>>actual test. I am a little wary of this since > the problem is not really > > >>>that the test (CREATE CLUSTER INDEX) runs > slowly all the time, but that > > >>>it > > >>>is sporadically slow with kaio enabled *only*. > But more testing and more > > >>>information certainly can't hurt ... > > >>> > > >>>In the meantime we've disabled kaio on the > databse servers and discovered > > >>>another problem. With kaio disabled the > backups are perhaps 75% longer > > >>>(35 > > >>>minutes instead of 20), but the *restore* runs > 40 times more slowly (444 > > >>>pages/second without kaio ; 10093 with kaio, > that is 7.5 hours vs 20 mins > > >>>for the restore). A separate case, 439945, > refers here. > > > > > > > > > > > > "scottishpoet" <dryburghj@yahoo.com> wrote in > message > > > > news:1127748148.419479.255360@g43g2000cwa.googlegroups.com... > > > > > >>if it only occurs with KIO turned on, you may > want to discussed KIO > > >>issues with OS vendor > > > > > > > > > Hmm. Interesting point. If it's confirmed as a > problem with IDS v10 and > > > kaio (it doesn't seem to be a problem with > 9.40FC7), how am I - the poor, > > > ignorant customer - to know if I should get help > from the database vendor or > > > the OS vendor? > > > > > > > > > > What have you got for : > > > > 1. NOAGE? > > > > i.e. when you have a "slow" run, what does ps > -aldef show for the > > oninit's priorities? > > > > 2. How many AIOVPs have you got? > > i.e. Have you got enough when KAIO is disabled. sending to informix-list