Is there anyway to programmatically detect when a DB2 query is taking over x number of seconds and end it? This would be within a web page using PHP that kicks off the DB2 query. We're running into queries that are taking too long and causing timeouts. So we'd like to be able to stop the query to prevent locking up the site and be able to show a message stating what happened.
Thanks ahead of time.
General discussion on PHP
2 posts • Page 1 of 1
hey there, look through these articles at https://www.ibm,com/developerworks/data/library/techarticle/dm-1104db2statementconcentratorreoptimization/index.html and https://www.ibm,com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.websphere.nd.doc/ae/rprf_db2parameters.html -- you will definately find some answers there.