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.