Re: R: query killing system

[rob@xxxxxxxxx]

We use the MAXSTG on the group profile that the user is a member of.  Now,
if this group happens to contain 90% of your users you are going to have
many jobs abending with messages.  However the recovery will be better than
if they fill the whole system. And we have a job that takes the output from
DSPUSRPRF... *OUTFILE and email's us the percentage used of everyone who
has a limited MAXSTG.  From there we take action.  Maybe it's planned
growth.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    Finucci Domenico
                    <Domenico.Finucci@Fid       To:     
"'midrange-l@midrange.com'" <midrange-l@midrange.com>
                    italia.it>                  cc:
                    Sent by:                    Fax to:
                    midrange-l-admin@midr       Subject:     R: query killing 
system
                    ange.com


                    03/22/2002 11:31 AM
                    Please respond to
                    midrange-l






You may also limit maximum resource usage for a group / specific user.
Give a look at MAXSTG parameter of WRKUSRPRF command.

Sincerely

Domenico Finucci
Fiditalia , Milano, 02- 4301-2494


-----Messaggio originale-----
Da: Smith, Mike [mailto:Mike_Smith@RGCResources.com]
Inviato: venerdì 22 marzo 2002 17.17
A: 'midrange-l@midrange.com'
Oggetto: 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.
_______________________________________________
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.