IBM Support

IC68928: FED: DB2XML.SOAPHTTPV() FIALS IF IF KDB IS PASSWORD PROTECTED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Problem with DB2XML.SOAPHTTPV() (web services consumer
    functions) and
    SSL, running inside a SQL function.
    
    DB2XML.SOAPHTTPV() returns following if kdb is password
    protected
    
        [IBM][CLI Driver][DB2/NT] SQL0443N  Rutinen
    "DB2XML.SOAPHTTPV"
        (specifikt namn "SOAPHTTPCIVO") har returnerat ett
    SQLSTATE-fel med
        "SSL API error".  SQLSTATE=38328
    
    The trace and db2diag.log indicates, that db2 gets
    
    gsk_environment_init returns (408)
    GSK_ERR_BAD_KEYFILE_PASSWORD
    

Local fix

  • use certificate db without password protected
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users below db2level V9.7 Fixpak 3                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Problem with DB2XML.SOAPHTTPV() (web services consumer       *
    * functions) and                                               *
    * SSL, running inside a SQL function.                          *
    *                                                              *
    * DB2XML.SOAPHTTPV() returns following if kdb is password      *
    * protected                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7 Fixpak 3                                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in V9.7 Fixpak 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68928

  • 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

    2010-05-31

  • Closed date

    2010-12-02

  • Last modified date

    2010-12-02

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC68928

Modified date: 02 December 2010