Re: TSM server on RedHat 7

2016-04-22 Thread Zoltan Forray
That is the old fashioned Redhat 6 way - not a proper .service file. Zoltan Forray TSM Software & Hardware Administrator VMware Administrator (in training) Xymon Administrator VCU Computer Center zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will

Re: TSM server on RedHat 7

2016-04-22 Thread David Ehresman
My server install bin directory has a dsmserv.rc script which it says to copy to the name of your instance owner in /etc/rc.d/init.d/ That's how I start my TSM instance on Linux. David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan Fo

TSM server on RedHat 7

2016-04-22 Thread Zoltan Forray
Does anyone have a systemd startup .service/process to autostart TSM on RedHat 7? All docs I see/find (yes I Googled and see stuff talking about the client but not the server) still talk about the old chkconfig way and using dsmserv.rc? -- *Zoltan Forray* TSM Software & Hardware Administrator Xym

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Schneider, Jim
You can also start the session with -virtualnodename. It works with dsmc or dsmj, and avoids the 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

Re: SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

2016-04-22 Thread Skylar Thompson
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, but not Windows). On Fri, Apr 22, 2016 at 02:20:38PM +, Schneider, Jim wrote: > Use a server you can access and

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
Use a server you can access and modify the nodename in the options file, assuming you know the password. Jim Schneider Essendant -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Friday, April 22, 2016 9:11 AM To: ADSM-L@VM.MARIS

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
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 client side, but don't have access to all of them. -Original Message- From: ADS

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.

Manual db2 online reorg for ver.6.3

2016-04-22 Thread Krzysztof Przygoda
Hi Just wondering if anyone tried with TSM ver 6.3 method described in document related to ver 7.1 http://www-01.ibm.com/support/docview.wss?uid=swg21683633 "*Online index reorganization* You can initiate online index reorganization by running a command with the following syntax: db2 reorg index