Rebuild Large Table with New Extents

Question:
What is the best way to backup and/or unload a table and restore/reload to a new dbtable with new extents?

Answer:
If you have enough drive space, do an UNLOAD to TABLENAME.UNL select * from tablename. If you can, turn logging off during this operation. Then reload with load from tablename.unl insert into tablename, after you’ve rebuilt tablename.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: