Thanks David - I ran the second command which provided me with a report. However the figures in that report match what I already receive from the query auditocc command. This makes me think that there is something wrong with the data that it is reporting on. There are two SQL database servers for which the reported data appears to be obviously wrong.
For one of them the reported primary storage pool data has increased over the past 4 weeks from 2.3Tb, to 4.5Tb, to 7.0Tb and now this week it is 9.1Tb. We have not increased the number of backups kept, and we have not added any new SQL databases. When I start the DP for SQL client and add up all the active and inactive databases which I can restore from, the total amount of data is 2.3Tb. On another SQL server, the reported primary storage pool data has increased over the past 4 weeks from 310Gb, to 610Gb, then 950Gb and now it is 1300Gb. When I start the DP for SQL client and add up all the active and inactive databases which I can restore from, the total amount of data is around 310Gb. It is as if each week the amount of primary storage pool data is being added to rather than replaced. However this is only happening for SQL database servers. For other non-database servers the amount of reported primary storage pool data has been stable. Where is this the information for this reported primary storage pool data kept? Is it on our TSMADMIN server somewhere? Thanks & Regards Paul -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: Thursday, 28 July 2016 10:57 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Paul, You are right. All of my data is in primary storage pools so I no longer worry about copy pools. Back when I had copy pools, my storage pool names would indicate whether it was primary or copy pool. Can you mask on pool name to distinguish between primary and copy pool? If so, select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by node_name where stgpool_name like '%NAME MASK%'c Alternatively, select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy where stgpool_name in (select stgpool_name from stgpools where POOLTYPE='PRIMARY' ) group by node_name David -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Wednesday, July 27, 2016 8:11 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Thanks. I ran this command and it ran successfully and provided me with a list of totals. However they are a lot higher than what is reported by my query auditocc command. Does it total just the primary storage or all storage pools? I am just interested in primary storage to keep track of storage used as we have the unified terabyte licensing for TSM. Thanks & Regards Paul -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: Wednesday, 27 July 2016 11:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Perhaps the following query would give you better data: select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by node_name -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Tuesday, July 26, 2016 9:35 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] query auditocc question To keep track of our primary storage usage, on a weekly basis I run the following command: query auditocc pooltype=primary For one of the nodes - an SQL server - it is reporting that the backup storage used is 7Tb. However knowing the size of the databases on that server and the number of copies of each backup we keep, I believe that to be incorrect. I started the DP for SQL client on that server, clicked on Restore Data, and then selected all backups (both active and inactive). I then added up the size of each backup (both active and inactive) and it added up to 2.2Tb. How could there be such a huge difference between each total? Thanks & Regards Paul Dudley IT Operations ANL Container Line pdud...@anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. https://urldefense.proofpoint.com/v2/url?u=http-3A__www.mailguard.com.au&d=AwIFAg&c=SgMrq23dbjbGX6e0ZsSHgEZX6A4IAf1SO3AJ2bNrHlk&r=dOGCMY197NTNH1k_wcsrWS3_fxedKW4rpKJ8cHCD2L8&m=cU1nSXe9zeJeTXfHCck544vQ4tE90eevPhlpXBxSpRM&s=GAitD2h-npPX-E1RY9gr082WxH3H0K633k3kCMja6lM&e= Click here to report this message as spam: https://urldefense.proofpoint.com/v2/url?u=https-3A__console.mailguard.com.au_ras_1OVoBqtOtJ_3vhxB9XK9tUP8GWQIH6joI_0.022&d=AwIFAg&c=SgMrq23dbjbGX6e0ZsSHgEZX6A4IAf1SO3AJ2bNrHlk&r=dOGCMY197NTNH1k_wcsrWS3_fxedKW4rpKJ8cHCD2L8&m=cU1nSXe9zeJeTXfHCck544vQ4tE90eevPhlpXBxSpRM&s=S_a4rP7L9CwRlVTgwQvwpZYsMSjKtQXVSKY59I4w4eQ&e= ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
