What is load in Db2?
The LOAD command 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 load and unload in Db2?
About this task. When you need to change a DB2 table, for example by adding a column, you can save the existing data by using the DB2 Unload utility. After the change to the table, you then reload the table using the Load utility. Using Unload and Load with no change reorganizes the data.
What is the difference between load and import?
The following table summarizes the important differences between the Db2® load and import utilities. Slow when moving large amounts of data. Intra-partition parallelism can only be achieved through concurrent invocations of the import utility in ALLOW WRITE ACCESS mode. …
What is load resume in Db2?
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.
What is load utilities in mainframe?
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. … The LOAD utility accepts encrypted input data sets.
What does the unload utility allow you to unload?
The UNLOAD online utility copies data from one or more source objects to one or more BSAM sequential data sets in external formats. The output records that the UNLOAD utility writes are compatible as input to the LOAD utility. Therefore, you can use this output to reload the original table or different tables.