When a monitored DB2 database is deleted, the agent fails to connect and runs out of memory.
The logs show the agent fails to connect to a DB2 instance and throws error "java.lang.OutOfMemoryError: Java heap space" and agent stops.
- Actions taken:
Original problem statement was that monitoring a database under heavy load resulted in an agent out of memory condition.
Error messages in the log indicated that the database was not available.
DB2 SQL Error: SQLCODE=-1031, SQLSTATE=58031
It turns out the database was deleted during the time of the outage thus the database not found messages, then the agent runs out of memory.