ADSM-L

[ADSM-L] Correct equation for the sum of q occ

2013-07-21 02:13:01
Subject: [ADSM-L] Correct equation for the sum of q occ
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 21 Jul 2013 06:11:56 +0000
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

<Prev in Thread] Current Thread [Next in Thread>