IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 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.
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL DB2 CLI users                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to db2_v97fp9 and later                              *
    ****************************************************************
    

Problem conclusion

  • fixed in db2_v97fp9 and later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95688

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-03

  • Closed date

    2013-12-18

  • Last modified date

    2013-12-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95824 IC96358 IC96683

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC95688

Modified date: 18 December 2013