How to resolve "query timeout error" due to complex database queries

Not a customer? Start a free trial

Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.

Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community

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

Cisco AppDynamics Community

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