DB2 10 for z/OS Database Administrator — Question 20

Which options are valid for an online reorganization operation?

Answer options

• A. FULL and RECLAIM EXTENTS
• B. CLASSIC and RECLAIM EXTENTS
• C. FULL and CLEANUP OVERFLOWS
• D. CLEAN OVERFLOWS and RECLAIM EXTENTS

Correct answer: A

Explanation

Option A is correct because 'FULL' and 'RECLAIM EXTENTS' are both recognized options for online reorganization. The other choices include terms that are either incorrect or not applicable to online reorganization operations.