Identifying which volume a filespace is stored on

Question & Answer

Question

Is there a select command to identify the name of the volume storing a filespace?

Cause

VM backups are stored as filespaces on the Tivoli Storage Manager server, at times an administrator will need to know which volume(s) a specific VM or filespace is stored on.

Answer

To determine which volumes hold the data for the filespace, it is first necessary to find the correct filespace ID. This can be obtained from a QUERY FILESPACE command for the node:

QUERY FILESPACE <NODE_NAME>

Example:

Then using this information for the values highlighted in red, a select statement can be run with the desired node name and FSID (filespace ID) using the dsmadmc administrative commandline. For example:

SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='<NODE_NAME>' AND FILESPACE_ID=<NUMBER HERE NO QUOTES>

Example:

The example above shows the Filespace "VMFULL-Carlisle - Windows 2012" is stored across 9 volumes, the volume names are listed in the "VOLUME_NAME:" parameter

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM

Was this topic helpful?

Document Information

Modified date:
17 June 2018

UID

swg21961708

Tips