With the CA Web Viewer ConfigTool, connection to the DB2 database fails. ERRORCODE=-4499

book

Article ID: 36984

calendar_today

Updated On:

Products

CA Output Management Document Viewer CA 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


Cause

 The fully qualified database server name and port was not entered

Environment

Release: CA Output Management-Web Viewer 12.1

Component: WBVLUW

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;


IBM Tech doc:

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