Joyce - Here are some thoughts on controlling database content.

   Richard Sims, BU

Database consumption factors            - All the administrative definitions are
                                          here; elminate what is no longer
                                          needed.
                                        - The Activity Log is contained in the
                                          database: control amount retained via
                                          'Set ACTlogretention N_Days'.
                                        - The database is at the mercy of client
                                          nodes or their filespaces being
                                          abandoned, and client file systems
                                          and disks being renamed such that
                                          obsolete filespaces consume space.
                                        - Volume history entries consume some
                                          space: eliminate what's obsolete via
                                          'DELete VOLHistory'.
                                        - More than anything, the number of
                                          files cataloged in the database
                                          consume the most space, and your
                                          Copy Group retention rules govern the
                                          amount kept.
                                        - Make sure that clients are not running
                                          Selective backups (i.e., full backups)
                                          routinely instead of Incremental
                                          backups, as that will rapidly inflate
                                          the database. Likewise, be very
                                          careful of coding MODE=ABSolute in
                                          your Copy Group definitions.
                                        - Talk to client administrators about
                                          excluding useless files from backup,
                                          like temp directories and web browser
                                          cache files.
                                        - Make sure that 'EXPIre Inventory' is
                                          being run regularly.
                                        - The size of the Aggregate in
                                          Small Files Aggregation is also a
                                          factor: the more small files in an
                                          aggregate, the lower the overhead in
                                          database cataloging.  See: Aggregate.