Re: Disk Bottleneck on HP-9000 and Informix 5.07

Does 5.07 support fragmentation? If so, try fragmenting your tables so that you can better spread the access over your disks. Think of Informix fragmentation as a the ability to stripe your data across physical media. If Informix 5.07 doesn't have fragmentation then never mind... John Carlson wrote: > Shaun Mumford wrote: > > > > We have an HP-9000 K260 2 way, with the database on 4 2gb FWD disks off > > a single controller in a High Availability Chasis. > > > > 2 of the disks are showing at 100% utilization most of the time, with > > the other 2 at 20%. > > > > We are using raw disk space, so can not use disk striping to try and > > balance the load. We are thinking about creating more than one dbspace > > and attempting to load the main tables in a more balanced way. > > > > The database is about 6GB in size. > > > > Any suggestions for either monitoring the system to narrow down the > > specific problem areas, or for general tuning. We have Standard Informix > > 5 utilities and HP Glance. > > > > Sorry for the confusion, please post a copy of your TBCONFIG file. > > John "living in a 7.23 world" Carlson > Informix DBA > WH Smith, Inc. -- Bryan Hughes Chief Systems Architect - Transaction Systems Wells Fargo Bank bryanhughes@earthlink.net hughesb@wellsfargo.com "I wonder how much deeper the ocean would be without sponges?"