DB2 - Problembeschreibung
Problem IC96358 | Status: Geschlossen |
DB2CLI VALIDATE -DSN <DSN> -CONNECT FAILES WITH SQL1032N ERROR | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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 v10.5.3 and later * **************************************************************** | |
Local-Fix: | |
Remove this line in db2dsdriver.cfg: <parameter name="Authentication" value="client" /> | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Fixed in v10.5.3 and later | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.09.2013 09.09.2014 09.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |