Re: reorg

Posted in 2000

David Kulkarni — Fri, 12 May 2000 09:46:41 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

While running tbcheck -pe I noticed that our alot of the tables are over 8 extents and I understand that is not so good. I want to be able to reduce the # of extents and set the parameter while doing the import so the extent size is larger so the tables don't get that fragmented. TIA --- "Art S. Kagel" <kagel@bloomberg.net> wrote: > David Kulkarni wrote: > > > Can somebody help me with step-by-step > instructions on > > how to do a reorg on Informix 5.10UC5. I would > > greatly appreciate it. I have just taken over the > > system and am new to this. The box is running > HP-UX > > 10.20. > > Explain what you mean by reog? Do you mean > compacting fragmented tables? > Do you mean load balancing disk access? Do you mean > redesigning the > schema? What? > > First recommendation? Upgrade to 7.31 or 9.20. > > Art S. Kagel > > __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/