Primary storage pool usage for specific node

Resolving The Problem

The Tivoli Storage Manager server keeps track of both Physical and Logical space in the occupancy table. The Physical space includes empty space within aggregates, from which files might have been deleted or expired. The Logical space is the space that is actually used to store files, excluding empty space within aggregates.

The following sample select queries show how to obtain more information about the usage of Tivoli Storage Manager server primary storage pool Logical space (logical_mb) for a specific node.

• Get the list of primary storage pool volumes that contain data for a specific node
  select distinct(a.stgpool_name) from volumeusage a,stgpools b where a.node_name='XXX' and a.stgpool_name=b.stgpool_name and b.pooltype<>'COPY'
• Get the total number of files and Logical MB of space in a primary storage pool for a specific node :
  select sum(a.num_files) as "Number of files", sum(a.logical_mb) as "Logical MB" from occupancy a, stgpools b where a.node_name='XXX' and a.stgpool_name=b.stgpool_name and b.pooltype<>'COPY'
  An alternative query :
  select sum(num_files) as "Number of files", sum(logical_mb) as "Logical MB" from occupancy where node_name='XXX' and stgpool_name not in (select stgpool_name from stgpools where pooltype='COPY')