home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT06594 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 / 970 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fix pack 11                      * 
****************************************************************
Local Fix:
Use the "CATALOG DATABASE" and "CATALOG TCPIP NODE" commands to 
catalog the remote database at the CLP to allow client 
authentication.
Solution
First fixed in DB2 Version 9.7, Fix pack 11
Workaround
see Local Fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.01.2015
08.10.2015
08.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList