Timeout / SQL

c149187 · #1 (**permalink**) 12-10-03, 08:36

Hi

Is there a possibility to set a timeout for queries, for example to specify that a query mustn't execute more than 30 seconds ?

UDB 8.1 / Unix

Marc

cgprakash · #2 (**permalink**) 12-10-03, 09:05

Hi

You can use DB2 Governor.

Regards
Prakash

nitingm · #3 (**permalink**) 12-10-03, 09:30

Hi Guess,

There is a CLI parameter that can also be set for the same.

Please refer to the link below..

http://www.db2.jp/db2manual/en_US/in...d/r0008809.htm

Hope that helps

Nitin.

c149187 · #4 (**permalink**) 12-11-03, 02:47

Thanks

I have also found in JDBC the following method:

---
int queryTimeout = 30;
statement.setQueryTimeout(queryTimeout);

Internet Services

Web Development

Digital Marketing

Consumer Tech