Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-29 Thread Roger Deschner
Y,f.PCT_UTIL >order by 1 > >Regards, >Maurice van 't Loo > >http://mvantloo.nl/maupack.php >Personal pack of selects (in scripts) > > >2016-04-22 16:35 GMT+02:00 Schneider, Jim : > >> You can also start the session with -virtualnodename. It works with dsmc >

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-28 Thread Maurice van 't Loo
need for the proxy setting. > > Jim Schneider > Essendant > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Skylar Thompson > Sent: Friday, April 22, 2016 9:30 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Schneider, Jim
9:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA You can also GRANT PROXY and then use -ASNODE from one of your own nodes, using your node's password. I think the general node type has to match (i.e. any UNIX can proxy to any UNIX, bu

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Skylar Thompson
9:11 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA > > Wish I could do that. This comes from three levels above me in management. > Trying to buy more storage to sell to departments. > Don't ask me, I have no clue what they

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Skylar Thompson
Thanks for reminding me about this, I had completely forgotten. At the time, the customers wanted per-directory stats so it wasn't an option for us. On Fri, Apr 22, 2016 at 10:11:27AM -0400, Zoltan Forray wrote: > Per this document, IBM's suggestion/recommendation is to perform EXPORT > NODE FILE

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Schneider, Jim
@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA Wish I could do that. This comes from three levels above me in management. Trying to buy more storage to sell to departments. Don't ask me, I have no clue what they are doing. I'll look into the q backup on c

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Zoltan Forray
Per this document, IBM's suggestion/recommendation is to perform EXPORT NODE 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 wrote: > If you have access to the clients, you can use QUERY BACKUP and parse

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Lee, Gary
ssage- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar Thompson Sent: Friday, April 22, 2016 10:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA If you have access to the clients, you can use QUERY BACKUP and parse

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Skylar Thompson
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 fo

SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Lee, Gary
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.