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
Issue:
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.
Environment:
Automation Engine version 12 and higher using an IBM DB2 database.
Resolution:
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: http://www-01.ibm.com/support/docview.wss?uid=swg21363866
  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=???