Re: Query Question

[rob@xxxxxxxxx]

We have limited by group profile for just this reason.  Yes, it will still 
blow everyone out of accounting and payroll, but all of our manufacturing 
entities will continue to function.  And if they don't function, how do 
you make the payroll?  And it is a simple fix to temporarily fix the group 
profile until you resolve the problem.  And, a query which prints off any 
user profile that has a limit, and what percent of that limit they are at, 
is emailed to critical people on a weekly basis.  Thus if payroll grows 
during the year, we can adjust that maximum.  We try to keep it around 90% 
of that user profile (NOT TOTAL DISK).  Therefore we can blow the runaway 
query in a timely fashion.  The last person to do so was the payroll 
analyst, so don't give me that song and dance about keeping Query away 
from the users.

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




"Bruce Barrett" <bruce.barrett@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/14/2003 10:42 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Query Question


We had a query run by our QA department that caused our development
system to crash on Friday night.  The query created a file of over 100
million records and was 20% of the 1.3 terabyte of storage.
Is there a way to limit the size of a file a query can produce?  We do
not know at this time, if the query was run in batch or interactively.
We can not limit the size by profile, due to group profiles.
Any help is appreciated.



Bruce Barrett
PMI Mortgage Insurance Co.
3003 Oak Road
Walnut Creek, CA 94597
925-658-6152
Fax 925-658-6412
Cell 510-520-4263
bruce.barrett@xxxxxxxxxxxx

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.