Hi Pro's
Is it possible to calculate the occupancy from two stgpools in TSM and get the total amount? I Have two stgpools that I want to add and get a result?
SELECT stgpool_name,CAST(FLOAT(SUM(logical_mb))/1024/1024 AS DEC(8,2)) as TB FROM occupancy where stgpool_name='NDMPPOOL' GROUP BY stgpool_name
+
SELECT stgpool_name,CAST(FLOAT(SUM(logical_mb))/1024/1024 AS DEC(8,2)) as TB FROM occupancy where stgpool_name='FILERPOOL' GROUP BY stgpool_name
Regards,
/C
Is it possible to calculate the occupancy from two stgpools in TSM and get the total amount? I Have two stgpools that I want to add and get a result?
SELECT stgpool_name,CAST(FLOAT(SUM(logical_mb))/1024/1024 AS DEC(8,2)) as TB FROM occupancy where stgpool_name='NDMPPOOL' GROUP BY stgpool_name
+
SELECT stgpool_name,CAST(FLOAT(SUM(logical_mb))/1024/1024 AS DEC(8,2)) as TB FROM occupancy where stgpool_name='FILERPOOL' GROUP BY stgpool_name
Regards,
/C