Exam C2090-600 All QuestionsBrowse all questions from this exam
Question 51

Which statement about the db2move command is TRUE?

    Correct Answer: D

    Loading data into tables containing XML columns is only supported for the LOAD actions. This means that the LOAD action is the appropriate method to use when dealing with tables that have XML columns, as other actions like COPY do not support this functionality. The limitations associated with GENERATED ALWAYS identity columns and the ability to change object ownership further rule out the other options as being true.

Discussion
db2testerOption: D

The answer B is wrong, because you can use "OWNER" clause to allow the user to change the owner of each new object created in the target schema after a successful COPY. The default owner of the target objects will be the connect user; if this option is specified, ownership will be transferred to the new owner. This is an optional option available to the COPY action. The answer C is not correct, because Tables that contain GENERATED ALWAYS identity columns cannot be imported or loaded using db2move. You can, however, manually import or load these tables. The answer D is correct, Loading data into tables containing XML columns is only supported for the LOAD and not for the COPY action. The workaround is to manually issue the IMPORT or EXPORT commands, or use the db2move Export and db2move Import behaviour. If these tables also contain GENERATED ALWAYS identity columns, data cannot be imported into the tables. REFERENCE : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002079.html SEE "Usage Notes" paragraph