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 IT22621 Status: Closed

SECURITY MECHANISM NOT SUPPORTED EXCEPTION WHEN AUTHENTICATION=CLIENT AND
PASSWORD AND USER ARE PROVIDED.

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
When there are following setting on the remote server:

Database manager authentication        (AUTHENTICATION) = CLIENT
Alternate authentication           (ALTERNATE_AUTH_ENC) =
NOT_SPECIFIED
Cataloging allowed without authority   (CATALOG_NOAUTH) = YES
Trust all clients                      (TRUST_ALLCLNTS) = YES
Trusted client authentication          (TRUST_CLNTAUTH) = SERVER
Bypass federated authentication            (FED_NOAUTH) = NO

in that case when the user and password is provided then
authentication should take place on the server side.
When no credentials are provided then client authentication
should take place.
However instead the following exceptions are raised:

com.ibm.db2.jcc.am.SqlWarning: Origination unknown:
[10228][11541][4.18.60] Security exceptions occurred while
loading driver. ERRORCODE=4223, SQLSTATE=null

and:

[jcc][t4][201][11237][4.18.60] Connection authorization failure
occurred.  Reason: Security mechanism not supported.
ERRORCODE=-4214, SQLSTATE=28000
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.1 FP2 or later                                 *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT19549 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.10.2017
13.10.2017
13.10.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)