Re: comp.databases.kerry.sainsbury and tbtape

In article c0d@newsbf01.news.aol.com, inxutil@aol.com (Inxutil) writes: >Here's a legitimate question: > >If the data base is fragmented as it sits physically on the disk, does >the tbtape PROCESS unfragment the data as it is streamed to the >tape? > >Or is it streamed block by block in its fragmented condition? > >Would streaming it back to the disk if it WAS unfragmented to the >tape be refragmented if the extents were not big enough? > >Why would I ask? Cause maybe I'm gonna reformat the hard drive(s) >and restore the data base and wonder if maybe the data will be >restored in an UNfragmented form even if the extents are not up to >par. ( Yes maybe I should recreate the db with new extents ... :- ) No defragmentation occurs. Tbtape copies page images from disk to tape. Included with each page image is the page address, which translates to a physical location on disk. So, after restoring from tbtape, your chunks will look exactly the same. If you want to resize your table extents, you should use dbexport/dbimport. ---------------------------------------------------------------------------- Bill Glidden Sr. Advanced Support Engineer E-mail: glidden@informix.com Advanced Support (415) 926-6904 Informix Software, Inc. ----------------------------------------------------------------------------