Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList