Troubleshooting
Problem
JDBC applications to connect using DATA_ENCRYPT in supported in db2 v10.5
However same thing not supported db2 v11 onwards.
Symptom
While trying to connect -will get below error
com.ibm.db2.jcc.am.SqlException: [jcc][1071][10615][4.25.13] Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null
Accordingly db2 jdbc with data_encrypt is supported as below way
https://www-01.ibm.com/support/docview.wss?uid=swg21903009
But in db2 v11 it fails even with below setting
jdbc://db2://ipaddress:port/dbname:securitymechanism = 13
Document Location
Worldwide
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"db2 v11","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
db2 v11
Operating system(s):
AIX, Linux
Document number:
887977
Modified date:
01 May 2025
UID
ibm10887977
Manage My Notification Subscriptions