Hello. I tested this and got the output: ANR0986I Process 206 for EXPORT NODE running in the BACKGROUND processed 37,158 items for a total of 10,206,832,635 bytes with a completion state of SUCCESS at 16:58:30.
So I have 37,158 active items for this particular node, correct? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of TH Sent: Tuesday, February 03, 2015 12:21 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] size of objects in the backups table Maybe a different way would be suitable for you - try to do EXPORT NODE xxx FILEDATA=BACKUPACTIVE PREVIEW=YES The end of process will give you a total size of active data for a node. Regards, Tomasz Hubicki ------ Wiadomość oryginalna ------ Temat: [ADSM-L] size of objects in the backups table Nadawca: Rhodes, Richard L. <rrho...@firstenergycorp.com> Adresat: ADSM-L@VM.MARIST.EDU Data: Tue Feb 03 2015 15:25:52 GMT+0100 > We are on TSM v6.2.5. > > We keep running into the normal question that seems to come up when we start > analyzing our backups. We can tell the number of active/inactive files from > the backups table, but not the size, which is in the contents table. Does > anyone have a way to get the active/inactive objects and their size without > killing your system with a massive SQL join? Maybe some kind of SQL join for > a specific node. > > I just can't believe TSM doesn't provide this info easily from the server! > (I suppose this belongs under the "Rant" thread!) > > > Rick > > > ----------------------------------------- > > The information contained in this message is intended only for the personal > and confidential use of the recipient(s) named above. If the reader of this > message is not the intended recipient or an agent responsible for delivering > it to the intended recipient, you are hereby notified that you have received > this document in error and that any review, dissemination, distribution, or > copying of this message is strictly prohibited. If you have received this > communication in error, please notify us immediately, and delete the original > message. >