Re: tbtape question

Posted in 1995

Dan Madvig - Bethel College & Sem. — 3 Jan 1995 16:43:07 -0500 — source: Informix-list mailing list archive (1991-1998)

> > At 09:53 PM 12/23/94 -0500, Borg Boy wrote: > >Question: Will unloading a database using tbunload, then dropping it, and > >loading it back in using tbload defrag the tables? > > Jon Vemo sez: > NO. tbunload performs a binary unload of each page, page for page. Any > fragmentation which existed before, will still be there after tbload'ing. > I thought 'tbunload,drop,tbload' was one of the sanctioned methods for defragging disc space. What does one use? -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 " , ." - Marcel Marceau