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