Rebuild Indexes
Fairlight
fairlite at fairlite.com
Tue Jan 7 14:48:15 PST 2020
M5 - Index Maintenance Flags (dxmaint)
=======================================
All Indexes:
-E exit to user menu upon completion.
-H "heading" screen heading.
-M name uses the given qualifier.
-MD prompts user for a qualifier.
-MQ "msg" prompts user for qualifier using "msg".
-On indicates the output index name - "n" can
be any automatic or demand index.
-R rebuilds the index on the same key(s).
4.0 -RA rebuilds all automatic indexes in named file.
4.0 -RF n,l,o:n,l,o ...
rebuilds an index on a specified field,
length & sort order.
You'll need to write something to handle all files, if you want to do more
than one.
Realise that this should not be necessary, and if you're running into
the need regularly, you should really dive deeper as to the cause. This
is like reinstalling Windows from scratch every three months, whether
you need it or not.
m->
On Tue, Jan 07, 2020 at 02:31:24PM -0800, Ross Salas via Filepro-list thus spoke:
> Hi! What is an easy way to rebuild all indexes? (running this from a
> menu is okay for now)
>
> We are running filePro 5.8 on Linux (CentOS 6.10).
>
> Eventually, I would like to automate this process from the command line if
> possible.
>
> Thanks,
> Ross
>
> I found the following:
> http://mailman.celestial.com/pipermail/filepro-list/2016-January/032416.html
>
> echo "Started `date`" >/home/mjs/retime
> cd /u/appl/filepro
> for file in *
> do echo $file
> if [[ -d $file ]]; then
> echo "Starting Freechain:" $file `date` >>/home/mjs/retime
> /u/appl/fp/lib/freechain $file
> echo $file `date` >>/home/mjs/retime
> /u/appl/fp/dxmaint $file -ra -e
> fi
> done
> echo "Ended `date`" >>/home/mjs/retime
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200107/2c5e4462/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
--
Audio panton, cogito singularis.
More information about the Filepro-list
mailing list