|
Problem IT08717
|
Status: Closed |
INGEST FAILS WITH SQL1013N WHEN DB2DSDRIVER.CFG BUT NOT CATALOG IN THE DATABASE DIRECTORY |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
ingest command fails when connection is configured using
db2dsdriver.cfg
The error is:
SQL1013N The database alias name or database name "TM" could
not be found.
Database name : SAMPLE
connection from a client instance, configuration using only the
db2dsdriver.cfg, with these entries:
<<
<configuration>
<dsncollection>
<dsn alias="SAMPLE" name="SAMPLE" host="localhost"
port="53000">
</dsn>
</dsncollection>
<databases>
<database name="SAMPLE" host="localhost" port="53000">
</database>
</databases>
</configuration>
>>
No db2cli.ini, database SAMPLE uncataloged from the db
directory.
C:\DB2V105\BIN>db2 connect to SAMPLE user db2inst1
Enter current password for db2inst1:
Database Connection Information
Database server = DB2/NT64 10.5.5
SQL authorization ID = db2inst1
Local database alias = SAMPLE
C:\DB2V105\BIN>db2 ingest from file test.del format delimited by
',' insert into test
SQL1013N The database alias name or database name "TM" could
not be found.
SQLSTATE=42705
SQL2977I Because of the previous error, the ingest utility will
exit.
SQL2902I The ingest utility completed at timestamp "04/22/2015
19:09:25.904132". Number of errors: "1". Number of warnings:
"0". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later. *
**************************************************************** |
| Local Fix: |
db2 -v catalog tcpip node loopback remote localhost server 53000
db2 -v catalog db SAMPLE as SAMPLE at node loopback |
| Solution |
First Fixed in DB2 LUW v10.5 Fixpack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.05.2015
20.01.2016
20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
