When using the CA Output Management Web Viewer ConfigTool, connection to the DB2 database fails. ERRORCODE=-4499

Document ID : KB000036984
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

The following error message was found when examining the configtool.log located in <installation_location>/util/logs/ 

Loaded: db2jcc.jar
com.ibm.db2.jcc.am.yn: [jcc][t4][2057][11264][3.57.82] The application server rejected establishment of the connection.
An attempt was made to access a database, <database name>, which was either not found or does not support transactions.
ERRORCODE=-4499, SQLSTATE=08004

Environment:  

IBM DB2

Resolution:

When the database connection fails, be sure to look for more error messages in the configtool.log.

After reviewing the error messages in the configtool.log and researching them on the internet, the resolution was found:

Enter the DB2 location name specifying the fully qualified database server name and port. (not the database name)

jdbc:db2://<servername>:5023/DB2C

Additional Information:

The location name on z/os DB2 can be found from running this sql:

SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1;

 

 

Additional Information:

IBM Tech doc:

ERRORCODE=-4499, The application server rejected establishment of the connection.