Linux utility using MSSQL throws U00029120...'libdb2.so.1"

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

When trying to run a utility (like client copy) from Linux or UNIX, connecting to MS SQL Server using MS ODBC on Linux, ucybdbcc connect to SQL Server on windows even though sqlcmd has no problems

The utility throws the error:

 U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).

Error in Log:

20210602/104806.351 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucucli.so' error 'libdb2.so.1: cannot open shared object file: No such file or directory'.
20210602/104806.351 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20210602/104806.351 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

The use of ODBC for MSSQL on Linux or UNIX is not supported.

Resolution

The unload binary in this case does not know how to process the NNNNNNRN and so it tries to find default libraries which are for db2 (due to alphabetical order).

Any utility that needs to connect to a MS SQL database should be run from a Windows Server.