IBM Support

IT06595: CLP WILL FAIL WITH SQL30082N RC=17 WHEN USING DB2DSDRIVER.CFG AND CONNECTING TO SERVER WITH AUTHENTICATION=CLIENT SET

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A CLP (Command Line Processor) connection will fail with an
    SQL30082N rc=17 (Unsupported Function) when using the
    db2dsdriver.cfg instead of the database directory to connect to
    a server that has AUTHENTICATION=CLIENT set in the database
    manager configuration (dbm cfg) file.
    
    A CLI or .NET connection will work with this configuration, and
    we would like the CLP to be consistent with these two
    interfaces.
    
    Note:   DB2 does not support the "CLIENT" value for the
    "AUTHENTICATION" keyword in the db2dsdriver.cfg or the
    db2cli.ini file.  When using AUTHENTICATION=CLIENT on the
    server, it would be recommended to catalog the database using
    the "db2 catalog database" command and to specify
    "AUTHENTICATION CLIENT" on the "CATALOG DATABASE" command.
    This will ensure that there is less over head on the connection
    request.
    
    AUTHENTICATION=CLIENT is considered unsecure in a DB2
    environment, so use with caution and only in an environment that
    has tight network security.
    

Local fix

  • Use the "CATALOG DATABASE" and "CATALOG TCPIP NODE" commands to
    catalog the remote database at the CLP to allow client
    authentication.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL DB2 Users                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to v10.5.7 or later                                  *
    ****************************************************************
    

Problem conclusion

  • Fixed in v10.5.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT06595

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-01-19

  • Closed date

    2016-01-20

  • Last modified date

    2016-01-20

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

    IT06493

  • 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

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.5

Reference #: IT06595

Modified date: 20 January 2016