DB2 10 for z/OS Database Administrator — Question 36

Which of the following statements is TRUE?

Answer options

• A. REORGCHK automatically runs tables reorganization.
• B. REORGCHK uses only current table and index statistics.
• C. REORGCHK can only be used for user tables, not for system tables.
• D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

Correct answer: B

Explanation

Option B is correct because REORGCHK indeed uses only the current statistics of tables and indexes to evaluate fragmentation. Option A is incorrect as REORGCHK does not automatically run reorganization; it simply analyzes the need for it. Option C is false since REORGCHK can also be applied to system tables. Option D is misleading because while REORGCHK assesses fragmentation, it does not directly indicate a need for reorganization.