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/i...@ibmus Internet e-mail: stor...@us.ibm.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@vm.marist.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@vm.marist.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 > > > >
