How to Understand DB2 Load Vs Import

Special register: A storage area that is defined for an application process by DB2 and is used to store information that can be referenced in SQL statements. Examples of a “special register” are CURRENT TIMESTAMP or CURRENT USER.

Load vs Import

The INSERT statement lets you insert a row or several rows of data into the table. The LOAD utility, intended for loading large volumes of data, places rows directly onto data pages, maintains indexes in bulk rather than row-by-row, and has the capability to avoid logging.

In Linux, UNIX, and Windows provides an IMPORT utility to insert rows from a file of data. It uses INSERT statements, and is designed for loading small amounts of data.

Related posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.