jdbc with data encrypt

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

Resolving The Problem

Use SSH connections instead of Data_encrypt

Related Information

JDBC with Data_encrypt

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"}}]

Tips