markroe
ADSM.ORG Member
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
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