We'll presume there's a commit at the end of the query.
Filename: catch10
{Catches a query running longer than 600secs. - db name is: dbname - db2gov
wakes up every 60 secs.}
interval 60;
dbname;
set uowtime 600 action CHOICE;
{End of file}

Them {} are for comments.
Uowtime is the time used by the transaction
CHOICE is either priority or force. Priority allows you to reduce the
priority level by on one more (value dependant on OS), force means what it
says. It will roll back the query and force the connection off.

Hope this helps, Pierre.






-----Message d'origine-----
De : RLam [mailto:db2udbdba-ezmlmshield-x98599847.[Email address protected]
Envoyé : 23 février, 2007 13:48
À : LazyDBA Discussion
Objet : db2gov config file

Does anyone have a sample file to force / capture long running queries say
exceeding 10 minutes?

TGIF :)

Thanks
Ray


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page