DB2-AWS DMS endpoint connection issue

It looks like you're dealing with an AWS Database Migration Service (DMS) endpoint issue connecting to a DB2 LUW server. Here’s a structured approach to resolving it: 

Endpoint identifier      : db2-test-crt1-fptest          

Replication instance     : test-int01-02-crt01

Status                   : failed

Message                  :                   

Test Endpoint failed: Application-Status: 1020912, Application-Message: Cannot connect to DB2 LUW Server. Check DB2 ODBC driver log for more information: /rdsdbdata/db2/sqllib_v{current version}/db2dump/db2diag.log ODBC warning., Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib '/opt/ibm/db2/V11.1/lib64/libdb2o.so' : file not foundx`

Raise an AWS Support Ticket (Recommended)

• Since the issue is likely related to AWS DMS and DB2 driver installation, an AWS internal team will need to check if:

  • The DB2 drivers were installed correctly during the replication instance upgrade.

  • The correct library path is configured.

Next Steps:

1. Raise an AWS support ticket and request them to verify the DB2 driver installation.

2. Monitor the AWS support response and apply the fix as advised.