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.