Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I resolve "query timeout error" due to complex database queries?

When creating database custom query metrics, if the queries are complex, they may return a timeout error message in the Database Agent logs. 

 

For example from DB2 database:

 

Caused by: com.ibm.db2.jcc.am.SqlTimeoutException: DB2 SQL Error: SQLCODE=-952, SQLSTATE=57014, SQLERRMC=null, DRIVER=4.16.53

 

As a solution, a user can increase the timeout parameter by adding the following property in the DB Agent startup file, or as a system argument if DB Agent is started through a command prompt or terminal. 

 

-Ddbagent.custommetric.query.timeout.seconds=<time_in_second>
 
 Example:
-Ddbagent.custommetric.query.timeout.seconds=120
 
 
Version history
Revision #:
9 of 9
Last update:
‎09-07-2018 03:18 PM
Updated by:
 
Labels (1)


Found this article helpful? Click the Thumbs Up button.
Have an additional comment? Post it below.


Found this article helpful? Click the Thumbs Up button.
Have an additional comment? Post it below.