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.
Ending Long DB2 Queries in PHP
Ending Long DB2 Queries in PHP
Thanks,
Jordon Greene
PHP Full Stack Developer
SHOE SHOW, Inc.
Jordon Greene
PHP Full Stack Developer
SHOE SHOW, Inc.
Re: Ending Long DB2 Queries in PHP
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.