The following query will produce a report of the space usage of all storage pool volumes, summarised by storage pool and status.
SELECT STGPOOL_NAME AS STGPOOL, COUNT(VOLUME_name) AS COUNT, STATUS, CAST(MEAN(EST_CAPACITY_MB/1024) AS DECIMAL(5,2)) AS GB_PER_VOL FROM VOLUMES GROUP BY STGPOOL_NAME,STATUS
But displays error in the "MEAN" on TSM Server 6.3 does not recognize, how to fix the above script?
Grateful for the attention,
Ramon
SELECT STGPOOL_NAME AS STGPOOL, COUNT(VOLUME_name) AS COUNT, STATUS, CAST(MEAN(EST_CAPACITY_MB/1024) AS DECIMAL(5,2)) AS GB_PER_VOL FROM VOLUMES GROUP BY STGPOOL_NAME,STATUS
But displays error in the "MEAN" on TSM Server 6.3 does not recognize, how to fix the above script?
Grateful for the attention,
Ramon