Toad World Blog

DB2 for z/OS: Running REORG to Reclaim Disk Space

Mar 26, 2017 4:45:00 PM by Robert Catterall

Think of why you run the DB2 for z/OS REORG utility, and a number of reasons are likely to come quickly to mind: to restore row order per a table's clustering key; to reestablish free space (for inserts and/or for updates ); to remove the AREO* status set for a table space following (for example) an ALTER TABLE ADD COLUMN operation; or to materialize a pending DDL change such as an enlargement of a table space's DSSIZE. How about disk space reclamation? If that REORG motivation has not previously ...read more

Tags: IBM DB2 DB2 z/OS

Robert Catterall

Written by Robert Catterall