Hi Robert
You can try q auditocc <name> po=pri
On Sunday, 21 July 2013, Robert Ouzen wrote:
> Hi to all
>
> I want to figure the correct calculation of the amount of data for a node,
> when running the q occ command here the output
>
> tsm: ADSM2>q occ mnhl_cluster
>
> Node Name Type Filespace Name FSID Storage
> Pool Name Number of Files Physical Space Occupied (MB)
> Logical Space Occupied (MB)
>
> ---------- ---- ----------
> ---- ---------- -----------
> -----------
> -----------
> MNHL_CLUSTER Bkup /media/nss/APPS 8 DEDUPTSM_CC
> 2,379 -
> 4,154.58
> MNHL_CLUSTER Bkup /media/nss/DATA 1 DEDUPTSM_CC
> 177,982 -
> 228,977.50
> MNHL_CLUSTER Bkup /media/nss/DATA1 6 DEDUPTSM_CC
> 844,156 -
> 1,416,800.75
> MNHL_CLUSTER Bkup /media/nss/DATA2 3 DEDUPTSM_-
> 1,634,395 -
> 622,229.88
> MNHL_CLUSTER Bkup /media/nss/DATA3 5 DEDUPTSM_CC
> 490,867 -
> 438,843.50
> MNHL_CLUSTER Bkup /media/nss/DATA4 7 DEDUPTSM_CC
> 745,127 -
> 443,692.56
> MNHL_CLUSTER Bkup /media/nss/VOL2_I 4 DEDUPTSM_CC
> 19 -
> 2,754.32
>
> The amount is calculate as logical Space because tthis node is an TSM
> deduplicate Storage pool (server side)
>
> When I run a script to calculate the sum of this node as:
>
> tsm: ADSM2>select sum(logical_mb) / 1024 as "Total of Data GB" from
> occupancy where node_name=upper('MNHL_CLUSTER')
>
> Total of Data GB
> ----------------------------------
> 945.49
>
> What will be the correct equation to get the correct amount as the sum
> from the q occ ?
>
> Best Regards
>
> Robert
>
|