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 AT VM.MARIST DOT EDU] On Behalf Of
David Ehresman
Sent: Thursday, 28 July 2016 10:57 PM
To: ADSM-L AT VM.MARIST DOT 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 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.
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.
|