Ending Long DB2 Queries in PHP

General discussion on PHP

Ending Long DB2 Queries in PHP

Postby jord1322 on Fri Dec 22, 2017 5:24 pm

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.
Thanks,
Jordon Greene
PHP Full Stack Developer
SHOE SHOW, Inc.
jord1322
 
Posts: 36
Joined: Mon Nov 03, 2014 3:49 pm
Location: Concord, North Carolina

Re: Ending Long DB2 Queries in PHP

Postby alex4065 on Thu Jan 11, 2018 4:24 pm

hey there, look through these articles at https://www.ibm,com/developerworks/data ... index.html and https://www.ibm,com/support/knowledgece ... eters.html -- you will definately find some answers there.
alex4065
 
Posts: 9
Joined: Thu Jan 11, 2018 4:22 pm


Return to PHP

Who is online

Users browsing this forum: No registered users and 3 guests

cron