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 |
|