Re: Limiting (but not stopping) interactive query by user

[oliver.wenzel@xxxxxxxxxxxxxxxxxxxxxxx]

Hi,


>I might be clutching at straws here, but we have a customer that's
>requested us to limit interactive query by user; ie, they don't want to
>stop anyone from using interactive query, just limit their impact on the
>system based on CPU utilisation. We don't really want to use QQRYTIMLMT
>because we don't want to limit batch run queries at all.

I have a text that describes how only specific users are allowed to use 
interactive query.
If you want it, just yell. I guess you could also limit to only a few 
interactive query users
at the same time (with some programming).

Also, as high query cpu usage often goes with high temp storage (index 
builds), you could limit
temp storage for the interactive subsystem (in the class description, I 
believe).

Regards,

Oliver