DB2 FOR LUW / DB2FORLUW / B10 - DB2

When running the INGEST command using DS Driver with the
database not cataloged in the database directory, the command
will succeed but will report messages SQL1057W or SQL1031N. When
using scripting of these command you are therefore unable to
determine if the command completed successfully or not.

For example:
[db2inst2@db2r105test ?]$ db2 "ingest from file employee.del
format delimited by ',' insert into testemp"

SQL1031N  The database directory cannot be found on the
indicated file system.
SQLSTATE=58031
SQL2979I  The ingest utility is starting at "16/06/2016
14:17:52.487089".
SQL2914I  The ingest utility has started the following ingest
job:
"DB21005:20160616.141752.487089:00003:00005".

Number of rows read         = 42
Number of rows inserted     = 42
Number of rows rejected     = 0

SQL2902I  The ingest utility completed at timestamp "16/06/2016
14:17:58.810684". Number of errors: "1". Number of warnings:
"0".

[db2inst2@db2r105test ?]$ echo $?
4

or:

[db2inst2@db2r105test ?]$ db2 "ingest from file employee.del
format delimited by ',' insert into testemp"
SQL1057W  The system database directory is empty.
SQLSTATE=01606
SQL2979I  The ingest utility is starting at "16/06/2016
14:20:31.889293".
SQL2914I  The ingest utility has started the following ingest
job:
"DB21005:20160616.142031.889293:00003:00005".

Number of rows read         = 42
Number of rows inserted     = 42
Number of rows rejected     = 0

SQL2902I  The ingest utility completed at timestamp "16/06/2016
14:20:32.563039". Number of errors: "0". Number of warnings:
"1".
[db2inst2@db2r105test ?]$ echo $?
2

****************************************************************
* USERS AFFECTED:                                              *
* All Db2 user                                                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1.2.2 or later.                            *
****************************************************************

Catalog the database

not known / see Local fix

forerunner  : IT16085 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.08.2017
10.10.2017
10.10.2017