I'm probably opening myself up to a bunch of flames, but setting files to
*NOMAX is a pet peeve of mine.  This has always been my opinion on whether
to use *NOMAX or not:

In my experience, Database files generally fall into one of two distinct
categories: those files that grow at 10% or less per year (these tend to be
master files, parameter/setup files, etc.) and those files into which
records are constantly being entered, deleted, updated in a relatively
short time frame (these tend to be transaction files, such as Order Entry
files, etc.).

In either case, it is not a particularly difficult task for an Analyst to
figure out what the appropriate SIZE values should be when
creating/maintaining a database file.  The important thing is to consider
the current requirements, reasonable growth expectations, data entry plans,
and purge criteria.

When I've seen files fill up and begin to halt, it generally shows that
insufficient (or non-existent) analysis was done or the purge criteria was
never identified for historical files.  In my opinion, setting files to
*NOMAX should not be a substitute for proper Data Analysis.  Obviously if
you are in a high growth  industry, your master files may grow at a higher
rate, say 30% per year or more.  But when these file full halts occur it is
a sign that something wasn't done or your business is changing - a fact
that probably has you working on changing your applications anyway.

My flame retardant suit is now on - fire away!



NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.