Looking for a "best practice" plan

About 50 (out of thousands) of our users can create queries (Query/400) to
generate outfiles for upload. Other processes (RPGLE or SQLRPGLE) often
generate export files to either libraries or ifs.
Currently no QQRYTIMLMT.
Last night a query/400 outfile reached 180 Gb before process halted
(overflowed an ASP).
We can set max storage by user, or a general max storage for all end users.
QQRYTIMLMT an option but wondering if the odd join in a Query/400 that
caused this issue would be able to estimate the time. OPS killed the job
after 2 hours.

So... QQRYTIMLMT could help in query and sql, but that does not fix the
RPGLE possibility.

A disk monitor is possible, or a job monitor (more complicated).
Am leaning towards the max storage by user.

Jim Franz

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].