TSM DB QUERY: Tapes free after reclamation

[tivolimistery]

Hi all,

I would ask you if exists a way to know how many (or which) tapes become free after reclamation processes running in the last seven days.

Thanks in advance.
Best regards.
Mauro Tridici

 

[moon-buddy]

"q DRM" would give a list of tapes that are of state "Vaultretrieve".

If you do reclamation once a week, then jot down the totals of what "q DRM" gives you, and this is your total count!

 

[tivolimistery]

Hi Moon-buddy,

sorry but I don't understand
From TSM activity log I see that, in the last 24 hours, space reclamation deleted tape with label A00074L4 (for example) but when I execute "q drm begindate=09/30/2010" I don't find this tape in the list.
I need to know which tape became free after last space reclamation.

How can I do it?

Thank you again.

Mauro Tridici

 

[moon-buddy]

"q drm begindate=09/30/2010" I don't find this tape in the list.
I need to know which tape became free after last space reclamation.

If you had done a "move DRM wherestate=vaultretrieve tostate=onsiteretrieve", then you will not see any vaultretrieve tapes when you run "q drm".

Query the actlog then.