Thursday, September 16, 2010

Occupancy Select Statement

We have a handful of "archive" tape pools on our instances.  I needed to know what servers had occupancy in these pools.  Here is the select statement I ran:

select node_name, stgpool_name from occupancy where stgpool_name like 'ARCHIVE%'

No comments:

Post a Comment