Troubleshooting
Problem
JDBC application may receive the following error: "Connection authorization failure occurred. Reason: Security mechanism not supported."
Cause
When the database manager config parameter AUTHENTICATION is set as follows
Database manager authentication (AUTHENTICATION) = DATA_ENCRYPT
JDBC applications to connect are required to have the following property set:
securityMechanism = ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY (13)
Otherwise the above "Connection authorization failure occurred. Reason: Security mechanism not supported." error is returned to the Java application:
Resolving The Problem
Set the following property :
securityMechanism = ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY (13)
Alternatively you can set property retryWithAlternativeSecurityMechanism to YES(1).
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - JCC - Type 4","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21903009