RE: query killing system

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
 Consider setting up a users group and meet on a regular basis, say monthly.
The focus of the group would be user training and other issues that concern
the users. By making them a part of the process you will foster good will
and with any luck prevent those kinds of problems.



     Howard Weatherly
       Systems Advisor
Computer Task Group, Inc.

hweatherly@dlis.dla.mil
howard_weatherly@ameritch.net
Howard.Weatherly@ctg.com


"luck favors those who prepare"


-----Original Message-----
From: Smith, Mike [mailto:Mike_Smith@RGCResources.com]
Sent: Friday, March 22, 2002 11:17 AM
To: 'midrange-l@midrange.com'
Subject: query killing system


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.