home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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