DB Load fails using IBM DB2.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The DB Load fails using IBM DB2 as database.

20200930/000147.852 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20200930/000147.857 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20200930/000147.857 - U00038091 Change application directory to '../db/'.
20200930/000147.857 - U00033121 Error while checking data source (e.g. code conversion or driver problem, see log file). If you are using ORACLE, please check your NLS_LANG parameter settings.

Environment

Version: 12.n

Component: AUTOMATION ENGINE

Cause

Configuration.

Resolution

The DB2 database was set up as:

db2 create db uc4 automatic storage yes using codeset ISO-8859-15 territory US

The ucybdbld.ini has the following connect sring:

sqlDriverConnect=ODBCVAR=NNJNIORD,DSN=UC4;UID=uc4;PWD=???

The db2codepage parameter needs to be added to the connect string:

sqlDriverConnect=ODBCVAR=NNJNIORD,DSN=UC4;UID=uc4;PWD=???;db2codepage=923