Bind files used by the export, import, and load utilities
The following table lists bind files with their default isolation levels, as well as which utilities use them and for what purpose.
| Bind File (Default Isolation Level) | Utility/Purpose |
|---|---|
| db2ueiwi.bnd (CS) | Import/Export. Used to query information about table columns and indexes. |
| db2uexpm.bnd (CS) | Export. Used to fetch from the query specified for the export operation. |
| db2uimpm.bnd (RS) | Import. Used to insert data from
the source data file into the target table when INSERT, REPLACE or
REPLACE_CREATE option is used. Note: Note: The CREATE and REPLACE_CREATE
options of the IMPORT command are deprecated and might be removed
in a future release.
|
| db2uipkg.bnd (CS) | Import. Used to check bind options. |
| db2ucktb.bnd (CS) | Load. Used to perform general initialization processes for a load operation. |
| db2ulxld.bnd (CS) | Load. Used to process the query provided during a load from cursor operation. |
| db2uigsi.bnd (RS on UNIX based systems, RR on all other platforms) | Import/Export. Used to drop indexes and check for referential constraints for an import replace operation. Also used to retrieve identity column information for exporting IXF files. |
| db2uqtpd.bnd (RR) | Import/Export. Used to perform processing for hierarchical tables. |
| db2uimtb.bnd (RS) | Import. Used to perform general initialization processes for an import operation. |
| db2uImpInsUpdate.bnd (RS) | Import. Used to insert data from the source data file into the target table when INSERT_UPDATE option is used. Cannot be bound with the INSERT BUF option. |
| db2uiDescribe.bnd (RS) | Import/Export. Used to query information about the definition and properties of a table being processed. For example, a wrapper module to perform an SQL DESCRIBE on a table being processed. |