Start a new topic

How to limit execution time, DB2?

Is it possible to set a command timeout in order to limit the risk of sending a "bad" query to the server? Ie have the query abort automatically if no response is received within a set number of seconds.


In this case specifically for a DB2 connection using the JDBC driver, databasetype DB2 LUW.



1 Comment

Hi Per,


There is no such setting, but you can set Max Rows which limits how much data is returned.


http://confluence.dbvis.com/display/UG100/Using+Max+Rows+and+Max+Chars+for+Queries


http://confluence.dbvis.com/display/UG100/Viewing+Table+Data#ViewingTableData-MaxRows/MaxChars


Best Regards

Hans

Login or Signup to post a comment