IBM Support

JR33174: ERROR MESSAGE SHOULD BE CHANGED FOR DSDRIVER WHILE CONNECTING TO WINDOWS SERVER FOR AUTHENTICATION=CLIENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On connecting a windows server through odbc_cli_driver installed
    on linuxamd64 machine, Root Capability required error is thrown.
    Following are detailed steps:
    
    (regress7@regrlnxamd02)
    /home/regress7/db2_cli_odbc_driver/clidriver/bin
    $ db2level
    DB21085I  Instance "regress7" uses "64" bits and DB2 code
    release "SQL09054"
    with level identifier "06050107".
    Informational tokens are "DB2 v9.5.0.4", "s090304", "MI00256",
    and Fix Pack
    "4".
    Product is installed at "..".
    
    script to execute:
    opt callerror on
    sqlallocenv 1
    sqlallocconnect 1 1
    sqldriverconnect 1 0
    "PROTOCOL=TCPIP;HOSTNAME=vmregwin32h.torolab.ibm.com;DATABASE=cl
    idb;PORT=62000;UID=newton;PWD=Herew3g0" -3 200
    SQL_DRIVER_NOPROMPT
    
    SQLDriverConnect: rc = -1 (SQL_ERROR)
    SQLError: rc = 0 (SQL_SUCCESS)
    SQLError: SQLState : 08001
    fNativeError : -30082
    szErrorMsg : [IBM][CLI Driver] SQL30082N Security processing
    failed with reason "42" ("ROOT CAPABILITY REQUIRED").
    SQLSTATE=08001
    cbErrorMsg : 119
    
    Also with "AUTHENTICATION=SERVER", it throws:
    SQL30082N  Security processing failed with reason "17"
    ("UNSUPPORTED FUNCTION").  SQLSTATE=08001
    
    
    
    Same error message should be thrown for linux and windows client
    that "Client Authentication is not supported" for dsdriver.
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB21085I  Instance "regress7" uses "64" bits and DB2 code    *
    *                                                              *
    * release "SQL09054"                                           *
    *                                                              *
    * with level identifier "06050107".                            *
    *                                                              *
    * Informational tokens are "DB2 v9.5.0.4", "s090304",          *
    * "MI00256",                                                   *
    * and Fix Pack                                                 *
    *                                                              *
    * "4".                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Also with "AUTHENTICATION=SERVER", it throws:                *
    *                                                              *
    * SQL30082N  Security processing failed with reason "17"       *
    *                                                              *
    * ("UNSUPPORTED FUNCTION").  SQLSTATE=08001                    *
    *                                                              *
    *                                                              *
    *                                                              *
    * Same error message should be thrown for linux and windows    *
    * client                                                       *
    * that "Client Authentication is not supported" for dsdriver.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * db2_v95fp5                                                   *
    ****************************************************************
    

Problem conclusion

  • error message will be thrown for linux and windows client
    that "Client Authentication is not supported" for dsdriver.
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    JR33174

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-29

  • Closed date

    2010-02-24

  • Last modified date

    2010-02-24

  • 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 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 February 2010