Determining the volume that contains a client node's data.

Answer

The QUERY NODEDATA command will list the volumes for a specific node.

It is also possible to obtain this information form a select statement. The use of Select statements can be very handy to obtain different types of data from the Tivoli Storage Manager server.

The Tivoli Storage Manager Server select statements are performed from a Tivoli Storage Manager Administrative client session (dsmadmc).

A Select statement against the Volume Usage table will provide the necessary information. The Volumeusage table contains the following fields:

• To select all fields

Select * from volumeusage
• To select specific fields

Select Node_name, Stgpool_name, Volume_name from volumeusage
• To limit the select to not list the volume twice if a node has more than one filespace on a volume

Select distinct node_name, Stgpool_name, Volume_name from volumeusage
• To order the select (this will use sort space in the Tivoli Storage Manager server database)

Select distinct node_name, Stgpool_name, Volume_name from volumeusage order by node_name