IBM E16RMLL-I - Tivoli Storage Manager, Implementation Manual

Page: 297 / 828

Chapter 6. Data storage
267
Example 4
Example 6-45 shows the volumes where a node has data stored and the storage
pool that the volumes belong to.
Example 6-45 Querying volume usage by node
tsm: ATLANTIC>
select distinct node_name, \
cont>
volume_name from volumeusage where node_name='PARIS'
NODE_NAME VOLUME_NAME STGPOOL_NAME
------------------ ------------------ ------------------
PARIS /tsm/stg/dirm/0000001B.BFS DISKDIRS
PARIS /tsm/stg/dirm/0000002A.BFS DISKDIRS
PARIS 023AKK OFFDATA
PARIS 022AKK TAPEDATA
For more information about SQL commands, use the
help select
command.
6.6 Summary
You have now completed the storage pool section, in which we have covered
topics related to configuring storage devices such as drives and libraries,
managing tape volumes, and various related commands.
In the next chapter we focus on defining your policies (rules) for managing your
data that has been backed up to Tivoli Storage Manager.