ted above. Thank you.
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Anders
Räntilä
Sent: Monday, December 11, 2017 10:30 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement for deduplication & compre
Hi
This is simple math
select
stgpool_name,DEDUP_SPACE_SAVED_MB/(DEDUP_SPACE_SAVED_MB+COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
as "Dedup savings" from stgpools
select
Hi All,
Simple question : did any of you succeeded in building a query that would
provide accurate statistics on deduplication and compression factors for the
new TSM directory-based pools ?
I would simply get following :
Stgpool name, space that would be used without dedup & compression,
