Per this document, IBM's suggestion/recommendation is to perform EXPORT NODE <node_name or *> FILED=BACKUPActive PREVIEW=YES
http://www-01.ibm.com/support/docview.wss?uid=swg21267260 On Fri, Apr 22, 2016 at 10:00 AM, Skylar Thompson <skyl...@u.washington.edu> wrote: > If you have access to the clients, you can use QUERY BACKUP and parse the > A/I column. > > Honestly, though, when we've gotten this query, I've managed to push this > back on the customers; it's not TSM's problem what's active or inactive, > it's the customers' applications that are actually responsible for it. > Obviously you need a pretty good relationship with your customers to make > that case, but in the end it's caused our customers to think more carefully > about workflow in general. > > On Fri, Apr 22, 2016 at 01:51:20PM +0000, Lee, Gary wrote: > > Just got a request for the amount of active versus inactive data on our > tsm servers. > > > > Is there a better way than traversing the backups table and summing? > > That would be a mighty long query. > > > > We have three servers, and approximately 300 clients about 200 tB total > data. > > > > Thanks for any suggestions. > > -- > -- Skylar Thompson (skyl...@u.washington.edu) > -- Genome Sciences Department, System Administrator > -- Foege Building S046, (206)-685-7354 > -- University of Washington School of Medicine > -- *Zoltan Forray* TSM Software & Hardware Administrator Xymon Monitor Administrator VMware Administrator (in training) Virginia Commonwealth University UCC/Office of Technology Services www.ucc.vcu.edu zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html
