select node_name,sum(logical_mb) as data_in_mb,sum(num_files) as num_of_files,STGPOOL_NAME from occupancy group by node_name,STGPOOL_NAME having min(num_files)>= 1 order by node_name ,data_in_mb desc
NODE_NAME DATA_IN_MB NUM_OF_FILES STGPOOL_NAME ------------------ --------------------------------- ------------ ------------------ APP_IS 34814.67 8993 STGP_TAPE APP_IS 12459.60 12 COPY_TAPE IS_FILES 25219.92 844800 STGP_TAPE IS_FILES 5662.39 463405 COPY_TAPE IS_ORACLE 1702834.08 359 STGP_TAPE IS_ORACLE 308673.71 64 COPY_TAPE IS_ORACLE 43461.53 11 STGP_DISK DBSRV_FILES 61844.78 68670 STGP_TAPE DBSRV_FILES 30791.72 16042 COPY_TAPE DBSRV_ORACLE 19047595.67 2692 STGP_TAPE DBSRV_ORACLE 5023396.91 680 COPY_TAPE TRY_DB_ORACLE 828832.24 593 STGP_TAPE TRY_DB_ORACLE 201337.40 144 COPY_TAPE TRY_DB_ORACLE 14116.84 12 STGP_DISK Given the output of the above query, how can I selectively remove backup data for a particular date range in a node for any storage pool? Secondly, what will happen to the physical tape after such removal?
