The Reorg utility is used to ________ fragmented database objects in DB2.

  • Compact
  • Optimize
  • Rebuild
  • Reorganize
The Reorg utility in DB2 is used to reorganize fragmented database objects such as tables and indexes. It helps to reclaim unused space, improve data access performance, and optimize storage utilization. During the reorganization process, the utility physically reorganizes the data pages, indexes, and other objects, resulting in a more compact and efficient storage layout. 
Add your answer
Loading...

Leave a comment

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