The commands below indicate the syntax and examples. In the near future this site will include common errors and a user forum for Q&A. Also, there will be links that can be helpful alternatives to this site.
If you find any errors, misspellings, additional common commands, etc. please join our Tivoli Storage Manager (TSM) forums (www.tsmusergroup.com/forums) and let us know.
>select volume_name, state, voltype, stgpool_name from drmedia where state='VAULT' and date(upd_date)>(current_date -2 day)
note
If you run “q drmedia” on each of these tapes, they show up as “VAULT RETRIEVE”.
Here is what to do
Review “checkin.sh” script.
Then run
>move drm VOLUME_NUMBER tostate=onsiter
on each, then put them into library.
Next time Operations runs “checkin1.sh” script, they become scratch tapes.
To see the log for a certain node.
Server command:
> 'select domain_name, node_name, date(lastacc_time) as LASTACC_DATE, time(lastacc_time) as LASTACC_TIME from nodes where lastacc_time < timestamp(current date - 7 day,'00:00:00') order by lastacc_date, domain_name, node_name`
Damaged file on a tape
You need to run the 'Audit Volume' command with fix=yes parameter. This will delete the file that is damaged from the TSM database
>audit volume <volumeName> fix=yes
To restore files from damaged volume(tape) run restore volume or restore STGpool command.