The TSM server calculates storage where 1 KB = 1024 bytes, 1 MB = 1024 KB,
etc. So it would be more consistent to use physical_mb/1024/1024 (or
physical_mb / 1048576).

If you want to normalize the calculation to the same style that disk
manufacturers use so that 1 KB = 1000 bytes, 1 MB = 1000 KB, etc., then you
can use physical_mb * 0.000001048576. The conversion is 1 MB = 1048576
bytes, so you have:

   physical_mb * (1,048,576 bytes) / (1,000,000,000,000 bytes per TB)

Best regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager


The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 2010-02-18
04:32:15:

> [image removed]
>
> Correct equation
>
> Robert Ouzen Ouzen
>
> to:
>
> ADSM-L
>
> 2010-02-18 04:33
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Hi to all
>
>
>
> I try to figure what will be the correct syntax to get the correct
> amount of data store in TSm server in Terabytes
>
>
>
> select cast(sum(physical_mb/1000/1000) as decimal(6,2)) as "Total TB
> Adsm" from occupancy
>
>
>
> Did this correct ???? or another division
>
>
>
> T.I.A Regards
>
>
>
> Robert
>
>
>
>