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.