Re: Mimix Promoter -- MIDRANGE-L

Works great! Less filling!! (:

We use it monthly to reorganize some of our reluctant files. We kick off a process that reorganizes a bunch of files at once, and let it churn all day Saturday. The only 'problem' we have is that you can't reorganize more than 1 physical under a join logical at once. This is a 'feature,' not a 'bug.' (:

Also, you can't reorganize a file that reuses deleted records (although why would you need to?).

The process makes a copy of the file without the deleted records, and, once the copy is finished, it maintains both files. AFAIK, it uses journalling to capture transactions from the original and apply them to the copy (much like their product which synchronizes files between 2 systems). Then you find a 'quiet time' and tell the application to swap the clean file for the dirty one. Getting the quiet time is sometimes the hardest part of the process!

It does require that you have enough free space to clone the file(s) being reorganized, so if you're running close to the edge, you have to be careful.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx

Does anyone have any experience with Mimix Promoter from Lakeview Tech ?
It is a product that reorganizes production files without having to have
a lock on the file. You  just need the lock to replace the production
file with the reorganized file.

Thanks,

Ron Sposito
Slomin's Inc

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.