Re: query killing system

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

You can limit the amount of disk they can use in their user profile.

At 11:16 AM 3/22/02 -0500, you wrote:
>I was informed today that we had a user that created and ran  a
>query(query400) that creates a database file.  Obviously there was a flaw in
>their query and as a result disk usage shot up to over %90.
>
>I 'm trying to figure out we can prevent this from happing in the future.
>We do try to impower the users to create queries as we are a small shop, but
>we can't have them bringing the sytem to its knees either.
>
>I know i could change CHGQRYA on the time limit but not sure if that is the
>best route.
>
>Any ideas.
>
>Thanks
>
>Mike
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.