On Jun 12, 2008, at 3:23 AM, Abayomi Oni wrote:

...Given the output of the above query, how can I selectively
remove backup
data for a particular date range in a node for any storage pool?
Secondly, what will happen to the physical tape after such removal?

That's an awfully vague question, without details.

If you're the TSM server administrator, you should not be
contemplating the selective deletion of client-owned data: it should
be expiring naturally, according to the retention policies that were
decided when the data was entrusted to TSM.  Client data belongs to
clients, not the TSM administrator.

Procedures on the client side can result in the removal of TSM
storage pool data, such as in TDP data removal tasks (e.g., RMAN) or
the decision to remove some ordinary B/A stored data via 'dsmc
expire' and 'dsmc delete backup'; or, most severely, via 'dsmc delete
filespace'.  The respective manuals provide information on handling.

Emptied tapes are subject to re-use as described in the
Administration Guide manual, according to Reusedelay and whether they
were Scratch volumes or assigned to storage pools via DEFine Volume.

   Richard Sims