Which of the following statements is TRUE?
Which of the following statements is TRUE?
REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required. This command provides information on table and index statistics, which helps to assess whether reorganization is necessary to maintain optimal performance.
The correct answer is D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required. The answer A is wring because the command REORG runs tables reorganization and REORCHK provides table or index statistics that indicate whether reorganization might be required.. The answer B is wrong because you can run REORGCHK with the option "UPDATE STATISTICS" or "CURRENT STATISTISCS" The answer C is wrong because you can run REORGCHK with the option "ON TABLE SYSTEM". REFERENCE : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001971.html