Raymond, there are different aspects to your question: 1. If your question is "where will the data go if my node were to back up/archive/space manage something" is almost impossible to answer with select statements. It depends on the design of your TSM environment - which management classes are available, which ones will be used by assigning them via include statements at the client, what option sets you have and what their include statement assignments are for these management classes.
2. If your question is "where MIGHT the data go if my node were to back up/archive/space manage something" then all you need to look at are the space management destinations, the backup copy group destinations, and the archive copy group destinations for the management classes in the policy domain in which the node resides. 3. If your question is "which storage pools contain data for my node", then the answer is produced by a q occupancy <nodename> command which tells you where data for the node in question is located. Joerg Pohlmann 604-535-0452