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

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

    Correct Answer: A

    To copy large object data values into a table in the shortest amount of time, the appropriate utility to use is LOAD. The LOAD utility is designed to efficiently move large quantities of data, including large objects (LOBs), into tables. It is faster than the IMPORT utility because LOAD writes formatted pages directly into the database, bypassing the need for SQL INSERTs, which makes the process quicker. Additionally, LOAD does not fire triggers and does not perform referential integrity or table constraint checks, further speeding up the process.

Discussion
db2testerOption: A

The correct answer is A. LOAD. Indeed, the load utility is capable of efficiently moving large quantities of data into newly created tables, or into tables that already contain data. The utility can handle most data types, including XML, large objects (LOBs), and user-defined types (UDTs). The load utility is faster than the import utility, because it writes formatted pages directly into the database, while the import utility performs SQL INSERTs. The load utility does not fire triggers, and does not perform referential or table constraints checking (other than validating the uniqueness of the indexes). REFERENCE : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dm.doc/doc/c0004587.html