What is import utility in db2?

What is load utility in DB2?

The LOAD utility loads records into the tables and builds or extends any indexes that are defined on them. If the table space already contains data, you can choose whether you want to add the new data to the existing data or replace the existing data.

What is difference between import and load in DB2?

Statistics can be gathered during the load operation if all the data in the table is being replaced. You can import into a host database through Db2 Connect. You cannot load into a host database. Import files must exist on the client from which the import utility is invoked.

What is import command?

Inserts data from an external file with a supported file format into a table, hierarchy, view or nickname. LOAD is a faster alternative, but the load utility does not support loading data at the hierarchy level.

Which utility is used to load or import existing data files into the database?

Data Pump Import (hereinafter referred to as Import for ease of reading) is a utility for loading an export dump file set into a target system. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information.