Re: size of objects in the backups table
This has been a frustration for us too. Somehow the client is able to get this information efficiently, so when I've needed it I've just piped "dsmc q b -su=yes ina" to some awk/perl to get the information I need. Obviously this is only good for ad-hoc queries, not for anything that's going to be done regularly. In an ideal world, "q occ" would display the active/inactive counts. On Tue, Feb 03, 2015 at 02:25:52PM +, Rhodes, Richard L. wrote: > 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!) -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
Re: size of objects in the backups table
I used to work with BACKUPS and CONTENTS a lot when auditing how well some DBAs were policing their own backups. I don't have those scripts any longer, but my recollection is that techniques I developed using those tables in TSM 5.5 were unusable on TSM 6.1 and early TSM 6.2 servers. They were usable again on TSM 6.3, and I thought they were usable again on later TSM 6.2 releases -- but I probably was using repeated small queries, not large joins. I'd think you'd already be seeing this improvement if you're on 6.2.5, but if not, it might be worth the effort to get to TSM 6.3. Nick On Tue, Feb 3, 2015 at 8:25 AM, Rhodes, Richard L. < rrho...@firstenergycorp.com> wrote: > 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. >
Re: 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. 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.
Re: size of objects in the backups table
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. 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. >
Re: size of objects in the backups table
Yes, and total size of these active items is about 10 GB. Regards, Tomasz Hubicki Original Message Subject: Re: [ADSM-L] size of objects in the backups table From: Jeanne Bruno To: ADSM-L@VM.MARIST.EDU Date: Tue Feb 03 2015 23:00:12 GMT+0100 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. 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.
Re: size of objects in the backups table
Yes, that worked great. An occupancy gives you the totals, and this gives just the active. Just for curiosity I created a sql cmd to join contents and backups for a single node with very little data. It never returned, as expected. Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Jeanne Bruno Sent: Tuesday, February 03, 2015 5:00 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: size of objects in the backups table 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. 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. > - 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.
Re: size of objects in the backups table
An alternative to the export node option (and works well if you want the active data sum for everything, is to set up an empty active data pool and do a preview of a stgpool copy. It'll be faster than multiple exports. Steven On 4 February 2015 at 12:08, Rhodes, Richard L. wrote: > Yes, that worked great. An occupancy gives you the totals, and this gives > just the active. > > Just for curiosity I created a sql cmd to join contents and backups for a > single node with very little data. It never returned, as expected. > > Rick > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Jeanne Bruno > Sent: Tuesday, February 03, 2015 5:00 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: size of objects in the backups table > > 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. > 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. > > > > > - > 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. >
