Improvements to DROP PENDING CHANGES
You can remove pending table space definition changes that are not yet materialized by using the ALTER TABLESPACE statement with the DROP PENDING CHANGES clause. In Db2 11, this statement now resets advisory REORG-pending (AREOR) status.
In earlier versions of Db2, this statement does not reset the AREOR status for the affected object, even though it removes the pending changes. Therefore, if you use automated tools, this remaining AREOR status might trigger unnecessary REORG utility jobs for objects that no longer have any pending changes.
In Db2 11, an ALTER TABLESPACE statement with the DROP PENDING CHANGES clause resets any AREOR status. The only exception is hash tables that are still in a transition state to become a hash table. (The table was altered from non-hash to hash without an online REORG.) In this case, AREOR status is not reset.