Backup Central

Hi All,

How do I generate a list of TDPO nodes and their space usage in TSM?

Thanks,

Craig

Craig Ballenger
System Administrator
Information Technology Services
Florida State University
cballenger < at > fsu.edu<mailto:cballenger < at > fsu.edu>
850-645-8001

ave nostra cecidit angelus

-----Craig Ballenger wrote: -----

How do I generate a list of TDPO nodes and their space usage in TSM?

select node_name,sum(logical_mb) from occupancy where
node_name in (select distinct node_name from filespaces
where filespace_type='API:ORACLE') group by node_name

If you have copy pools, this query will count both primary pool
space and copy pool space. You can avoid this by adding:

stgpool_name='<your pool name here>'

to the selection criteria for occupancy table records.

Thomas Denier=

Thanks Thomas!

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > vm.marist.edu] On Behalf Of Thomas Denier
Sent: Tuesday, November 29, 2011 2:36 PM
To: ADSM-L < at > vm.marist.edu
Subject: Re: [ADSM-L] List of Nodes and Space Requirements

-----Craig Ballenger wrote: -----

How do I generate a list of TDPO nodes and their space usage in TSM?

select node_name,sum(logical_mb) from occupancy where node_name in (select distinct node_name from filespaces where filespace_type='API:ORACLE') group by node_name

If you have copy pools, this query will count both primary pool space and copy pool space. You can avoid this by adding:

stgpool_name='<your pool name here>'

to the selection criteria for occupancy table records.

Thomas Denier