Re: query killing system

["Al Barsa/Barsa Consulting" <barsa@xxxxxxxxxxxxxxxxxxx>]

CHGQRYA only limits CPU time, not disk space.  IBM would be happy to sell
you more disk.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com






                    "Smith, Mike"
                    <Mike_Smith@RGCReso       To:     
"'midrange-l@midrange.com'" <midrange-l@midrange.com>
                    urces.com>                cc:
                    Sent by:                  Subject:     query killing system
                    midrange-l-admin@mi
                    drange.com


                    03/22/02 11:16 AM
                    Please respond to
                    midrange-l






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.