× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Well...

All I can say is that if you create a table with SQL, the default is
*NOMAX, REUSEDLT(*YES)

I'd consider REUSEDLT(*YES) to be a pest practice now-a-days.

Personally, we have MessengerPlus. It can be configured to monitor for
file full messages and automatically reply 'I' to increase the file size.
You can have it set to only do this X times, then it alerts you of the
issue.



Charles


On Thu, Jan 14, 2016 at 11:51 AM, Cyndi Bradberry <CyndiB@xxxxxxxx> wrote:

We are experiencing issues with files being created with either the
default of 10000 records or *NOMAX. I personally don't like either, (no
wars on this please).

What are best practices for file sizes ? How do you address the reuse
deleted records option ? How do you address file full ?

My thought is to build a file to contain the number of records and deleted
records for each file at end of month. That will, over time give me an idea
of how big things grow.

I also would like to program to check for files nearing their stated
capacity and bumping them by either a set amount or a percentage of active
records and reporting that to me for review.

While I love the idea of not re-inventing the wheel, we are not able to
purchase software for this at this time. This will all be do it myself.

Thanks,

Cyndi B.
Boise, ID


--
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/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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.