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 IC95688 Status: Geschlossen

DB2CLI VALIDATE -DSN <DSN> -CONNECT FAILES WITH SQL1032N ERROR

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
db2cli validate -dsn <dsn> -connent, fails with SQL1032N error. 
 
The problem only happens under these conditions: 
 
1. DSN is defined in db2dsdriver.cfg and parameter 
name=authentication is set. 
 
e.g. 
 
<dsn alias="HA" host="hostname" name="SAMPLE" port="12345"> 
<parameter name="Authentication" value="client" /> 
 
AND 
 
2. Same dbalias name as DSN name is catalog in database 
directory. 
 
e.g. 
 
db2 catalog tcpip node nodename remote hostname server 12345 
db2 catalog db sample as ha at node nodename authentication 
client 
 
Sample output: 
db2cli validate -dsn ha -connect 
 
  Connecting to: ha 
  [IBM][CLI Driver] SQL1032N  No start database manager command 
was issued.  SQLSTATE=57019 
 
  Connect Status: failure 
  End Connection Section 
 
---------------------------------------------------------------- 
----------- 
 
Error: The validation operation failed.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL DB2 CLI users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2_v97fp9 and later                              * 
****************************************************************
Local-Fix:
Remove this line in db2dsdriver.cfg: <parameter 
name="Authentication" value="client" />
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
fixed in db2_v97fp9 and later
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC95824 IC96358 IC96683 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.09.2013
18.12.2013
18.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList