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, dedup 
savings GB , dedup savings %, compression savings GB, compression savings %, 
total data reduction GB, total data reduction %

Basically, a "q stg f=d" is able to report such information (with the exception 
of space that would be used without dedup & compression), as following example 
shows :

                     Storage Pool Name: DIR_DB2
                     Storage Pool Type: Primary
                     Device Class Name:
                          Storage Type: DIRECTORY
                            Cloud Type:
                             Cloud URL:
                        Cloud Identity:
                        Cloud Location:
                    Estimated Capacity: 3,222,437 G
                    Space Trigger Util:
                              Pct Util: 0.2
(skipped data)
                Deduplication Savings: 7,095 G (31.34%)
                   Compression Savings: 9,548 G (61.42%)
                     Total Space Saved: 16,644 G (73.51%)

However, the "stgpools" table is only providing following related fields : 
TOTAL_SPACE_MB (which is always empty),SPACE_SAVED_MB, 
COMP_SPACE_SAVED_MB,DEDUP_SPACE_SAVED_MB.

What magic does IBM use to be able to display percentages for compression and 
dedup  in "q stg f=d" output ? So far I could not found it ...


Thanks in advance for any hint !

Cheers.

Arnaud


******************************************************************************************************************************
Backup and Recovery Systems Administrator
Panalpina Management Ltd., Basle, Switzerland,
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com<mailto:arnaud.brion AT panalpina DOT 
com>
This electronic message transmission contains information from Panalpina and is 
confidential or privileged. This information is intended only for the person 
(s) named above. If you are not the intended recipient, any disclosure, 
copying, distribution or use or any other action based on the contents of this 
information is strictly prohibited.

If you receive this electronic transmission in error, please notify the sender 
by e-mail, telephone or fax at the numbers listed above. Thank you.
******************************************************************************************************************************