TSM SQL Scripts for Reclamation

TSM SQL Scripts for Reclamation

Commands I use everyday for running the TSM reclamation process. We have a 3583 tape library with only 60 slots and 3 drives with a tapepool size of 110 volumes. This size difference in tape volumes and slots makes for a manual intensive process for running reclamation.

Empty Slots in Library

run emptyslots

or using sql…

select (60-count(volume_name)) as "Number of empty slots in library" from libvolumes

Tapepool volumes to reclaim with variable for pct_utilized

run poolrec $1

or using sql…

SELECT volume_name TAPEPOOL,pct_utilized from volumes where PCT_UTILIZED <$1 and stgpool_name='tapepool' and volume.status='full'

Tapecopy volumes to reclaim with variable for pct_utilized

run copyrec $1

or using sql…

SELECT volume_name TAPEPOOL,pct_utilized from volumes where PCT_UTILIZED <$1 and stgpool_name='tapecopy'

Dont need to check for volume status = to full for tapecopy because the location of item is offsite and cannot be used until reclaimed. Tapepool volumes are onsite and will still be used until they reach full status.

About

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Next
« Prev Post
Previous
Next Post »