Re: Mimix Promoter

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

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