RE: How to reduce extents 5.x OnLine

>Saeid Yazdanmehr writes... >I am wondering if anybody has done the follwoing: >1) Trying to reduce Extents for performance improvement on an Informix >database version 5.0. Simply use tbunload/tbload. This compresses the extents and OnLine handles the compressed extents as 1. If your database is Ansi mode then you need to reset it after tbload/ing. >2) any other issues that we can use to improve the performance of Informix >online in an hp-ux version 9.04 environment. Lots of suggestions in the FAQ. Seperate logs from rootdbs, get a better balance on your disk reads/writes (tbstat -D output). Increase Buffers to get more usage of cache (tbstat -p output). Update Statistics. Improve sql statements. and, and, and... >3) Can also someone tell me how to move the raw partition of informix to >another location without having to re-install the informix I have usually used dbexport/dbimport I *think* you can do it using tbunload/tbload too. Anybody else know this one ?? >Thanks My pleasure, Tom Hogarty < STANDARD DISCLAIMERS APPLY > SNI, Germany e-mail : hogarty.pad@sni.de Tel : +49-5251-8-22602 ($WORK) Tel : +49-5254-65553 ($HOME)