|
Problem IT16085
|
Status: Closed |
INGEST REPORTS SQL1057W OR SQL1031N WHEN USING DS DRIVER BUT DATABASE IS NOT CATALOGED IN THE DATABASE DIRECTORY |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 LUW INGEST users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW 10.5 Fix Pack 9 or later *
**************************************************************** |
| Local Fix: |
Catalog the database |
| Solution |
First fixed in DB2 LUW 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.07.2016
27.09.2017
27.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
