Tapes not changing into Vaultretreive

[paulinechaines]

A report runs daily listing tapes in vaultretrieve state so that the operator can run a script to change status and check in the returned tapes. Not as many tapes as we think are returning. Should we be running tape reclamation processes on the off site tapes? Sorry if this sounds thick!

 

[heada]

Yes, you need to reclaim all tape pools to keep the utilization on the tapes high.



You can see how many tapes you would get back from the vault by using this query:



select volume_name, pct_reclaim, stgpool_name from volumes where pct_reclaim >= {your reclaim level} order by 3,2 asc



This will give a list of tapes, ordered first by storage pool and second by reclaim value. You can set the reclaim threshold for the pool to start reclamation on that pool.



-Aaron

 

[ranjancom2000]

For me also same lot of tape remain on offsite which his not comming to vaultretrieve state.



I have tested the command which has give by use,For me it is giving me a error



tsm: SEU*****>select volume_name, pct_reclaim, stgpool_name from volu

ere pct_reclaim >= {your reclaim level} order by 3,2 asc

Session established with server SEUK4ALPBAK01: Windows

Server Version 5, Release 3, Level 1.4

Server date/time: 10/04/2006 10:32:26 Last access: 10/04/2006 10:14:53



ANR2905E Unexpected SQL identifier token - 'RECLAIM'.



|

...............................V...............................

umes where pct_reclaim >= {your reclaim level} order by 3,2 asc

 

[ranjancom2000]

Sorry now it working.I have changed the your reclaim level to 80