DB2 - Problem description
Problem IT06595 | Status: Closed |
CLP WILL FAIL WITH SQL30082N RC=17 WHEN USING DB2DSDRIVER.CFG AND CONNECTING TO SERVER WITH AUTHENTICATION=CLIENT SET | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem 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. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL DB2 Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v10.5.7 or later * **************************************************************** | |
Local Fix: | |
Use the "CATALOG DATABASE" and "CATALOG TCPIP NODE" commands to catalog the remote database at the CLP to allow client authentication. | |
Solution | |
Fixed in v10.5.7 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.01.2015 20.01.2016 20.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |