The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
To resolve the problem without preventing users from changing data in the SALES table, the command should allow write access while resetting the compression dictionary. The command 'REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY' meets this criteria, as it resets the dictionary and permits ongoing write access during the reorganization process. This ensures minimal disruption to the database operations while optimizing performance by creating a new, efficient compression dictionary.
Correct Answer is C. ALLOW WRITE ACCESS . Allows write access to the table during reorganization. This behavior is the default.https://www.ibm.com/docs/en/db2/11.5?topic=commands-reorg-table#sdx-synid_allow_write_access
Correct Answer is C, with inplace we can't specify RESETDICTIONARY. Command in option A will give error when executed
The clause "REBUILDDICTIONARY" does not exist. The answer B and D are note correct.
The correct answer is A, the inplace option Rearranges the table while allowing user access. And the RESETDICTIONARY option if the COMPRESS attribute of the table is YES, a new row compression dictionary is constructed. https://www.ibm.com/support/knowledgecenter/es/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html