Dynamic SQL from Business Objects, Brio, etc...

Jessen Michael

Dynamic SQL from Business Objects, Brio, etc...
I'm curious what other companies have put in place to combat what I'll call
runaway queries from a client application.

Someone writes a query in Business Objects, Brio, etc., then decides it's
taking too long and cancels the application/query, leaving the thread active
in DB2 V5 (OS/390). We have a limit set on CPU seconds... but is there
anything else available that would cancel the thread before our site limits
are reached?

Thanks for your responses!

Mike Jessen
Database Administrator
John Deere Credit
phone: 515-267-3672
email: [login to unmask email]



Piontkowski Michael ML

Re: Dynamic SQL from Business Objects, Brio, etc...
(in response to Jessen Michael)
I've read that DB2 for OS/390 V5 or V6 or V7, can't remember,
has something called the Predictive Governor. It's supposed to
predict the resources required to execute a query. If any
thresholds that you set are exceeded, then the query is never
executed. I haven't used it.



Mike Piontkowski
TP&S Technical Maintenance
Voice: +1 302.886.4612
Fax: +1 302.886.4749


-----Original Message-----
From: Jessen Michael [mailto:[login to unmask email]
Sent: Thursday, December 21, 2000 10:15
To: [login to unmask email]
Subject: [DB2-L] Dynamic SQL from Business Objects, Brio, etc...


I'm curious what other companies have put in place to combat what I'll call
runaway queries from a client application.

Someone writes a query in Business Objects, Brio, etc., then decides it's
taking too long and cancels the application/query, leaving the thread active
in DB2 V5 (OS/390). We have a limit set on CPU seconds... but is there
anything else available that would cancel the thread before our site limits
are reached?

Thanks for your responses!

Mike Jessen
Database Administrator
John Deere Credit
phone: 515-267-3672
email: [login to unmask email]








xyz

Re: Dynamic SQL from Business Objects, Brio, etc...
(in response to Piontkowski Michael ML)
Sorry if this is a really old email,
If you use DB2 Connect with TCPIP and catalog the database with
,,,interrupt_enabled then the user can cancel the query and not leave the
thread active on DB2.
Regards
Danny
x
----- Original Message -----
From: "Jessen Michael" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Thursday, December 21, 2000 9:15 AM
Subject: Dynamic SQL from Business Objects, Brio, etc...


> I'm curious what other companies have put in place to combat what I'll
call
> runaway queries from a client application.
>
> Someone writes a query in Business Objects, Brio, etc., then decides it's
> taking too long and cancels the application/query, leaving the thread
active
> in DB2 V5 (OS/390). We have a limit set on CPU seconds... but is there
> anything else available that would cancel the thread before our site
limits
> are reached?
>
> Thanks for your responses!
>
> Mike Jessen
> Database Administrator
> John Deere Credit
> phone: 515-267-3672
> email: [login to unmask email]
>
>
>





Jeff Faughn

Re: Dynamic SQL from Business Objects, Brio, etc...
(in response to xyz)
The Reactive Governor (See page 703 of DB2 6.1 Admin Guide) is what you
can use.
We can not get the Predictive Governor to work for all applications.

P.S. The Reactive Governor is available in ver 5 also... : )




"Piontkowski, Michael L"
<[login to unmask email] To: [login to unmask email]
ENECA.COM> cc:
Sent by: DB2 Data Base Subject: Re: Dynamic SQL from Business
Discussion List Objects, Brio, etc...
<[login to unmask email]>


12/22/00 02:55 PM
Please respond to DB2 Data
Base Discussion List






I've read that DB2 for OS/390 V5 or V6 or V7, can't remember,
has something called the Predictive Governor. It's supposed to
predict the resources required to execute a query. If any
thresholds that you set are exceeded, then the query is never
executed. I haven't used it.



Mike Piontkowski
TP&S Technical Maintenance
Voice: +1 302.886.4612
Fax: +1 302.886.4749


-----Original Message-----
From: Jessen Michael [mailto:[login to unmask email]
Sent: Thursday, December 21, 2000 10:15
To: [login to unmask email]
Subject: [DB2-L] Dynamic SQL from Business Objects, Brio, etc...


I'm curious what other companies have put in place to combat what I'll call
runaway queries from a client application.

Someone writes a query in Business Objects, Brio, etc., then decides it's
taking too long and cancels the application/query, leaving the thread
active
in DB2 V5 (OS/390). We have a limit set on CPU seconds... but is there
anything else available that would cancel the thread before our site limits
are reached?

Thanks for your responses!

Mike Jessen
Database Administrator
John Deere Credit
phone: 515-267-3672
email: [login to unmask email]



the