IBM Support

IT06594: 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                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7, Fix pack 11                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7, Fix pack 11
    

Temporary fix

  • see Local Fix
    

Comments

APAR Information

  • APAR number

    IT06594

  • 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

    2015-01-19

  • Closed date

    2015-10-08

  • Last modified date

    2015-10-08

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT06594

Modified date: 08 October 2015