When should the Reorg utility be used in DB2?

  • After extensive data deletion
  • To create a new table space
  • To optimize SQL queries
  • To update database schema
The Reorg utility in DB2 is typically used after extensive data deletion, which leaves the table fragmented. Reorganization rearranges the data physically, eliminating fragmentation and reclaiming space, thus improving performance. It's not used to create new table spaces, update schema, or optimize queries. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *