Knowledge Base

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: 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. 


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.