DB2 10 for z/OS Database Administrator — Question 40

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

Answer options

• A. It does not acquire locks on the table
• B. It does not require additional temporary disk space
• C. It enables the user to control when the table will be offline
• D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

Correct answer: D

Explanation

The correct answer is D because performing the ADMIN_MOVE_TABLE operation in multiple steps is essential for compatibility with High Availability Disaster Recovery (HADR) environments. The other options are incorrect since the operation can still acquire locks, might require temporary disk space, and does not inherently provide control over the table's offline status.