Hi Joni, As you could see, size is not shown is archive table. It would need to select from the content table too. The select required will need a join between archive and content and would be impossible to execute on a real life TSM server.
I think that you may find an answer with export node for datatype archive in preview mode using the todate option. -- Best regards / Cordialement / مع تحياتي Erwann SIMON -----Original Message----- From: "Moyer, Joni M" <[email protected]> Sender: "ADSM: Dist Stor Manager" <[email protected]> Date: Thu, 15 Mar 2012 19:01:42 To: <[email protected]> Reply-To: "ADSM: Dist Stor Manager" <[email protected]> Subject: [ADSM-L] Select statement to find data archived total 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.
