Page 1 of 1

Ending Long DB2 Queries in PHP

Posted: Fri Dec 22, 2017 5:24 pm
by jord1322
Hey,

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.

Re: Ending Long DB2 Queries in PHP

Posted: Thu Jan 11, 2018 4:24 pm
by alex4065
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.