Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

What is the db2 connection refused to db2 errorcode?


Asked by Tripp Dorsey on Dec 02, 2021 FAQ



ERRORCODE=-4499, SQLSTATE=08001 A possible cause for this problem is that TCP/IP is not properly enabled on your DB2 database server. If the above command does not resolve the connection problem, contact IBM support.
Furthermore,
DB2 agent fails to start with a connection error from the FglAM to the monitored host Exception java.net.ConnectException: Error opening socket to server host/10.1.1.1 on port 60,030 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001
Thereof, The cause of this error is using a DCS DB alias or a local alias name of the database in the connection string will attempting the connection. If the connection is to a Db2® server, the <database name> should be the target database name in the database server, it should not be the local alias name cataloged in the client.
Accordingly,
The Masking Engine logs is the first place to start but for database errors, the DB2 Database logs are the place to look. The first level of the error message is detailed in the logs. For additional information please set the diagnostics on DB2 and check db2diag.log.
Keeping this in consideration,
If the connection is to a Db2 for z/OS® server, <database name> is the Db2 location name that is defined during installation. All characters in the Db2 location name must be upper-case characters.