TDM: Unable to connect to DB2 due to security mechanism error

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to connect to a DB2 database from the TDMGT Datamaker
We are getting the below error.
Can you please provide help?

Description:
*************
gives errors to connect to the connection profile used. Error:
*******
Failed to connect: TDMDatabaseException: getDBConnection: Unable to connect to database jdbcdb2://ddb2-gwy01.bmogr.net:3776/dbg4:securitymechanism=7,encryptionalgorithm=2;;;user=mbhat06: Failed to obtain JDBC Connection; nested exception is com.ibm.db2.jcc.am.SqlinvalidAuthorizationSpecException:[cc][t4][201][11237][4.24.92] Connection authorization failure occurred. Reason: Security mechanism not supported. Errorcode=4214, SQLSTATE=28000

Environment

TDM
datamaker
test data manager

Cause

Used incorrect Default Variable
Had the wrong default variable - corrected and was able to proceed

Resolution

Open GTDatamaker
Open the projects
Open the variables


Double click the highlighted link to open
Edit Project Level Variable.

 

Edit from CADS to CADS-Target

Additional Information