Hello Stephen,
A database PACK or RELOAD should be performed
with MULTI set to OFF, to prevent users from
altering the database during maintenance.
However if there are several tables where file
utilization can be improved greatly, in a
multi-user environment, you may PACK those specific tables individually.
PACK TABLE tblname
Packing a single table is supported when MULTI is
set ON, and is very beneficial with databases that are always is use.
Note that performing a PACK on the database in
multi-user mode will not decrease the database
size, and will add the newly PACKed table to the
existing database. The PACKed table, and indexes,
will then benefit from the improved performance.
To PACK/RELOAD a database with the intent of
reducing the database size, the maintenance must
be performed with MULTI set to OFF.
In addition, for backups in an environment with
constant database connections, use the SHARECPY
command to make a copy for files that are shared
on a network. Then, using that new copy, perform
an AUTOCHK to ensure the SHARECPY was successful,
and then perform the PACK/RELOAD.
Very Best R:egards,
Razzak
At 10:44 AM 1/14/2019, Stephen Markson wrote:
Hello,
I am looking for ideas on how to do database
maintenance, like PACK or RELOAD, while users are connected.
We are running with STATICDB ON. Currently,
we’re doing a RELOAD first thing in the morning,
before users are connected. This is working
well, but we’re looking for something better.
Any ideas would be greatly appreciated. Thanks and…
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
