Re: Disk I/O problems? I think .....

First, the simple answer. KIO is kernal asynchronous I/O. Now to your other problem - what does your database structure look like? How many dbspaces do you have? What does an onstat -D show? I'm not a big fan of Raid5 for database applications in any event...... Vic Pat Militzer wrote: > Hi there, > > We think we are having disk i/o problems, our vendor doesn't see any > problems, wondering if someone hs any suggestions. > > We are running a Sun UltraEnterprise 4000 with a Raid5 Disk Array from > Storage Computer. The raid5 disk array is made 8 drive plus 1 extra drive > for parity. OS is Solaris 2.5.1. We are seeing high busy times and high > service times on the informix partitions. > > When we do a onstat -g ioq we get the follow results: > INFORMIX-OnLine Version 7.23.UC4 -- On-Line -- Up 21 days 22:37:46 -- > 425008 K > bytes > > AIO I/O queues: > q name/id len maxlen totalops dskread dskwrite dskcopy > kio 0 0 0 0 0 0 0 > kio 1 0 22 71825973 69574788 2251185 0 > kio 2 0 0 0 0 0 0 > kio 3 0 25 68454336 66215030 2239306 0 > kio 4 0 32 80282323 77885793 2396530 0 > kio 5 0 29 57388417 55256400 2132017 0 > adt 0 0 0 0 0 0 0 > msc 0 0 1 769 0 0 0 > aio 0 0 1 70 8 2 0 > pio 0 0 1 1 0 0 0 > lio 0 0 0 0 0 0 0 > gfd 3 0 1 1 1 0 0 > gfd 4 0 1 1 1 0 0 > gfd 5 0 0 0 0 0 0 > gfd 6 0 0 0 0 0 0 > gfd 7 0 0 0 0 0 0 > gfd 8 0 0 0 0 0 0 > gfd 9 0 1 2 2 0 0 > gfd 10 0 0 0 0 0 0 > gfd 11 0 0 0 0 0 0 > gfd 12 0 0 0 0 0 0 > gfd 13 0 0 0 0 0 0 > gfd 14 0 0 0 0 0 0 > gfd 15 0 0 0 0 0 0 > gfd 16 0 0 0 0 0 0 > gfd 17 0 0 0 0 0 0 > gfd 18 0 0 0 0 0 0 > gfd 19 0 0 0 0 0 0 > gfd 20 0 0 0 0 0 0 > gfd 21 0 0 0 0 0 0 > gfd 22 0 0 0 0 0 0 > gfd 23 0 0 0 0 0 0 > gfd 24 0 0 0 0 0 0 > gfd 25 0 0 0 0 0 0 > gfd 26 0 0 0 0 0 0 > gfd 27 0 0 0 0 0 0 > gfd 28 0 0 0 0 0 0 > gfd 29 0 0 0 0 0 0 > gfd 30 0 0 0 0 0 0 > gfd 31 0 0 0 0 0 0 > gfd 32 0 0 0 0 0 0 > gfd 33 0 0 0 0 0 0 > gfd 34 0 0 0 0 0 0 > gfd 35 0 0 0 0 0 0 > gfd 36 0 0 0 0 0 0 > gfd 37 0 0 0 0 0 0 > gfd 38 0 0 0 0 0 0 > gfd 39 0 0 0 0 0 0 > gfd 40 0 0 0 0 0 0 > gfd 41 0 0 0 0 0 0 > gfd 42 0 0 0 0 0 0 > gfd 43 0 0 0 0 0 0 > gfd 44 0 0 0 0 0 0 > > Does anyone know what 'kio' stands for? And I have read that if the max > len is in double digits then you may have i/o problem. Any suggestions? > > Thank in advance, > > Pat Militzer > pmilitzer@ultracom.com -- Vic Goldberg Manager, DBA Team, Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)