The following SQL statement can show you when the TSM server got a newer copy 
of the file:

SELECT deactivate_date FROM backups
WHERE node_name='DEMON' AND filespace_name='/'
AND hl_name='/etc/' AND ll_name='hosts'
AND state='INACTIVE_VERSION

(all as one line, split up for ease of reading)

node_name is the name of the node in question, in CAPS.
filespace_name is the name you see in 'q filespace'
hl_name is the name of the directory the file lives in
ll_name is the name of the file itself


Unfortiunetly I do not know how to see when the file will be removed
from the database, only when the client detected newer/deleted copy.

Anyone have any ideas on how to see when the file will be deleted from
the database?

Hope this helps,

Thorhallur

On Thu, Sep 27, 2001 at 06:05:26PM +1000, mrkirra2001 wrote:
> How can I see when a file that has been backed and subsequently deleted (on
> the client) when it will be removed from the server?
>
> I know the RETONLY parameter says to keep it the number of days, so I can
> make a guess at when it was deleted and then add on the number of days in
> the RETONLY parameter, but this is a GUESS, especially for files that may
> have been deleted a number of weeks ago.
>
> So, is there a way to find out the EXACT date a file will be removed from
> the server once it has been deleted?
>
> Thanks for any help.
>
> /gjs