Delete all file spaces from all nodes older than...

[darbronnoco]

I have a large number of file spaces that haven't expired over the years and I don't all the reclamation in the world will catch us up. Right now we have been generating lists of file spaces by node and semi bulk deleting any file space that should have been expired.

In this example all of our daily nodes are ServerName_D

So I would like to know if there is a way to select all filespaces from all nodes *_D and delete the file spaces older than XX/XX/XXXX

Any help is much appreciated. If there is anything I can clarify please let me know.

 

[darbronnoco]

Currently we are using and spitting it out to a csv and sorting by the date and inactive and deleting from there.


select * from backups where node_name='ServerName_D

 

[Trident]

Hi,

Try something like this:

select 'del filespace'||node_name||' '||filespace_id||' namet=fsid wait=yes' from filespaces where backup_start<'2015-01-01' > /tmp/delfilespace.mac

Modify and verify, verify, verfify

Then from tsm server: run /tmp/delfilespace.mac