Re: [ADSM-L] List of Nodes and Space Requirements
2011-11-29 15:10:25
Thanks Thomas!
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT vm.marist DOT edu] On Behalf Of
Thomas Denier
Sent: Tuesday, November 29, 2011 2:36 PM
To: ADSM-L AT vm.marist DOT 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
|
|
|