DB2 FOR LUW / DB2FORLUW / A50 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 CLI users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to  v10.5.3 and later                                * 
****************************************************************

Remove this line in db2dsdriver.cfg: <parameter 
name="Authentication" value="client" />

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Fixed in v10.5.3 and later

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.09.2013
09.09.2014
09.09.2014