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?