DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
The following tables summarize some of the key similarities and differences between the ingest, import, and load utilities.
| Table type | Ingest | Load | Import |
|---|---|---|---|
| Detached table | not supported | not supported | not supported |
| Global temporary table | not supported | not supported | not supported |
| Multidimensional clustering (MDC) or insert time clustering (ITC) table | supported | supported | supported |
| Materialized query table (MQT) that is maintained by user | supported | supported | supported |
| Nickname | supported | not supported | supported |
| Range-clustered table (RCT) | supported | not supported | supported |
| Range-partitioned table | supported | supported | supported |
| Summary table | supported | supported | supported |
| Temporal table | supported | supported | supported |
| Typed table | not supported | not supported | supported |
| Untyped (regular) table | supported | supported | supported |
| Updatable view (except typed view) | supported | not supported | supported |
| Table type | Ingest | Load | Import |
|---|---|---|---|
| Numeric: SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, DECFLOAT | supported | supported | supported |
| Character: CHAR, VARCHAR, NCHAR, NVARCHAR, plus corresponding FOR BIT DATA types | supported | supported | supported |
| Graphic: GRAPHIC, VARGRAPHIC | supported | supported | supported |
| Long types: LONG VARCHAR, LONG VARGRAPHIC | supported | supported | supported |
| Date/time: DATE, TIME, TIMESTAMP, including TIMESTAMP(p) | supported | supported | supported |
| DB2SECURITYLABEL | supported | supported | supported |
| LOBs from files: BLOB, CLOB, DBCLOB, NCLOB | not supported | supported | supported |
| Inline LOBs | not supported | supported | supported |
| XML from files | not supported | supported | supported |
| Inline XML | not supported | supported | supported |
| Distinct type | supported (if based on a supported built-in data type) | supported | supported |
| Structured type | not supported | not supported | supported |
| Reference type | supported | supported | supported |
| Input type | Ingest Restartable? |
Load Restartable? |
Import Restartable? |
|---|---|---|---|
| Cursor | not supported n/a |
supported yes |
not supported n/a |
| Device | not supported n/a |
supported yes |
not supported n/a |
| File | supported yes |
supported yes |
supported yes |
| Pipe | supported yes |
supported yes |
not supported n/a |
| Table type | Ingest | Load | Import |
|---|---|---|---|
| ASC (including binary) | supported | supported | supported |
| DB2® z/OS® UNLOAD format | not supported | not supported | not supported |
| DEL | supported | supported | supported |
| IXF | not supported | supported | supported |