Re: [ADSM-L] Orphaned filespaces
2007-04-03 00:13:43
For reference, here's some SQL:
select node_name, filespace_name
from filespaces f
where not exists
(select distinct node_name, filespace_name
from occupancy o
where f.node_name = o.node_name and f.filespace_name = o.filespace_name)
or, without using subqueries (but won't work with TSM):
select f.node_name, f.filespace_name
from filespaces f left join occupancy o using (node_name, filespace_name)
where o.node_name is null
The first takes a while to run on a TSM server. I export selected
tables out of TSM daily and import into MySQL... here, they run
sub-second. Ideal for reporting purposes, I highly recommend it!
--
Paul Ripke
Unix/OpenVMS/TSM/DBA
I love deadlines. I like the whooshing sound they make as they fly by.
-- Douglas Adams
|
|
|