Ending Long DB2 Queries in PHP

General discussion on PHP
Post Reply
Posts: 36
Joined: Mon Nov 03, 2014 3:49 pm
Location: Concord, North Carolina

Ending Long DB2 Queries in PHP

Post by jord1322 » Fri Dec 22, 2017 5:24 pm


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.
Jordon Greene
PHP Full Stack Developer

Posts: 8
Joined: Thu Jan 11, 2018 4:22 pm

Re: Ending Long DB2 Queries in PHP

Post by alex4065 » Thu Jan 11, 2018 4:24 pm

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.

Post Reply