DB2 - Problembeschreibung
Problem IT08717 | Status: Geschlossen |
INGEST FAILS WITH SQL1013N WHEN DB2DSDRIVER.CFG BUT NOT CATALOG IN THE DATABASE DIRECTORY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
Lösung | |
First Fixed in DB2 LUW v10.5 Fixpack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.05.2015 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |