best way to fragment existing large table?

Posted in 1999

Matthew H. Devlin III — Tue, 16 Nov 1999 23:51:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Problem: 1 table containing in excess of 19,000,000 rows that is contained in one dbspace, not fragmented(obviously), and with more extents than I care to mention. I need a way to slowly (over the course of several days so as not to interfere with production) fragment the table into multiple dbspaces. I plan on fragmenting by expression. Any ideas

↪ replying to Matthew H. Devlin III

Yuri Dovgart — Sat, 20 Nov 1999 13:20:41 +0300 — source: Informix-list mailing list archive (1991-1998)

Matthew H. Devlin III <mhdevlin@nycap.rr.com> wrote in message news:38323438.C7405AC8@nycap.rr.com... > Problem: > 1 table containing in excess of 19,000,000 rows that is contained in one > dbspace, > not fragmented(obviously), and with more extents than I care to > mention. I need a way to slowly (over the course of several days so as > not to interfere with production) fragment the table into multiple > dbspaces. I plan on fragmenting by expression. > > Any ideas HPL will be the fastest. ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 >

Glossary

dbspace