tbtape question

Bill Glidden wrote : >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. Tim Schaefer writes: Bill, Thanks for the information. This is what I was suspecting... My solution is actually going to use the safe method of unloading each table using the unload command in a unix for-loop with a list of tables. ( Maybe I'm paranoid but I don't trust dbimport and dbexport. ) Once the tables are unloaded I will then recreate the data base by dropping it, and using a new schema-script with new extents created with an extent-calculator I wrote that uses the recipe from the 4.1 manual. I'm going to also put a couple of the bigger tables in their own dbspaces as a further refinement. The 5.0 Administrator's guide, and the SQL Tutorial have been quite helpful. I have to say INFORMIX has done a good job of improving their documentation---but don't stop now, keep up the good work! Happy Holidays! PS. I also appreciate Cathy Cipps' comments and Clem about extents and such. Thanks Cathy... And a thanks also to Clem Akins at Reynolds Metals Tim Schaefer The Computer Business Co. Ft. Lauderdale, FL