Hi Everyone,
I was asked to find how much space would be saved if there were no data
retentions for archived data for more than 3 years. I currently have archive
management classes that go as high as 14 years. Is there a way to figure out
how much space is utilized per client that has data archived either per
management class or by file? When I did a select * from archives where
node_name='TEST' it shows me all of the files and the management class name,
but it doesn't show me the file size which is also what I'd need.
NODE_NAME: TEST
FILESPACE_NAME: /export/home
FILESPACE_ID: 22
TYPE: FILE
HL_NAME: /qips/dat/
LL_NAME: qsesc20041.dsc
OBJECT_ID: 149888292
ARCHIVE_DATE: 2006-02-02 09:35:08.000000
OWNER: lidqips
DESCRIPTION: archive.sh 0202060935
CLASS_NAME: ARC2655
Any thoughts? Thanks!
Joni
________________________________
This e-mail and any attachments to it are confidential and are intended solely
for use of the individual or entity to whom they are addressed. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use,
disclose, copy or distribute this e-mail without the author's prior permission.
The views expressed in this e-mail message do not necessarily represent the
views of Highmark Inc., its subsidiaries, or affiliates.
|