STORAGE POOL SIZE script

[markroe]

I have been gven the following script



select sum(PHYSICAL_MB) as "TotalMb",stgpool_name from occupancy group by STGPOOL_NAME



which produces the following output



TotalMb STGPOOL_NAME

--------------------------------- ------------------

40434.40 ARCHIVE_TAPEPOOL

1916532.71 DATABASE_ARCHIVE_TAPEPOOL

0.21 DATABASE_DISKPOOL

2789949.99 DATABASE_TAPEPOOL

83596.17 DATA_COLLOCATED_DISKPOOL

2062641.99 DATA_COLLOCATED_TAPEPOOL

2106713.72 DATA_TAPEPOOL

5676602.24 OFFSITE_TAPEPOOL



ANR1462I RUN: Command script STORAGEPOOLSIZE completed successfully.



Please could some one modify this script to add up the



DATA_TAPEPOOL , DATA_COLLOCATED_TAPEPOOL , DATABASE_TAPEPOOL , DATABASE_DISKPOOL and ARCHIVE_TAPEPOOL



and then subtract from the



OFFSITE_TAPEPOOL



thank you in advance



mark

 

[KB2277]

Mark,

I'm unaware of a way to have TSM add the "sum of sums", but you can do this from an external script, preferrably Unix based O/S.



I've ran into several situations where I'd like to have TSM sum what has been returned, but I don't believe it's capable. If somebody knows how to do that, I'd be interested as well.



Sorry.



-Ken

 

[crowntsm]

Can't get rounf the subtraction, but does this help?





set sqldisplaymode wide

set sqlmathmode round

select sum(physical_mb)as "TotalMb All Pools" from occupancy

select sum(physical_mb)as "TotalMb Not Offsite Pools" from occupancy where stgpool_name not like 'OFFSITE_TAPE%'

select sum(physical_mb)as "TotalMb Offsite Pools" from occupancy where stgpool_name like 'OFFSITE_TAPE%'





KevvyH

 

[markroe]

Yes that helps alot



best wishes