CA AWA, DB2, JCP/JWP do not start with error "Unable to get metadata for 'some table'"

Document ID : KB000117355
Last Modified Date : 11/10/2018
Show Technical Document Details
Using IBM DB2 as Automation Engine database, the JCP and JWP fail or will not even start with error:
20180921/123005.891 - 42               SQL Statement which caused this DB error:
20180921/123005.891 - 42               Unable to get metadata for 'AH'.
20180921/123006.001 - 43     U00003432 Termination of Server 'UC4#WP005' initiated.

It can affect any table, it must not always be the table AH as in the example above.
Automation Engine version 12 and higher using an IBM DB2 database.
There are two measures to overcome this issue:
  1. Use the most recent IBM DB2 JDBC driver for your database version. A list of JDBC driver versions can be found here:
  2. Check the ODBC connection string in the ucsrv.ini. The UID should be written in uppercase. E.g. SQLDRIVERCONNECT=ODBCVAR=NNJNIORD,DSN=UC4DB;UID=UC4UID;PWD=???