A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?
Enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY will result in all data, both new and existing, being compressed. The KEEPDICTIONARY option instructs the command to retain and utilize the existing compression dictionary, thus compressing the data that was present before the reorganization as well as any new data added afterwards.
The correct answer is A. Existing data is compressed. New data will be compressed. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html