Multiple choice technology mainframe

Which of the following utilities would you run to order data and reclaim space from deleted rows in a table:

  1. db2look

  2. db2move

  3. reorg

  4. runstats
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The REORG utility is specifically designed to reorganize table data, reclaiming space from deleted rows and improving access patterns by physically reordering data on disk. db2look is for DDL extraction, db2move is for data movement/export/import, and runstats is for updating table statistics used by the query optimizer. REORG is the correct tool for the stated purpose of space reclamation through data reorganization.

Keep practicing — related questions