I'm trying to select tapes where has reclamation percentage and utilization percentage summ of less then 5. this is useful for reclamation as these tapes usless in library. My problem is my select return result after about 3-7minutes. Can anyone help to optimize this select or any tips how to better use inner select.
TSMserver version:5.1 Database size: 100GB hardware: RS/6000 H80 RAM:2GB SELECT="select volume_name,stgpool_name,pct_utilized,pct_utilized+pct_reclaim as summa from volumes where volume_name in (select volume_name from media where state like 'MOUNTABLEINLIB') and stgpool_name like 'BACK1_3590' and READ_ERRORS = 0 and WRITE_ERRORS = 0 and ERROR_STATE like 'No' and STATUS not like 'EMPTY' and ACCESS not like 'UNAVAILABLE' and pct_utilized+pct_reclaim < 5 order by pct_utilized"
