|
Problem IT15206
|
Status: Closed |
INGEST CRASH OR HANG WHEN USING A DATA FILE THAT CONTAINS PARTIAL ROW VALUE.
|
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
INGEST may crash or hang when using a data file that
contains a partial row.
For example, on row 5 of the INGEST data file, there is only
120 column but the table has 500 columns per row defined.
The columns not specified in the file are to be inserted as the
default value (since the DEFAULTIF=NULL was specified in the
INGEST command). This situation will trigger either a crash or
hang. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.1 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
Remove the offending rows or specify all the columns in the
datafile even if they are just delimiters. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.05.2016
12.05.2017
12.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
