|
Rick, 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! Bill -- 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 corrected.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.