[SCRIPTING]Move Data with variable

Arkeon

Newcomer
Joined
Sep 25, 2015
Messages
1
Reaction score
0
Points
0
Hi everybody,

Fairly new to TSM, i only started working on it for half a year or so and i gotta say that this forum helped me a lot already so first of all, cheers to you guys :)

Now for my issue. We recently figured that our VTLs were not used properly, some are used at less than 15% stucked in filling status and reclaim won't help much. So now we have a crapload of VTL with sometimes less than 1% used and we're almost out of empty one.

We already came out with a solution to clean a bit:

select volume_name,status,pct_utilized,pct_reclaim,location,access from volumes where devclass_Name like '%VTL%' AND status='FULL' and pct_utilized<30 order by pct_reclaim

Then we can do a move data for the VTL listed by the select.

I was wondering if i can use the result of the select as a variable for the move data? I search around for a while and tried some script but couldn't manage to do it.

Any ideas?
 
Back
Top