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 AT VM.MARIST DOT EDU] On Behalf Of
Paul_Dudley
Sent: Wednesday, July 27, 2016 8:11 PM
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of
David Ehresman
Sent: Wednesday, 27 July 2016 11:13 PM
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of
Paul_Dudley
Sent: Tuesday, July 26, 2016 9:35 PM
To: ADSM-L AT VM.MARIST DOT 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
pdudley AT anl.com DOT 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.
|