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
Cause
Data_encrypt is not supported db2 v11 onwards
there is no plan to support DATA_ENCRYPT with openJDK 11. The recommendations is to use SSL.
Environment
db2 v11 with AIX and Linux.
Diagnosing The Problem
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
Resolving The Problem
Use SSH connections instead of Data_encrypt
Related Information
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"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2019
UID
ibm10887977