ERRORCODE=-4499, SQLSTATE=08004 Connection to the DB2 database fails Web Viewer 12.1
search cancel

ERRORCODE=-4499, SQLSTATE=08004 Connection to the DB2 database fails Web Viewer 12.1

book

Article ID: 36984

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

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

  • Output Management Web Viewer 12.1
  • IBM DB2

Cause

 The fully qualified database server name and port was not entered

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;

IBM Tech doc:

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