Use the DELETE FILESPACE command to delete an individual filespace. David Longo
>>> [EMAIL PROTECTED] 05/31/02 09:53AM >>> As filespaces come and go on a client, does anyone know of a solid way to clean them up ? ? ? Since directories are "backed up" even when they are "excluded" would the "Last Backup Start Date/Time:" reflect the last time the file system was mounted ? ? ? here is an example of why I would like to clean up things... We have an SAP disaster recovery box that has also been and will continue to be used for misc other things... So this has had QA TS BX PF etc... instances on it and filesystems have come and gone over the last year because they are generally of the form /oracle/XXX/sapdata# where XXX is some instance like PF1 and # is a sequence number Well, I did a select node_name,sum(capacity) as "filespace capacity MB",sum(capacity*pct_util/100) as "filespace occupied MB" from adsm.filespaces group by node_name and I really don't think this box has 17 exabytes of filespaces on it ;-) Filespace MB Occupied MB 17,592,369,800,454 17,592,367,574,528 memory refresh: terabyte is 1024 gigabytes petabyte is 1024 terabytes exabyte is 1024 petabytes zettabyte is 1024 exabytes yottabyte is 1024 zettabytes Dwight E. Cook Software Application Engineer III Science Applications International Corporation 509 S. Boston Ave. Suit 220 Tulsa, Oklahoma 74103-4606 Office (918) 732-7109 "MMS <health-first.org>" made the following annotations on 05/31/02 10:26:52 ------------------------------------------------------------------------------ This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==============================================================================