This request is a statistical nightmare - don't promise results to be identical to what you come up with...
You're missing single quotes around 'INACTIVE_VERSION', so the statement looks like: select * from backups where node_name='TSMHOST6' and filespace_name='/export/home' and state='INACTIVE_VERSION' (Not sure why you were using "like" references instead of "=") But the number of objects won't help you for how many tapes you'll save - you need the average size of an object, too. I can think of two ways to guesstimate that value: 1. For the average size of an object on a tape: select avg(filesize) from contents where volume_name='XXXXXXX' And do a random selection of volumes. 2. Average size of an object for a particular node: select sum(physical_mb)/sum(num_files) from occupancy where node_name='NODENAME' and type='Bkup' That, times the number of objects you think you can get rid of, is the approximate amount of data space you'll get back. And some more things to think about: Not all objects will have the same number of inactive versions - some will have 0, some will have your retain_extra +1 (depending on if expiration has run or not). TDP nodes won't be effected - the application on the client controls the versions, not TSM. Do you have archives? They don't play by versions, either. Have fun - I tend to cringe when I get projects like this one. Nick Cassimatis [EMAIL PROTECTED] Think twice, type once.
