What is the difference between load and import in db2?

What is load in Db2?

Efficiently loads large amounts of data into a DB2® table. The LOAD command loads data at the page level, bypasses trigger firing and logging, and delays constraint checking and index building until after the data is loaded into the DB2 table.

What is import utility in Db2?

The import utility inserts data from an input file into a table or a view. The utility performs inserts as if it was executing INSERT statements.

What is load replace in Db2?

To replace data with LOAD: Specify the REPLACE option in the LOAD utility control statement. This option specifies that all data in the table space is to be replaced. Alternatively, you can load new records into a table space without deleting the existing rows by using the RESUME option.

Which methods can be used to load data into a Db2 hosted table?

You can use several methods to load data into Db2 tables.Loading data with the LOAD utility. ... Loading data by using the INSERT statement. ... Loading data from DL/I.