Expired file on a TSM server..

[Hema]

Hi,

I'm in a restore issue and an urgent help is required..
Is there any way to find ,a particular file (which has been expired) from the actlog.If so,can you please give me the command to get the information.I feel that there will be someway to refine the tables in TSM and could get the expiration date & time for a particular file..Can anybody please help me..

Regards,
Hema

 

[BBB]

The information is available already in the backups table.

select * from backups where node_name='NODENAMEINALLCAPS' and filespace_name='/file/space/name' and hl_name='/sub/dir/' and ll_name='filename'

Note where the slashes go and its case sensitve.


Or go to the client and use the "q backup command". Read the help for further info.