TSM Locating volume names for both primary and copy file objects

Problem(Abstract)

Explains how to find out which volumes in both primary and copy storage pools contain a specific file object

Resolving the problem

To find out which volumes in primary and copy storage pools hold a specific file object, perform the following:

1) Run a select statement to view a particular file and get the Object_ID. Example:
select * from backups
select * from archives

2) Run the following command:
show bfo 0 OBJECT_ID