search cancel

Getting error ‘Security mechanism not supported’

book

Article ID: 188443

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to connect DB2 database(mainframe) using JDBC connection(for GTSUBSET) and getting error ‘Security mechanism not supported’  we have placed db2jcc jar file under GTDatamaker/lib folder and still facing same issue. Can you check with any expert if they can suggest anything on this.

Error Detail:

[jcc][1071][10615][4.19.26] Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager.  See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null

Cause

According to the IBM documentation, you need to configure the JVM, JCC driver, and DB2 encryption. See the below article.

"How to configure Oracle JVM, JCC driver, and DB2 encryption?"
https://www.ibm.com/support/pages/how-configure-oracle-jvm-jcc-driver-and-db2-encryption

Environment

Release : 4.5

Component : CA Test Data Manager

Resolution

The Answer provided by IBM:

"To use AES, install the "Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy" files from Oracle.

For SERVER_ENCRYPT authentication, configure both DB2 and the JCC driver for AES encryption instead of the default DES.

Set the ALTERNATE_AUTH_ENC database manager configuration parameter to a value of AES_CMP or AES_ONLY
Set thee JCC datasource properties securityMechanism and encryptiongAlgortihm.

securityMechanism=9
encryptionAlgorithm=2"

Additional Information

For DATA_ENCRYPT authentication refer to the following technote.

Using authentication type DATA_ENCRYPT with ORACLE Java

http://www-01.ibm.com/support/docview.wss?uid=swg21665861