Re: How to track transaction stats for TSMVE backups?
We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.fr wrote: See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20Virtual%20Environments Prather, Wanda wanda.prat...@icfi.com a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
Trickery could be to place the page file on P: and exclude P: Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim Sent: Friday, September 27, 2013 5:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.fr wrote: See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20Vi rtual%20Environments Prather, Wanda wanda.prat...@icfi.com a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
In my case it appears to be DB related, lots of small (over 100) SQL DB's. With the combination of the DB's, plus the DBA's (reasonably) creating maintenance plans which write flat-file backups of the DB's onto the same VM's, with the VM's coming from wholesale P-to-V conversions. Think the solution is moving the SQL DB's onto a couple of big dedicated SQL servers, but that's mostly for future implementations; gotta just live with the history we've inherited for now. ... And I just stumbled onto an Oracle DB I didn't know was out there sigh. W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Hans Christian Riksheim Sent: Friday, September 27, 2013 6:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.fr wrote: See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20Vi rtual%20Environments Prather, Wanda wanda.prat...@icfi.com a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
Remember that the 6.4 TDP for SQL Server is VE aware, or so I've read. Just a thought, Nick On Friday, September 27, 2013, Prather, Wanda wrote: In my case it appears to be DB related, lots of small (over 100) SQL DB's. With the combination of the DB's, plus the DBA's (reasonably) creating maintenance plans which write flat-file backups of the DB's onto the same VM's, with the VM's coming from wholesale P-to-V conversions. Think the solution is moving the SQL DB's onto a couple of big dedicated SQL servers, but that's mostly for future implementations; gotta just live with the history we've inherited for now. ... And I just stumbled onto an Oracle DB I didn't know was out there sigh. W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU javascript:;] On Behalf Of Hans Christian Riksheim Sent: Friday, September 27, 2013 6:53 AM To: ADSM-L@VM.MARIST.EDU javascript:; Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.frjavascript:; wrote: See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20Vi rtual%20Environments Prather, Wanda wanda.prat...@icfi.com javascript:; a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr javascript:;] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com javascript:; a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com javascript:; | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
AFAIK, all that does is let the VE backup VSS snap also truncate the logs. But won't help with the change rate. Thanks! W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Laflamme Sent: Friday, September 27, 2013 11:50 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Remember that the 6.4 TDP for SQL Server is VE aware, or so I've read. Just a thought, Nick On Friday, September 27, 2013, Prather, Wanda wrote: In my case it appears to be DB related, lots of small (over 100) SQL DB's. With the combination of the DB's, plus the DBA's (reasonably) creating maintenance plans which write flat-file backups of the DB's onto the same VM's, with the VM's coming from wholesale P-to-V conversions. Think the solution is moving the SQL DB's onto a couple of big dedicated SQL servers, but that's mostly for future implementations; gotta just live with the history we've inherited for now. ... And I just stumbled onto an Oracle DB I didn't know was out there sigh. W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU javascript:;] On Behalf Of Hans Christian Riksheim Sent: Friday, September 27, 2013 6:53 AM To: ADSM-L@VM.MARIST.EDU javascript:; Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.frjavascript:; wrote: See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wi ki /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20 Vi rtual%20Environments Prather, Wanda wanda.prat...@icfi.com javascript:; a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr javascript:;] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com javascript:; a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com javascript:; | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
At the risk of being excessively optimistic, it might. If they're taking flat-file backups, would that stop if they have faith in the TDP backing up their data for them, regardless of how it happens? If they stop taking the flat file backups, that should reduce the churn rate some. It wouldn't be a huge reduction in the churn rate, but it might be worth experimenting with. Admittedly, some DBAs will always trust what they can see, files in their file system, more than some amorphous backup system, but in some shops, it might work. Nick On Sep 27, 2013, at 10:53 AM, Prather, Wanda wanda.prat...@icfi.com wrote: AFAIK, all that does is let the VE backup VSS snap also truncate the logs. But won't help with the change rate. Thanks! W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Laflamme Sent: Friday, September 27, 2013 11:50 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Remember that the 6.4 TDP for SQL Server is VE aware, or so I've read. Just a thought, Nick On Friday, September 27, 2013, Prather, Wanda wrote: In my case it appears to be DB related, lots of small (over 100) SQL DB's. With the combination of the DB's, plus the DBA's (reasonably) creating maintenance plans which write flat-file backups of the DB's onto the same VM's, with the VM's coming from wholesale P-to-V conversions. Think the solution is moving the SQL DB's onto a couple of big dedicated SQL servers, but that's mostly for future implementations; gotta just live with the history we've inherited for now. ... And I just stumbled onto an Oracle DB I didn't know was out there sigh. W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU javascript:;] On Behalf Of Hans Christian Riksheim Sent: Friday, September 27, 2013 6:53 AM To: ADSM-L@VM.MARIST.EDU javascript:; Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? We also see a high change rate and we think the reason for that is the Windows pagefile. Some trickery to exclude that would be welcome but since this is block based I guess it is not possible. Hans Chr. On Thu, Sep 26, 2013 at 10:11 PM, Erwann Simon erwann.si...@free.frjavascript:; wrote: See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wi ki /Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20 Vi rtual%20Environments Prather, Wanda wanda.prat...@icfi.com javascript:; a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr javascript:;] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com javascript:; a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com javascript:; | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
How to track transaction stats for TSMVE backups?
I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o)
Re: How to track transaction stats for TSMVE backups?
Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: How to track transaction stats for TSMVE backups?
See that page and search for reporting enhancement : https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Storage%20Manager/page/Tivoli%20Storage%20Manager%20for%20Virtual%20Environments Prather, Wanda wanda.prat...@icfi.com a écrit : DID NOT KNOW THAT! Thanks MUCH!!! Should take care of it. -Original Message- From: Erwann Simon [mailto:erwann.si...@free.fr] Sent: Thursday, September 26, 2013 2:00 PM To: ADSM: Dist Stor Manager; Prather, Wanda Subject: Re: [ADSM-L] How to track transaction stats for TSMVE backups? Hi Wanda, If your server is at 6.3.3 or higher, there's a new summary_extended table you can select against. See sub_entity column that reports the vmname, so you can distinguish by VM. Erwann Prather, Wanda wanda.prat...@icfi.com a écrit : I'm getting about 3 TB per day of VE backups. Something isn't right, it's a much higher change rate than I expected. So I want to know how much each VM is sending every night, figure out who the offenders are. I can get the occupancy from the filespace, but I'm interested in transmission stats, not total storage. With 200 VM's, digging it out of the dsmsched.log is non-trivial, same for activity log. Summary table has info for the data mover node only, doesn't show the VM name. Before I reinvent the wheel by writing a log parser, has anybody found a better way? Anybody submitted an RFE for this already? Thanks Wanda Prather | Senior Technical Specialist | wanda.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.
Re: SnapMirrorToTape stats?
Peter, SM2T is strictly used as a volume-level fallback for DR or onsite, no TOC since we don't want to use it to recover individual files. Our first line of defense is snapshots, then SnapDiff. -steve -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dolinski, Peter S Sent: Monday, December 17, 2012 6:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SnapMirrorToTape stats? Steve, What is your setup of SM2T? Do you use it only for a DR solution or also a backup solution to have data on tape? What is your recovery method? Regards, Peter (206) 616-0787 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Monday, December 17, 2012 2:28 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SnapMirrorToTape stats? Dunno about SnapMirrortoTape, but NDMP stuff is recorded in the SUMMARY table. Did you look there? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Schaub, Steve Sent: Monday, December 17, 2012 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SnapMirrorToTape stats? Maybe I'm missing something obvious, but I don't see in the client or server logs any kind of stats for our SnapMirrorToTape backups of our NetApp filer. Do I really have to script something that scrapes the logs and calculates throughput? This seems like a pretty basic piece of information not to include. Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: SnapMirrorToTape stats?
Took me awhile to find how it was recorded in the summary, but that is what I needed. Thanks, Wanda! -steve -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Monday, December 17, 2012 5:28 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SnapMirrorToTape stats? Dunno about SnapMirrortoTape, but NDMP stuff is recorded in the SUMMARY table. Did you look there? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Schaub, Steve Sent: Monday, December 17, 2012 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SnapMirrorToTape stats? Maybe I'm missing something obvious, but I don't see in the client or server logs any kind of stats for our SnapMirrorToTape backups of our NetApp filer. Do I really have to script something that scrapes the logs and calculates throughput? This seems like a pretty basic piece of information not to include. Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
SnapMirrorToTape stats?
Maybe I'm missing something obvious, but I don't see in the client or server logs any kind of stats for our SnapMirrorToTape backups of our NetApp filer. Do I really have to script something that scrapes the logs and calculates throughput? This seems like a pretty basic piece of information not to include. Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: SnapMirrorToTape stats?
Dunno about SnapMirrortoTape, but NDMP stuff is recorded in the SUMMARY table. Did you look there? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Schaub, Steve Sent: Monday, December 17, 2012 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SnapMirrorToTape stats? Maybe I'm missing something obvious, but I don't see in the client or server logs any kind of stats for our SnapMirrorToTape backups of our NetApp filer. Do I really have to script something that scrapes the logs and calculates throughput? This seems like a pretty basic piece of information not to include. Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: SnapMirrorToTape stats?
Steve, What is your setup of SM2T? Do you use it only for a DR solution or also a backup solution to have data on tape? What is your recovery method? Regards, Peter (206) 616-0787 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Monday, December 17, 2012 2:28 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SnapMirrorToTape stats? Dunno about SnapMirrortoTape, but NDMP stuff is recorded in the SUMMARY table. Did you look there? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Schaub, Steve Sent: Monday, December 17, 2012 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SnapMirrorToTape stats? Maybe I'm missing something obvious, but I don't see in the client or server logs any kind of stats for our SnapMirrorToTape backups of our NetApp filer. Do I really have to script something that scrapes the logs and calculates throughput? This seems like a pretty basic piece of information not to include. Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
DB stats look Off
Ladies and Gents, evidently I'm not getting something about these stats. Database Name: TSMDB1 Total Size of File System (MB): 161,792 Space Used by Database(MB): 100,032 Free Space Available (MB): 61,221 Total Pages: 5,866,500 Usable Pages: 5,866,364 Used Pages: 5,745,180 Free Pages: 121,152 Buffer Pool Hit Ratio: 98.5 Total Buffer Requests: 1,112,407 Sort Overflows: 0 Package Cache Hit Ratio: 99.7 Last Database Reorganization: Full Device Class Name: LTO4-ENC Incrementals Since Last Full: 0 Last Complete Backup Date/Time: 06/29/2011 11:30:20 It looks like I have 60 GB free, and I'm doing pretty well. However, it was showing 20 GB free this morning, and at about noon it died saying it was out of space. So, I'm wondering if the DB will actually use the full size of the file system, or do I need to run a command that will tell it how big the file space is? My understanding is that when the Free pages get low, TSM / DB2 will automatically grow the db until the filespace fills up. However, I had 20+ GB Free in the file system earlier today. See Ya' Howard Coles Jr. John 3:16!
Export process showing funny stats
This process has been going on for several days, currently 24M files and 5.3TB of data exported. However only 74,000 files and 27GB have been imported on the new server. Anyone know why these numbers are so far apart? Importing server IBM p570 LPAR AIX O/S 5300-03 Storage Management Server for AIX-RS/6000 - Version 5, Release 3, Level 3.3 Exporting server SUN E4800 Storage Management Server for Solaris 8/9 - Version 5, Release 2, Level 7.3 q pro on importing server Process Process Description Status Number - 690 IMPORT (from Server ANR0648I Have copied the following: 1 Filespaces 75472 Backup Files 27346163 Kilobytes (0 errors have been detected). q pro on exporting server Process Process Description Status Number - 36 EXPORT NODE ANR0648I Have copied the following: 1 Nodes 1 Filespaces 24236918 Backup Files 5320531 Megabytes (0 errors have been detected). Appreciate any insight, Thank you, Bill Evans
Re: Export process showing funny stats
Clarifying some information on request from one of our list members. Export command run on old server: EXPORT NODE wilma fsid=16 filed=all toserver=newserver merge=yes In comparing Query OCCupancy for the node on the old server and the new server, I found that the export is mostly complete, and the file counts and sizes are much closer. So it seems that the interim 'query process' information is just not getting updated properly on the importing node. Thanks for the insight! Bill Subject: Export process showing funny stats This process has been going on for several days, currently 24M files and 5.3TB of data exported. However only 74,000 files and 27GB have been imported on the new server. Anyone know why these numbers are so far apart? Importing server IBM p570 LPAR AIX O/S 5300-03 Storage Management Server for AIX-RS/6000 - Version 5, Release 3, Level 3.3 Exporting server SUN E4800 Storage Management Server for Solaris 8/9 - Version 5, Release 2, Level 7.3 q pro on importing server Process Process Description Status Number - 690 IMPORT (from Server ANR0648I Have copied the following: 1 Filespaces 75472 Backup Files 27346163 Kilobytes (0 errors have been detected). q pro on exporting server Process Process Description Status Number - 36 EXPORT NODE ANR0648I Have copied the following: 1 Nodes 1 Filespaces 24236918 Backup Files 5320531 Megabytes (0 errors have been detected). Appreciate any insight, Thank you, Bill Evans
Stats
Hello, Can anyone tell me if there is a way/ query to find the following: 1. total GB currently stored in tape library == run audit license first, then 'q audit' , add all the Total storage used 2. average nightly GB that are backed up == ?? 3. average nightly GB that expire ==?? 4. Average nightly GB of TDP backup ==?? ( I think if I can find out how on # 2, I can figure out # 4) Thank you for your help. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860)862-8164 (cell) (860)961-6976
Re: Stats
In answer to getting nightly backup volume, I use the following (AIX/Korn shell) to get both total for the night and individual node's data. The reason for the loop on a single node is due to some file-systems being so huge that run a simple dsmc inc would kill the box - so I backup each file-system individually. - cat $INPUTFILE | while read LINE; do NODE=`echo $LINE | cut -f1 -d,` integer NODETOTAL=0 dsmadmc -id=admin -pass=$TSMPWD select entity,activity,bytes as BYTES from summary where (activity='BACKUP' or activity='ARCHIVE') and (end _time between '$YESTERDAY 05:30:20' and '$TODAY 05:30:19') and entity='$NODE' order by bytes desc | grep $NODE | grep -v ANS8000I | awk '{prin t $3 }' |while read BACKUPVOL; do integer NODETOTAL=`expr $NODETOTAL + $BACKUPVOL` done fi printf ${LINE}${NODETOTAL},\n $OUTPUTFILE done I'm sure that someone else has a single-line of code to do the same thing, but this works for me. HTH David -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Monday, April 07, 2008 4:09 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Stats Hello, Can anyone tell me if there is a way/ query to find the following: 1. total GB currently stored in tape library == run audit license first, then 'q audit' , add all the Total storage used 2. average nightly GB that are backed up == ?? 3. average nightly GB that expire ==?? 4. Average nightly GB of TDP backup ==?? ( I think if I can find out how on # 2, I can figure out # 4) Thank you for your help. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860)862-8164 (cell) (860)961-6976 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. **
Re: Stats
Make use of the TSM Accounting records for period averages and reports. Richard Sims
Re: Re: Stats
Taylor, David wrote: In answer to getting nightly backup volume, I use the following (AIX/Korn shell) to get both total for the night and individual node's data. The reason for the loop on a single node is due to some file-systems being so huge that run a simple dsmc inc would kill the box - so I backup each file-system individually. Without actually writing up any code, I'd offer a couple tips for improving on the below. First, run a single select statement and and save the output to a file; this reduced processing load on the TSM server. Include the node_name and domain_name fields in the select. You can then pull whatever data you need from that file much more quickly. Second, use the -TABdelimited or -COMMAdelimited option on the dsmadmc run to make the output more easily machine-parsable. Between those two things, you can easily run multiple canned or one-off reports on the same data, or you can import the data into another app (e.g. Excel or MySQL) and work with it however you like. Having the domain_name included allows you to run reports by policy domain as well as node name. - cat $INPUTFILE | while read LINE; do NODE=`echo $LINE | cut -f1 -d,` integer NODETOTAL=0 dsmadmc -id=admin -pass=$TSMPWD select entity,activity,bytes as BYTES from summary where (activity='BACKUP' or activity='ARCHIVE') and (end _time between '$YESTERDAY 05:30:20' and '$TODAY 05:30:19') and entity='$NODE' order by bytes desc | grep $NODE | grep -v ANS8000I | awk '{prin t $3 }' |while read BACKUPVOL; do integer NODETOTAL=`expr $NODETOTAL + $BACKUPVOL` done fi printf ${LINE}${NODETOTAL},\n $OUTPUTFILE done I'm sure that someone else has a single-line of code to do the same thing, but this works for me. HTH David -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Monday, April 07, 2008 4:09 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Stats Hello, Can anyone tell me if there is a way/ query to find the following: 1. total GB currently stored in tape library == run audit license first, then 'q audit' , add all the Total storage used 2. average nightly GB that are backed up == ?? 3. average nightly GB that expire ==?? 4. Average nightly GB of TDP backup ==?? ( I think if I can find out how on # 2, I can figure out # 4) Thank you for your help. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860)862-8164 (cell) (860)961-6976 -- Hello World.David Bronder - Systems Admin Segmentation Fault ITS-SPA, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. [EMAIL PROTECTED]
Obtaining stats with proxynode...
Hi, Taking a look to the summary table I find the following... At this time I was using a proxynode config to backup a big gpfs: Fields, node_name,date,activity,start,end,length,Gibabytes,files,successful MN_GPFS_PRO1 2008-01-03 BACKUP 23:03:44 02:35:42 03:31:58527.20 0YES MN_PRO_PROXY 2008-01-03 BACKUP 23:03:44 23:12:16 00:08:32 527.20 1YES (MN_GPFS_PRO1) I was running the following query: select entity as node_name, date(start_time) as date, cast(activity as varchar(10)) as activity, time(start_time) as start,time(end_time) as end, cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as Length, cast(bytes/1024/1024/1024 as decimal(6,2)) as Gigabytes,cast(affected as decimal(7,0)) as files, successful from summary where start_time=current_timestamp - 1 day and activity='BACKUP' order by successful, node_name It is the same file that was backed up, the same number of gigabytes,... I could understand that MN_GPFS_PRO1 did not backup the file because it was the agent that was doing that job but I did not understand the difference about the end times... what is the correct value ¿? Do we have an explanation about it ¿? Or did someone find the same situation ¿? Thanks in advance !! Regards, Ibán.
No stats w/Journaling
One of our groups has been consolidating a bunch of Netware file/print servers into two Windows clusters. On one of these, backups were running 7-8 hours, backing up around 4000 objects but inspecting over 5 million. The admin implemented journalling over the weekend and we saw a dramatic improvement down to only 12-15 minutes to complete the backup successfully. The problem is that we no longer see any statistics in either the DSMSCHED.LOG or on the server activity log. On the client, we see the following: 09/30/2007 17:00:12 Querying Journal for '\\dpc-fp07c\p$' 09/30/2007 17:00:13 Processing 41 Journal entries for '\\dpc-fp07c\p$' 09/30/2007 17:00:13 Successful incremental backup of '\\dpc-fp07c\p$' 09/30/2007 17:00:13 Querying Journal for '\\dpc-fp07c\u$' 09/30/2007 17:00:14 Processing 335 Journal entries for '\\dpc-fp07c\u$' 09/30/2007 17:00:18 Successful incremental backup of '\\dpc-fp07c\u$' 09/30/2007 17:00:18 Querying Journal for '\\dpc-fp07c\v$' 09/30/2007 17:00:24 Processing 14,948 Journal entries for '\\dpc-fp07c\v$' 09/30/2007 17:00:56 Successful incremental backup of '\\dpc-fp07c\v$' 09/30/2007 17:00:56 --- SCHEDULEREC STATUS BEGIN 09/30/2007 17:00:56 --- SCHEDULEREC OBJECT END SAN2 09/30/2007 17:00:00 09/30/2007 17:00:56 Scheduled event 'SAN2' completed successfully. As you can see, no info on what objects were backed up, how much was transferred, transfer time, etc. We're not even sure anything got backed up. Client is Win2003 running Version 5.3.2 of the client. Anyone seen anything similar or have any suggestions as to what's going on here? Thanks Sam Sheppard San Diego Data Processing Corp. (858)-581-9668
Re: Drive utilization stats
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Fawad Baig Sent: Wednesday, November 08, 2006 8:21 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Drive utilization stats Hi guys, Im looking for an existing tool/script (probably exists im not aware) for capturing drive utilization on my TSM boxes for performance review purposes say during peak hours. Is there anything i can use to determine this...run every hour and get some numbers...etc ? i need to give in some stats and this would help greatly. Thx in adv. -- Regards, Fawad Baig ÿþD i t b e r i c h t i s v e r t r o u w e l i j k e n k a n g e h e i m e i n f o r m a t i e b e v a t t e n e n k e l b e s t e m d v o o r d e g e a d r e s s e e r d e . I n d i e n d i t b e r i c h t n i e t v o o r u i s b e s t e m d , v e r z o e k e n w i j u d i t o n m i d d e l l i j k a a n o n s t e m e l d e n e n h e t b e r i c h t t e v e r n i e t i g e n . A a n g e z i e n d e i n t e g r i t e i t v a n h e t b e r i c h t n i e t v e i l i g g e s t e l d i s m i d d e l s v e r z e n d i n g v i a i n t e r n e t , k a n A t o s O r i g i n n i e t a a n s p r a k e l i j k w o r d e n g e h o u d e n v o o r d e i n h o u d d a a r v a n . H o e w e l w i j o n s i n s p a n n e n e e n v i r u s v r i j n e t w e r k t e h a n t e r e n , g e v e n w i j g e e n e n k e l e g a r a n t i e d a t d i t b e r i c h t v i r u s v r i j i s , n o c h a a n v a a r d e n w i j e n i g e a a n s p r a k e l i j k h e i d v o o r d e m o g e l i j k e a a n w e z i g h e i d v a n e e n v i r u s i n d i t b e r i c h t . O p a l o n z e r e c h t s v e r h o u d i n g e n , a a n b i e d i n g e n e n o v e r e e n k o m s t e n w a a r o n d e r A t o s O r i g i n g o e d e r e n e n / o f d i e n s t e n l e v e r t z i j n m e t u i t s l u i t i n g v a n a l l e a n d e r e v o o r w a a r d e n d e L e v e r i n g s v o o r w a a r d e n v a n A t o s O r i g i n v a n t o e p a s s i n g . D e z e w o r d e n u o p a a n v r a a g d i r e c t k o s t e l o o s t o e g e z o n d e n . T h i s e - m a i l a n d t h e d o c u m e n t s a t t a c h e d a r e c o n f i d e n t i a l a n d i n t e n d e d s o l e l y f o r t h e a d d r e s s e e ; i t m a y a l s o b e p r i v i l e g e d . I f y o u r e c e i v e t h i s e - m a i l i n e r r o r , p l e a s e n o t i f y t h e s e n d e r i m m e d i a t e l y a n d d e s t r o y i t . A s i t s i n t e g r i t y c a n n o t b e s e c u r e d o n t h e I n t e r n e t , t h e A t o s O r i g i n g r o u p l i a b i l i t y c a n n o t b e t r i g g e r e d f o r t h e m e s s a g e c o n t e n t . A l t h o u g h t h e s e n d e r e n d e a v o u r s t o m a i n t a i n a c o m p u t e r v i r u s - f r e e n e t w o r k , t h e s e n d e r d o e s n o t w a r r a n t t h a t t h i s t r a n s m i s s i o n i s v i r u s - f r e e a n d w i l l n o t b e l i a b l e f o r a n y d a m a g e s r e s u l t i n g f r o m a n y v i r u s t r a n s m i t t e d . O n a l l o f f e r s a n d a g r e e m e n t s u n d e r w h i c h A t o s O r i g i n s u p p l i e s g o o d s a n d / o r s e r v i c e s o f w h a t e v e r n a t u r e , t h e T e r m s o f D e l i v e r y f r o m A t o s O r i g i n e x c l u s i v e l y a p p l y . T h e T e r m s o f D e l i v e r y s h a l l b e p r o m p t l y s u b m i t t e d t o y o u o n y o u r r e q u e s t
Drive utilization stats
Hi guys, Im looking for an existing tool/script (probably exists im not aware) for capturing drive utilization on my TSM boxes for performance review purposes say during peak hours. Is there anything i can use to determine this...run every hour and get some numbers...etc ? i need to give in some stats and this would help greatly. Thx in adv. -- Regards, Fawad Baig
Re: Drive utilization stats
Look at the SUMMARY table (for use with a TSM SELECT). To see what is in there, enter: select * from summary where activity='TAPE MOUNT' There is an entry with the start/end time for each tape mount. Do a little arithmetic to get the drive-busy time. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Fawad Baig Sent: Wednesday, November 08, 2006 2:21 PM To: ADSM-L@VM.MARIST.EDU Subject: Drive utilization stats Hi guys, Im looking for an existing tool/script (probably exists im not aware) for capturing drive utilization on my TSM boxes for performance review purposes say during peak hours. Is there anything i can use to determine this...run every hour and get some numbers...etc ? i need to give in some stats and this would help greatly. Thx in adv. -- Regards, Fawad Baig
Re: Drive utilization stats
Hi, TSM Operational Reports has a section in it, displaying this info. Better info you can get with TSM Manager, ServerGraph and/or the Health Check for ITSM. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Fawad Baig Sent: woensdag 8 november 2006 20:21 To: ADSM-L@VM.MARIST.EDU Subject: Drive utilization stats Hi guys, Im looking for an existing tool/script (probably exists im not aware) for capturing drive utilization on my TSM boxes for performance review purposes say during peak hours. Is there anything i can use to determine this...run every hour and get some numbers...etc ? i need to give in some stats and this would help greatly. Thx in adv. -- Regards, Fawad Baig ÿþD i t b e r i c h t i s v e r t r o u w e l i j k e n k a n g e h e i m e i n f o r m a t i e b e v a t t e n e n k e l b e s t e m d v o o r d e g e a d r e s s e e r d e . I n d i e n d i t b e r i c h t n i e t v o o r u i s b e s t e m d , v e r z o e k e n w i j u d i t o n m i d d e l l i j k a a n o n s t e m e l d e n e n h e t b e r i c h t t e v e r n i e t i g e n . A a n g e z i e n d e i n t e g r i t e i t v a n h e t b e r i c h t n i e t v e i l i g g e s t e l d i s m i d d e l s v e r z e n d i n g v i a i n t e r n e t , k a n A t o s O r i g i n n i e t a a n s p r a k e l i j k w o r d e n g e h o u d e n v o o r d e i n h o u d d a a r v a n . H o e w e l w i j o n s i n s p a n n e n e e n v i r u s v r i j n e t w e r k t e h a n t e r e n , g e v e n w i j g e e n e n k e l e g a r a n t i e d a t d i t b e r i c h t v i r u s v r i j i s , n o c h a a n v a a r d e n w i j e n i g e a a n s p r a k e l i j k h e i d v o o r d e m o g e l i j k e a a n w e z i g h e i d v a n e e n v i r u s i n d i t b e r i c h t . O p a l o n z e r e c h t s v e r h o u d i n g e n , a a n b i e d i n g e n e n o v e r e e n k o m s t e n w a a r o n d e r A t o s O r i g i n g o e d e r e n e n / o f d i e n s t e n l e v e r t z i j n m e t u i t s l u i t i n g v a n a l l e a n d e r e v o o r w a a r d e n d e L e v e r i n g s v o o r w a a r d e n v a n A t o s O r i g i n v a n t o e p a s s i n g . D e z e w o r d e n u o p a a n v r a a g d i r e c t k o s t e l o o s t o e g e z o n d e n . T h i s e - m a i l a n d t h e d o c u m e n t s a t t a c h e d a r e c o n f i d e n t i a l a n d i n t e n d e d s o l e l y f o r t h e a d d r e s s e e ; i t m a y a l s o b e p r i v i l e g e d . I f y o u r e c e i v e t h i s e - m a i l i n e r r o r , p l e a s e n o t i f y t h e s e n d e r i m m e d i a t e l y a n d d e s t r o y i t . A s i t s i n t e g r i t y c a n n o t b e s e c u r e d o n t h e I n t e r n e t , t h e A t o s O r i g i n g r o u p l i a b i l i t y c a n n o t b e t r i g g e r e d f o r t h e m e s s a g e c o n t e n t . A l t h o u g h t h e s e n d e r e n d e a v o u r s t o m a i n t a i n a c o m p u t e r v i r u s - f r e e n e t w o r k , t h e s e n d e r d o e s n o t w a r r a n t t h a t t h i s t r a n s m i s s i o n i s v i r u s - f r e e a n d w i l l n o t b e l i a b l e f o r a n y d a m a g e s r e s u l t i n g f r o m a n y v i r u s t r a n s m i t t e d . O n a l l o f f e r s a n d a g r e e m e n t s u n d e r w h i c h A t o s O r i g i n s u p p l i e s g o o d s a n d / o r s e r v i c e s o f w h a t e v e r n a t u r e , t h e T e r m s o f D e l i v e r y f r o m A t o s O r i g i n e x c l u s i v e l y a p p l y . T h e T e r m s o f D e l i v e r y s h a l l b e p r o m p t l y s u b m i t t e d t o y o u o n y o u r r e q u e s t
finding compression % stats on TDP clients
TSM serv 5.2.2.0 5.2.4.2 TDP on SQL Exchange 5.2.1.0 I have compression enabled on all my TDP client, and want to know how much I am getting, for daily reports. The TDP message gives the pre-compressed size, but not the post-compressed or percent compressed. Is this in another message? I dont have access to the accounting log file (I only manage the clients and a limited part of the TSM Server). While we're at it, I would like to know the network throughput as well. Basically, I want everything for my TDP clients that I get for the BA clients. 03/10/06 12:08:26 ANE4991I (Session: 213809, Node: MUIR_DS) TDP MSExchg ACN3516 Data Protection for Exchange: Backup of server MUIR is complete. Total storage groups backed up: 1 Total bytes transferred: 58408413428 Elapsed processing time: 4096.74 Secs Throughput rate: 13923.15 Kb/Sec (SESSION: 213809) Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) ***public*** Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: finding compression % stats on TDP clients
If you have access to the server, you should be able to pull Q ACT BEGINT= ENDT= BEGIND= ENDD= SEARCH= The message numbers to search on start with ANE49xxI where xx is one of these: 03/10/06 18:00:11 ANE4952I (Session: 40949, Node: DEADBEEF) Total number of objects inspected:3 (SESSION: 40949) 03/10/06 18:00:11 ANE4953I (Session: 40949, Node: DEADBEEF) Total number of objects archived: 3 (SESSION: 40949) 03/10/06 18:00:11 ANE4958I (Session: 40949, Node: DEADBEEF) Total number of objects updated: 0 (SESSION: 40949) 03/10/06 18:00:11 ANE4960I (Session: 40949, Node: DEADBEEF) Total number of objects rebound: 0 (SESSION: 40949) 03/10/06 18:00:11 ANE4957I (Session: 40949, Node: DEADBEEF) Total number of objects deleted: 0 (SESSION: 40949) 03/10/06 18:00:11 ANE4970I (Session: 40949, Node: DEADBEEF) Total number of objects expired: 0 (SESSION: 40949) 03/10/06 18:00:11 ANE4959I (Session: 40949, Node: DEADBEEF) Total number of objects failed: 0 (SESSION: 40949) 03/10/06 18:00:11 ANE4961I (Session: 40949, Node: DEADBEEF) Total number of bytes transferred: 45.13 KB (SESSION: 40949) 03/10/06 18:00:11 ANE4963I (Session: 40949, Node: DEADBEEF) Data transfer time: 0.00 sec (SESSION: 40949) 03/10/06 18:00:11 ANE4966I (Session: 40949, Node: DEADBEEF) Network data transfer rate:146,550.95 KB/sec (SESSION: 40949) 03/10/06 18:00:11 ANE4967I (Session: 40949, Node: DEADBEEF) Aggregate data transfer rate: 22.35 KB/sec (SESSION: 40949) 03/10/06 18:00:11 ANE4968I (Session: 40949, Node: DEADBEEF) Objects compressed by: 98% (SESSION: 40949) 03/10/06 18:00:11 ANE4964I (Session: 40949, Node: DEADBEEF) Elapsed processing time:00:00:02 (SESSION: 40949) 03/10/06 18:00:11 ANR0403I Session 40949 ended for node DEADBEEF (SUN SOLARIS). (SESSION: 40949) On 06.03.10 at 15:54 [EMAIL PROTECTED] wrote: Date: Fri, 10 Mar 2006 15:54:41 -0500 From: Schaub, Steve [EMAIL PROTECTED] Reply-To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU Subject: finding compression % stats on TDP clients TSM serv 5.2.2.0 5.2.4.2 TDP on SQL Exchange 5.2.1.0 I have compression enabled on all my TDP client, and want to know how much I am getting, for daily reports. The TDP message gives the pre-compressed size, but not the post-compressed or percent compressed. Is this in another message? I dont have access to the accounting log file (I only manage the clients and a limited part of the TSM Server). While we're at it, I would like to know the network throughput as well. Basically, I want everything for my TDP clients that I get for the BA clients. 03/10/06 12:08:26 ANE4991I (Session: 213809, Node: MUIR_DS) TDP MSExchg ACN3516 Data Protection for Exchange: Backup of server MUIR is complete. Total storage groups backed up: 1 Total bytes transferred: 58408413428 Elapsed processing time: 4096.74 Secs Throughput rate: 13923.15 Kb/Sec (SESSION: 213809) Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) ***public*** Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: finding compression % stats on TDP clients
Oops, I completely disregarded TDP. If you can get the admin to grant you SQL authority (ANALYST I think), you can select from SUMMARY which will show start/end times plus bytes received. Then you could divide that by the bytes sent to get your compression ratio. There's nowhere to get network rate if the client doesn't report it. -Josh On 06.03.10 at 15:54 [EMAIL PROTECTED] wrote: Date: Fri, 10 Mar 2006 15:54:41 -0500 From: Schaub, Steve [EMAIL PROTECTED] Reply-To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU Subject: finding compression % stats on TDP clients TSM serv 5.2.2.0 5.2.4.2 TDP on SQL Exchange 5.2.1.0 I have compression enabled on all my TDP client, and want to know how much I am getting, for daily reports. The TDP message gives the pre-compressed size, but not the post-compressed or percent compressed. Is this in another message? I dont have access to the accounting log file (I only manage the clients and a limited part of the TSM Server). While we're at it, I would like to know the network throughput as well. Basically, I want everything for my TDP clients that I get for the BA clients. 03/10/06 12:08:26 ANE4991I (Session: 213809, Node: MUIR_DS) TDP MSExchg ACN3516 Data Protection for Exchange: Backup of server MUIR is complete. Total storage groups backed up: 1 Total bytes transferred: 58408413428 Elapsed processing time: 4096.74 Secs Throughput rate: 13923.15 Kb/Sec (SESSION: 213809) Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) ***public*** Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
TSM DB stats not good
Hello, Our TSM server was upgraded to 5.2.4 on an AIX 5.2 server. I haven't changed any parameters and before the upgrade the cache hit pct was 99.95% As you can see it is now only 95.9. Is there some parameter that I should have changed that I am not aware of? Thanks! Available Space (MB): 40,960 Assigned Capacity (MB): 34,400 Maximum Extension (MB): 6,560 Maximum Reduction (MB): 13,104 Page Size (bytes): 4,096 Total Usable Pages: 8,806,400 Used Pages: 5,385,669 Pct Util: 61.2 Max. Pct Util: 61.2 Physical Volumes: 5 Buffer Pool Pages: 512 Total Buffer Requests: 525,272,608 Cache Hit Pct.: 95.90 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 719.21 Percentage Changed: 3.42 Last Complete Backup Date/Time: 06/19/05 08:40:36 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: TSM DB stats not good
Hi again, I think your bufferpool pages are low, only 512?? Are you sure you are using the right dsmserv.opt? Available Space (MB): 121,856 Assigned Capacity (MB): 119,856 Maximum Extension (MB): 2,000 Maximum Reduction (MB): 6,240 Page Size (bytes): 4,096 Total Usable Pages: 30,683,136 Used Pages: 28,063,455 Pct Util: 91.5 Max. Pct Util: 91.6 Physical Volumes: 24 Buffer Pool Pages: 393,216 Total Buffer Requests: 1,563,470,178 Cache Hit Pct.: 98.17 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 1641.87 Percentage Changed: 1.50 Last Complete Backup Date/Time: 06/20/2005 07:03:58 //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:01 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB stats not good Hello, Our TSM server was upgraded to 5.2.4 on an AIX 5.2 server. I haven't changed any parameters and before the upgrade the cache hit pct was 99.95% As you can see it is now only 95.9. Is there some parameter that I should have changed that I am not aware of? Thanks! Available Space (MB): 40,960 Assigned Capacity (MB): 34,400 Maximum Extension (MB): 6,560 Maximum Reduction (MB): 13,104 Page Size (bytes): 4,096 Total Usable Pages: 8,806,400 Used Pages: 5,385,669 Pct Util: 61.2 Max. Pct Util: 61.2 Physical Volumes: 5 Buffer Pool Pages: 512 Total Buffer Requests: 525,272,608 Cache Hit Pct.: 95.90 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 719.21 Percentage Changed: 3.42 Last Complete Backup Date/Time: 06/19/05 08:40:36 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: TSM DB stats not good
Hi, How can I tell which dsmserv.opt file the server is using when it is running? Thanks! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Henrik Wahlstedt [EMAIL PROTECTED] To ADSM-L@VM.MARIST.EDU Sent by: ADSM:cc Dist Stor Manager Subject [EMAIL PROTECTED] Re: TSM DB stats not good .EDU 06/20/2005 08:07 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Hi again, I think your bufferpool pages are low, only 512?? Are you sure you are using the right dsmserv.opt? Available Space (MB): 121,856 Assigned Capacity (MB): 119,856 Maximum Extension (MB): 2,000 Maximum Reduction (MB): 6,240 Page Size (bytes): 4,096 Total Usable Pages: 30,683,136 Used Pages: 28,063,455 Pct Util: 91.5 Max. Pct Util: 91.6 Physical Volumes: 24 Buffer Pool Pages: 393,216 Total Buffer Requests: 1,563,470,178 Cache Hit Pct.: 98.17 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 1641.87 Percentage Changed: 1.50 Last Complete Backup Date/Time: 06/20/2005 07:03:58 //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:01 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB stats not good Hello, Our TSM server was upgraded to 5.2.4 on an AIX 5.2 server. I haven't changed any parameters and before the upgrade the cache hit pct was 99.95% As you can see it is now only 95.9. Is there some parameter that I should have changed that I am not aware of? Thanks! Available Space (MB): 40,960 Assigned Capacity (MB): 34,400 Maximum Extension (MB): 6,560 Maximum Reduction (MB): 13,104 Page Size (bytes): 4,096 Total Usable Pages: 8,806,400 Used Pages: 5,385,669 Pct Util: 61.2 Max. Pct Util: 61.2 Physical Volumes: 5 Buffer Pool Pages: 512 Total Buffer Requests: 525,272,608 Cache Hit Pct.: 95.90 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 719.21 Percentage Changed: 3.42 Last Complete Backup Date/Time: 06/19/05 08:40:36 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: TSM DB stats not good
It should reside in the server directory. I was just guessing that you original dsmserv.opt was replaced during the upgrade...? //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM DB stats not good Hi, How can I tell which dsmserv.opt file the server is using when it is running? Thanks! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Henrik Wahlstedt [EMAIL PROTECTED] To ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc Dist Stor Manager Subject [EMAIL PROTECTED] Re: TSM DB stats not good .EDU 06/20/2005 08:07 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Hi again, I think your bufferpool pages are low, only 512?? Are you sure you are using the right dsmserv.opt? Available Space (MB): 121,856 Assigned Capacity (MB): 119,856 Maximum Extension (MB): 2,000 Maximum Reduction (MB): 6,240 Page Size (bytes): 4,096 Total Usable Pages: 30,683,136 Used Pages: 28,063,455 Pct Util: 91.5 Max. Pct Util: 91.6 Physical Volumes: 24 Buffer Pool Pages: 393,216 Total Buffer Requests: 1,563,470,178 Cache Hit Pct.: 98.17 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 1641.87 Percentage Changed: 1.50 Last Complete Backup Date/Time: 06/20/2005 07:03:58 //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:01 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB stats not good Hello, Our TSM server was upgraded to 5.2.4 on an AIX 5.2 server. I haven't changed any parameters and before the upgrade the cache hit pct was 99.95% As you can see it is now only 95.9. Is there some parameter that I should have changed that I am not aware of? Thanks! Available Space (MB): 40,960 Assigned Capacity (MB): 34,400 Maximum Extension (MB): 6,560 Maximum Reduction (MB): 13,104 Page Size (bytes): 4,096 Total Usable Pages: 8,806,400 Used Pages: 5,385,669 Pct Util: 61.2 Max. Pct Util: 61.2 Physical Volumes: 5 Buffer Pool Pages: 512 Total Buffer Requests: 525,272,608 Cache Hit Pct.: 95.90 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 719.21 Percentage Changed: 3.42 Last Complete Backup Date/Time: 06/19/05 08:40:36 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you. --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: TSM DB stats not good
I looks like when the server was upgraded the dsmservstart script was changed to a different path for the dsmserv.opt file export DSMSERV_CONFIG=/sharedfs/files/dsmserv.opt cd /usr/tivoli/tsm/server/bin #export DSMSERV_CONFIG=/usr/tivoli/tsm/server/bin/dsmserv.opt We'll have to change it to the correct path within the /usr/tivoli/tsm/server/bin directory instead of /sharedfs/files directory. Thanks again for your help Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Henrik Wahlstedt [EMAIL PROTECTED] To ADSM-L@VM.MARIST.EDU Sent by: ADSM:cc Dist Stor Manager Subject [EMAIL PROTECTED] Re: TSM DB stats not good .EDU 06/20/2005 08:38 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU It should reside in the server directory. I was just guessing that you original dsmserv.opt was replaced during the upgrade...? //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM DB stats not good Hi, How can I tell which dsmserv.opt file the server is using when it is running? Thanks! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Henrik Wahlstedt [EMAIL PROTECTED] To ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc Dist Stor Manager Subject [EMAIL PROTECTED] Re: TSM DB stats not good .EDU 06/20/2005 08:07 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Hi again, I think your bufferpool pages are low, only 512?? Are you sure you are using the right dsmserv.opt? Available Space (MB): 121,856 Assigned Capacity (MB): 119,856 Maximum Extension (MB): 2,000 Maximum Reduction (MB): 6,240 Page Size (bytes): 4,096 Total Usable Pages: 30,683,136 Used Pages: 28,063,455 Pct Util: 91.5 Max. Pct Util: 91.6 Physical Volumes: 24 Buffer Pool Pages: 393,216 Total Buffer Requests: 1,563,470,178 Cache Hit Pct.: 98.17 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 1641.87 Percentage Changed: 1.50 Last Complete Backup Date/Time: 06/20/2005 07:03:58 //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:01 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB stats not good Hello, Our TSM server was upgraded to 5.2.4 on an AIX 5.2 server. I haven't changed any parameters and before the upgrade the cache hit pct was 99.95% As you can see it is now only 95.9. Is there some parameter that I should have changed that I am not aware of? Thanks! Available Space (MB): 40,960 Assigned Capacity (MB): 34,400 Maximum Extension (MB): 6,560 Maximum Reduction (MB): 13,104 Page Size (bytes): 4,096 Total Usable Pages: 8,806,400 Used Pages: 5,385,669 Pct Util: 61.2 Max. Pct Util: 61.2 Physical Volumes: 5 Buffer Pool Pages: 512 Total Buffer Requests: 525,272,608 Cache Hit Pct.: 95.90 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 719.21 Percentage Changed: 3.42 Last Complete Backup Date/Time: 06/19/05 08:40:36 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you
Antwort: Re: [ADSM-L] TSM DB stats not good
hi joni, i think the server runs the .sys or .opt files wich are placed in the /... /ba/bin or \programs\...\baclient path, that is where the tsm software is installed. maybe, you have your right file in the wrong folder ? regards, Dierk Hi, How can I tell which dsmserv.opt file the server is using when it is running? Thanks! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Henrik Wahlstedt [EMAIL PROTECTED] To ADSM-L@VM.MARIST.EDU Sent by: ADSM:cc Dist Stor Manager Subject [EMAIL PROTECTED] Re: TSM DB stats not good .EDU 06/20/2005 08:07 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Hi again, I think your bufferpool pages are low, only 512?? Are you sure you are using the right dsmserv.opt? Available Space (MB): 121,856 Assigned Capacity (MB): 119,856 Maximum Extension (MB): 2,000 Maximum Reduction (MB): 6,240 Page Size (bytes): 4,096 Total Usable Pages: 30,683,136 Used Pages: 28,063,455 Pct Util: 91.5 Max. Pct Util: 91.6 Physical Volumes: 24 Buffer Pool Pages: 393,216 Total Buffer Requests: 1,563,470,178 Cache Hit Pct.: 98.17 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 1641.87 Percentage Changed: 1.50 Last Complete Backup Date/Time: 06/20/2005 07:03:58 //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: den 20 juni 2005 14:01 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB stats not good Hello, Our TSM server was upgraded to 5.2.4 on an AIX 5.2 server. I haven't changed any parameters and before the upgrade the cache hit pct was 99.95% As you can see it is now only 95.9. Is there some parameter that I should have changed that I am not aware of? Thanks! Available Space (MB): 40,960 Assigned Capacity (MB): 34,400 Maximum Extension (MB): 6,560 Maximum Reduction (MB): 13,104 Page Size (bytes): 4,096 Total Usable Pages: 8,806,400 Used Pages: 5,385,669 Pct Util: 61.2 Max. Pct Util: 61.2 Physical Volumes: 5 Buffer Pool Pages: 512 Total Buffer Requests: 525,272,608 Cache Hit Pct.: 95.90 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 719.21 Percentage Changed: 3.42 Last Complete Backup Date/Time: 06/19/05 08:40:36 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: REAL TIME STATS
On Saturday 04 December 2004 20:01, Bill Boyer wrote: Find the message number associated with all the select statements and any responses you don't want in the actlog and then at the start of your script DISABLE EVENT ACTLOG , then re-ENABLE them when you're done. The problem is that each time I use dsmadmc to query tsm, you see a line that I logged on, a line with the command and a line that I logged of. You can get rid of these messages, but then you don't see these messages from any user. Ideally, I should be able to disable the messages related to 1 specific user that I use to poll tsm. Stef
Re: REAL TIME STATS
There are two scripts that you can run: run q_ses_stats run q_proc_stats Run these from within the administrative command console. [EMAIL PROTECTED] 03-Dec-04 3:45:03 PM Does anyone know how to get TSM real time statistics, including disk pool util, bytes backed up per 15 or 30 minutes. Thanks, Jason Cain
Re: REAL TIME STATS
These are not default scripts that come with TSM, what is the SQL statement behind. q script q_ses_stats f=d q script q_proc_stats f=d -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Miles Purdy Sent: Monday, December 06, 2004 2:38 PM To: [EMAIL PROTECTED] Subject: Re: REAL TIME STATS There are two scripts that you can run: run q_ses_stats run q_proc_stats Run these from within the administrative command console. [EMAIL PROTECTED] 03-Dec-04 3:45:03 PM Does anyone know how to get TSM real time statistics, including disk pool util, bytes backed up per 15 or 30 minutes. Thanks, Jason Cain
Re: REAL TIME STATS
These are not default scripts that come with TSM, what is the SQL statement behind. q script q_ses_stats f=d q script q_proc_stats f=d The q_* scripts have historically been provided in the scripts.smp file. They need to be installed per the Quick Start manual in order to be available for use. Richard Sims
Re: REAL TIME STATS
On Friday 03 December 2004 22:45, Cain, Jason (Corporate) wrote: Does anyone know how to get TSM real time statistics, including disk pool util, bytes backed up per 15 or 30 minutes. Not with tsm itself. We use perl + rrd. We query the tsm server each 15 minutes and store the info with rrd. We also use perl + rrd to generate the images on the fly in a web browser. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
Re: REAL TIME STATS
Are you running SQL statement against the DB, what kind of data are you actually pulling, and from what tables. I can get real time stats from sessions currently running from the sessions table, but that is as far as I have gotten. We are looking for a way to get real time stats on disk util., and bytes backed up per 30 min for an overall TSM healthcheck. Jason -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Stef Coene Sent: Saturday, December 04, 2004 4:44 AM To: [EMAIL PROTECTED] Subject: Re: REAL TIME STATS On Friday 03 December 2004 22:45, Cain, Jason (Corporate) wrote: Does anyone know how to get TSM real time statistics, including disk pool util, bytes backed up per 15 or 30 minutes. Not with tsm itself. We use perl + rrd. We query the tsm server each 15 minutes and store the info with rrd. We also use perl + rrd to generate the images on the fly in a web browser. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
Re: REAL TIME STATS
On Saturday 04 December 2004 14:33, Cain, Jason (Corporate) wrote: Are you running SQL statement against the DB, what kind of data are you actually pulling, and from what tables. I can get real time stats from sessions currently running from the sessions table, but that is as far as I have gotten. We are looking for a way to get real time stats on disk util., and bytes backed up per 30 min for an overall TSM healthcheck. The stats we are making is information about the storage pools (usage in MB, usage in %, ...), number of sessions that's running (client + SAN), db and recovery log usage (MB en %). All this info is stored with rrd so this info can be used for long term monitoring. And we do this each 5 minutes, not 15 like I said before. The tables we use depends on what you want to check. But with information found with the select * from tables and some sql knowledge, you can do a lot. For real time monitoring, we have some havy sql statements to view the running sessions and processes. We also query and show information about processes that have run (so you can see when a migration kicked in at night). This information is not stored wih rrd. Example of showing running sessions: select client_name,BYTES_RECEIVED,BYTES_SENT, cast(bytes_received as decimal(30,0))/cast((current_timestamp-start_time)seconds as decimal(30,0)) as BYTES_REC_PER_SEC, cast(bytes_sent as decimal(30,0)) /cast((current_timestamp-start_time)seconds as decimal(30,0)) as BYTES_SENT_PER_SEC, cast((current_timestamp-start_time) as varchar(18)) as elapsed,SESSION_TYPE,CLIENT_PLATFORM from sessions where current_timestamp != start_time and SESSION_TYPE != 'Server' One problem is that all these selects statements show up in the activity log. So it can be dificult to use the activity log to find out what happened on the server. Btw, all these scripts are only available to our customers :( If you are interested in these scripts and/or want to see a demo, you can mail me in private. If there is enough interest, I can, maybe, release the scripts. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
Re: REAL TIME STATS
Find the message number associated with all the select statements and any responses you don't want in the actlog and then at the start of your script DISABLE EVENT ACTLOG , then re-ENABLE them when you're done. Bill Boyer My problem was caused by a loose screw at the keyboard - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Stef Coene Sent: Saturday, December 04, 2004 11:22 AM To: [EMAIL PROTECTED] Subject: Re: REAL TIME STATS On Saturday 04 December 2004 14:33, Cain, Jason (Corporate) wrote: Are you running SQL statement against the DB, what kind of data are you actually pulling, and from what tables. I can get real time stats from sessions currently running from the sessions table, but that is as far as I have gotten. We are looking for a way to get real time stats on disk util., and bytes backed up per 30 min for an overall TSM healthcheck. The stats we are making is information about the storage pools (usage in MB, usage in %, ...), number of sessions that's running (client + SAN), db and recovery log usage (MB en %). All this info is stored with rrd so this info can be used for long term monitoring. And we do this each 5 minutes, not 15 like I said before. The tables we use depends on what you want to check. But with information found with the select * from tables and some sql knowledge, you can do a lot. For real time monitoring, we have some havy sql statements to view the running sessions and processes. We also query and show information about processes that have run (so you can see when a migration kicked in at night). This information is not stored wih rrd. Example of showing running sessions: select client_name,BYTES_RECEIVED,BYTES_SENT, cast(bytes_received as decimal(30,0))/cast((current_timestamp-start_time)seconds as decimal(30,0)) as BYTES_REC_PER_SEC, cast(bytes_sent as decimal(30,0)) /cast((current_timestamp-start_time)seconds as decimal(30,0)) as BYTES_SENT_PER_SEC, cast((current_timestamp-start_time) as varchar(18)) as elapsed,SESSION_TYPE,CLIENT_PLATFORM from sessions where current_timestamp != start_time and SESSION_TYPE != 'Server' One problem is that all these selects statements show up in the activity log. So it can be dificult to use the activity log to find out what happened on the server. Btw, all these scripts are only available to our customers :( If you are interested in these scripts and/or want to see a demo, you can mail me in private. If there is enough interest, I can, maybe, release the scripts. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
Re: REAL TIME STATS
Try TSMManager (http://www.tsmmanager.com). You can trial it for free ! It has an auto-update setting/interval. You can bring up a storage-pool display window and have it automatically refresh at your desired interval. Stef Coene [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 12/04/2004 05:44 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Re: REAL TIME STATS On Friday 03 December 2004 22:45, Cain, Jason (Corporate) wrote: Does anyone know how to get TSM real time statistics, including disk pool util, bytes backed up per 15 or 30 minutes. Not with tsm itself. We use perl + rrd. We query the tsm server each 15 minutes and store the info with rrd. We also use perl + rrd to generate the images on the fly in a web browser. Stef -- [EMAIL PROTECTED] Using Linux as bandwidth manager http://www.docum.org/
REAL TIME STATS
Does anyone know how to get TSM real time statistics, including disk pool util, bytes backed up per 15 or 30 minutes. Thanks, Jason Cain
tdp sql backup stats discrepancies
Have any of you TDP for SQL TSMers seen the following and is it a bug or working as designed? When doing a full backup of a sql db the stats in the tsm server activity log and the stats in tdpsdl.log are the same but the event summary record shows different numbers. act log shows1,855,248 bytes sent tdpsql.log shows 1,855,248 byte sent event summary shows722 Kb I noticed this when we turned client side compression on and the act log and tdpsql.log stats did not change but the event summary did change to 321 Kb which showed compression is now being used. Why the discrepancies? = TSM server v5.2.3.2 on Win2000. TDP for DB v5.1.5.0 TSM client v5.2.2.9 = contents of tdpsql.log 12/03/2004 10:18:06 12/03/2004 10:18:06 Request : FULL BACKUP 12/03/2004 10:18:06 Database Input List : - 12/03/2004 10:18:06 Group Input List : - 12/03/2004 10:18:06 File Input List : - 12/03/2004 10:18:06 Number of Buffers : 3 12/03/2004 10:18:06 Buffer Size : 1024 12/03/2004 10:18:06 Number of SQL Buffers : 1 12/03/2004 10:18:06 SQL Buffer Size : 1024 12/03/2004 10:18:06 Number of Stripes specified : 1 12/03/2004 10:18:06 Estimate : - 12/03/2004 10:18:06 Truncate Log? : - 12/03/2004 10:18:06 Wait for Tape Mounts? : Yes 12/03/2004 10:18:06 TSM Options File : S:\Program Files\Tivoli\TSM\TDPSql\dsm.opt 12/03/2004 10:18:06 TSM Nodename Override : - 12/03/2004 10:18:06 Sqlserver : WANC15 12/03/2004 10:18:06 12/03/2004 10:18:25 Total SQL backups selected: 1 12/03/2004 10:18:25 Total SQL backups attempted: 1 12/03/2004 10:18:25 Total SQL backups completed: 1 12/03/2004 10:18:25 Total SQL backups excluded: 0 12/03/2004 10:18:25 Total SQL backups inactivated:0 12/03/2004 10:18:25 Throughput rate: 103.44 Kb/Sec 12/03/2004 10:18:25 Total bytes transferred: 1,855,248 12/03/2004 10:18:25 Elapsed processing time: 17.52 Secs 12/02/2004 21:07:25 12/02/2004 21:07:25 Request : FULL BACKUP 12/02/2004 21:07:25 Database Input List : stellent 12/02/2004 21:07:25 Group Input List : - 12/02/2004 21:07:25 File Input List : - 12/02/2004 21:07:25 Number of Buffers : 3 12/02/2004 21:07:25 Buffer Size : 1024 12/02/2004 21:07:25 Number of SQL Buffers : 1 12/02/2004 21:07:25 SQL Buffer Size : 1024 12/02/2004 21:07:25 Number of Stripes specified : 1 12/02/2004 21:07:25 Estimate : - 12/02/2004 21:07:25 Truncate Log? : - 12/02/2004 21:07:25 Wait for Tape Mounts? : Yes 12/02/2004 21:07:25 TSM Options File : S:\Program Files\Tivoli\TSM\TDPSql\dsm.opt 12/02/2004 21:07:25 TSM Nodename Override : - 12/02/2004 21:07:25 Sqlserver : WANC15 12/02/2004 21:07:25 12/02/2004 21:08:04 Total SQL backups selected: 1 12/02/2004 21:08:04 Total SQL backups attempted: 1 12/02/2004 21:08:04 Total SQL backups completed: 1 12/02/2004 21:08:04 Total SQL backups excluded: 0 12/02/2004 21:08:04 Total SQL backups inactivated:40 12/02/2004 21:08:04 Throughput rate: 157.54 Kb/Sec 12/02/2004 21:08:04 Total bytes transferred: 1,855,248 12/02/2004 21:08:04 Elapsed processing time: 11.50 Secs = display node Node Name: WANC15 Platform: WinNT Client OS Level: 5.00 Client Version: Version 5, Release 2, Level 2.9 Compression: Client Node Type: Client TCP/IP Name: WANC15 = display of summary records 12/02/2004 11:32:16 PM 00:01:212722 Kb 12/03/2004 10:18:07 AM 00:00:182321 Kb = display of activity log 12/02/2004 21:07:21 ANR0403I Session 15250 ended for node WANC15_SQL (). (SESSION: 144) 12/02/2004 21:07:21 ANR2561I Schedule prompter contacting WANC15_SQL (session 15250) to start a scheduled operation. (SESSION: 144) 12/02/2004 21:07:22 ANR0406I Session 15251 started for node WANC15_SQL (WinNT) (Tcp/Ip wanc15.itg.ak.local(4973)). (SESSION: 15251) 12/02/2004 21:07:25 ANR0406I Session 15252 started for node WANC15_SQL (TDP MSSQL) (Tcp/Ip wanc15.itg.ak.local(4977)). (SESSION: 15252) 12/02/2004 21:07:26 ANE4991I (Session: 15252, Node: WANC15_SQL) TDP MSSQL ACO3006 Data Protection for SQL: Starting backup for server WANC15. (SESSION: 15252) 12/02/2004 21:07:27 ANE4991I (Session: 15252, Node: WANC15_SQL
Backup Storage Pool Stats
When I look at this output: tsm: TSMPC1q pr Process Process Description Status Number - 209 Backup Storage Pool Primary Pool RMT_PRIM_LO, Copy Pool RMT_COPY_DR, Files Backed Up: 1, Bytes Backed Up: 15,966,520,559, Unreadable Files: 0, Unreadable Bytes: 0. Current Physical File (bytes): 95,210,102,579 Current input volume: F00222. Current output volume: F10339. It states that the current physical file is 95,210,102,579 bytes.. Does this correlate to a physical client file or is this a TSM server aggregate file of many client files? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: Expiration performance (my stats)
58968000 The average seems to be in the region of 5000 +, so from that point of view it seems excellent - but the expiration sucks according to the script. ACTIVITY DateObjects Examined Up/Hr -- -- - EXPIRATION 2004-08-14856800 EXPIRATION 2004-08-14867600 EXPIRATION 2004-08-15864000 EXPIRATION 2004-08-17770400 EXPIRATION 2004-08-18669600 EXPIRATION 2004-08-19846000 EXPIRATION 2004-08-20734400 So, yes, it seems that Ymmv, but is there anyone out there getting good performance from expiration? If there are people out there, don't you want to share your environment with us - might be able to collectively cast some light on the lower expiration figures. For the record, my environment is as follows: AIX 5.2 TSM 5.2.2.5 DB size 105Gig - 93% utilized - 13 Lun's (One over the recommendation). Disk subsys - FastT900 File system - RLV Tape technology: 3584 with Lto-2 drives. P650 (4 Processors and 4Gig Ram) Regards ChristoH === Yes, interesting stats. On all my TSM servers, they get above 5M pages for the DB backup, but none of them are above 3.8M objects on the expire inventory. Some in the 2M, others only in the .5 M range. These random thoughts pointed at the group, not necessarily Joe. Since my db backups (sequential reads) go well, but the expire inventory (random reads and writes) are slow, might that point to DB fragmentation? Improper tuning of TSM buffers? Overcommittal of the fast-write disk cache? Bad karma? One would think that the more files deleted during the expire inventory, the longer it will take for the expire inventory to progress? No? I can run 2 expire inventories in a row and the second one goes much much quicker because there are very few changes to the DB to be made. It seems like the performance on the number of objects examined is really one of those your mileage may vary kind of stats. Perhaps I'm not getting the performance I should out of the expiration... Ben __ Important Notice: Important restrictions, qualifications and disclaimers (the Disclaimer) apply to this email. To read this click on the following address: http://www.absa.co.za/ABSA/EMail_Disclaimer The Disclaimer forms part of the content of this email in terms of section 11 of the Electronic Communications and Transactions Act, 25 of 2002. If you are unable to access the Disclaimer, send a blank e-mail to [EMAIL PROTECTED] and we will send you a copy of the Disclaimer.
Re: Stats
This should also show you the amount of active data on a node in MB: select sum(capacity*pct_util/100) from filespaces where node_name='' -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 19:36 To: [EMAIL PROTECTED] Subject: Re: Stats Thanks, Good one, Bill Rosette Data Center/IS/Papa Johns International WWJD Richard Sims [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: Re: Stats Manager [EMAIL PROTECTED] .EDU 07/21/2003 01:39 PM Please respond to ADSM: Dist Stor Manager I am looking for a way to figure a total Gb of active files on a particular node. ... Hello, Bill - This question came up a few weeks ago, and the excellent suggestion was the expedient: Active files, number and bytes Do 'EXPort Node NodeName FILESpace=FileSpaceName FILEData=BACKUPActive Preview=Yes' Message ANR0986I will report the number of files and bytes. (This is immortalized in http://people.bu.edu/rbs/ADSM.QuickFacts) Richard Sims, BU Any e-mail message from the European Central Bank (ECB) is sent in good faith but shall neither be binding nor construed as constituting a commitment by the ECB except where provided for in a written agreement. This e-mail is intended only for the use of the recipient(s) named above. Any unauthorised disclosure, use or dissemination, either in whole or in part, is prohibited. If you have received this e-mail in error, please notify the sender immediately via e-mail and delete this e-mail from your system.
Re: Stats
I am looking for a way to figure a total Gb of active files on a particular node. ... Hello, Bill - This question came up a few weeks ago, and the excellent suggestion was the expedient: Active files, number and bytes Do 'EXPort Node NodeName FILESpace=FileSpaceName FILEData=BACKUPActive Preview=Yes' Message ANR0986I will report the number of files and bytes. (This is immortalized in http://people.bu.edu/rbs/ADSM.QuickFacts) Richard Sims, BU
AS400 performance stats
Hi, Does anyone who has experience with AS400 TSM clients that are connected through a Gb ethernet link to a RS6000 TSM server want to share with me his backup performance statistics. At the moment we are still in a test phase but we have only managed to get 6 GB an hour. The problem is that the new systems will be larger then 650GB each so if we want to use TSM as a backup solution we will have to reach much higher speeds. met vriendelijke groeten, regards et salutations, Finn Leijnse ITDSES/31 - Central Data Storage Management Shell Information Tech. International Postbus 1027, 2265 BD Leidschendam mail: [EMAIL PROTECTED]
Auditocc stats
To All, I run a monthly script which gathers utilization information. When it ran this month i noticed that the number from the auditocc.backup_mb query were lower than expected. Upon investigation I found something strange, when I run a q auditocc vs. a select * from auditocc the number are different for a given storage pool. Any thoughts.. TSM 4.2.1.9 on AIX 4.3.3 ML8 select * from auditocc NODE_NAME BACKUP_MB BACKUP_COPY_MBARCHIVE_MB ARCHIVE_COPY_MBSPACEMG_MB SPACEMG_COPY_MB TOTAL_MB -- --- -- --- --- --- --- --- BWHNW03 645081 645052 0 0 0 0 1290133 BWHNW03_PERM 1336680 1336690343329 343329 0 0 3360028 q auditocc Node Name Backup Archive Space-Managed Total Storage Storage Storage Used Storage Used (MB) Used (MB) (MB) Used (MB) --- - - - - BWHNW03_PERM2,673,370 686,658 0 3,360,028 BWHNW03 1,290,133 0 0 1,290,133 TIA, Tim NAFTA IS Technical Operations (203) 812-3469 [EMAIL PROTECTED]
Re: Auditocc stats
The number from the select is showing primary storage and copy, the q auditocc lists total - add backup_mb and backup_copy_mb to get backup storage used in the q auditocc. -Original Message- From: Tim Melly [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:44 PM To: [EMAIL PROTECTED] Subject: Auditocc stats To All, I run a monthly script which gathers utilization information. When it ran this month i noticed that the number from the auditocc.backup_mb query were lower than expected. Upon investigation I found something strange, when I run a q auditocc vs. a select * from auditocc the number are different for a given storage pool. Any thoughts.. TSM 4.2.1.9 on AIX 4.3.3 ML8 select * from auditocc NODE_NAME BACKUP_MB BACKUP_COPY_MBARCHIVE_MB ARCHIVE_COPY_MBSPACEMG_MB SPACEMG_COPY_MB TOTAL_MB -- --- -- --- --- --- --- --- BWHNW03 645081 645052 0 0 0 0 1290133 BWHNW03_PERM 1336680 1336690343329 343329 0 0 3360028 q auditocc Node Name Backup Archive Space-Managed Total Storage Storage Storage Used Storage Used (MB) Used (MB) (MB) Used (MB) --- - - - - BWHNW03_PERM2,673,370 686,658 0 3,360,028 BWHNW03 1,290,133 0 0 1,290,133 TIA, Tim NAFTA IS Technical Operations (203) 812-3469 [EMAIL PROTECTED]
Re: Anyone have any SQL ideas for these stats?
Hi, Paul. Did you ever get a chance to look at Servergraph/TSM, after I sent you the press reelease last week? The slideshow only takes 10-15 minutes, if you just want the 5,000-foot view. Hope to hear from you. Thanks. - Mr. Lindsay Morris Principal Applied System Design [EMAIL PROTECTED] Office: 859-253-8000 Fax: 425-988-8478
Re: Anyone have any SQL ideas for these stats?
From: Matthew Glanville This might get you some useful information from TSM about tape mounting activity: tsm select * from summary where activity='TAPE MOUNT' START_TIME: 2001-03-26 00:01:00.00 END_TIME: 2001-03-26 00:12:30.00 ACTIVITY: TAPE MOUNT NUMBER: 0 ENTITY: COMMMETH: ADDRESS: SCHEDULE_NAME: EXAMINED: 0 AFFECTED: 0 FAILED: 0 BYTES: 0 IDLE: 0 MEDIAW: 0 PROCESSES: 0 SUCCESSFUL: YES VOLUME_NAME: 065643 DRIVE_NAME: DRIVE33 (/dev/rmt/33st) LIBRARY_NAME: LIB22 LAST_USE: Data Richard Sims [EMAIL PROTECTED] on 04/25/2001 09:32:50 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Matthew Glanville/437358/EKC) Subject: Re: Anyone have any SQL ideas for these stats? I need to see if I can determine: - # of mounts per individual tape drive - drive useage - would like to be able to compare when all drives are in use, for how long, etc, Harold - I'm not aware that TSM tracks such information; but advanced tape drives like the 3590 themselves record such information, internally... You can use the 3590 front panel to get mount information from the Show Statistics menu. Refer to the 3590 Operator Guide. You can typically ask various types of tape drives for the counters that they maintain. For the 3590 you can get statistics such as Drive Lifetime Mounts, Drive Lifetime Megabytes Written or Read, from the Log Page X'3D' (Subsystem Statistics), via discrete programming or with the 'tapeutil' command, like: tapeutil Enter Selection: 1 Enter the device special file name (Example: /dev/rmt0): /dev/rmt3 Select mode (1=Read/Write, 2=Read Only, 3=Write Only, 4=Append): 2 Opening device... Enter Selection for /dev/rmt3: 9 Enter page code in hex: 3d Enter parameter pointer in hex or enter for all parameters: 40 Enter length (including header) or enter for entire parameter: Issuing log sense for page 0x3D... Log Sense Page 0x3D, Page Length 28, Data, Length 28 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF - 3D00 0018 0040 6004 066A 0041 6004 [=@`j.A`.] 0010 - 0015 63E3 0042 6004 0011 F9D6[..cc.B`...yV] Refer to the 3590 Hardware Reference manual for codes and byte positions. Here, we requested 40, being Drive Lifetime Mounts. That returned the 32-bit value 066A, or 1642 decimal. The parameter 41 Drive Lifetime Megabytes Written happens to be returned as well: 001563E3, or 1,401,827 MB. Richard Sims, BU
Re: Anyone have any SQL ideas for these stats?
Paul, I recently needed this same info, so I wrote a Rexx program to take the results of a TSM SQL command and use the data to graphically plot tape drive utilization for all drives across a given span of time. Although we use Aix for our TSM server, the Rexx program runs on our OS/390 mainframe. If you are interested, reply direct to me and I can send you the jcl, rexx code, etc. The program is 200 lines, but makes heavy use of dynamic, multi-dimensional arrays, so you would need to be fairly proficient in Rexx to do much de-coding. Steve Schaub Haworth, Inc email: [EMAIL PROTECTED] [EMAIL PROTECTED] 04/25 12:51 PM Paul, I tried: dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.mount q act begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8337 dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.dismount q act begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8468 I then opened both files with Excel, set it to delimited by comma and space, then deleted all the columns I didn't need, copied one file and pasted on the end of the other, and sorted by drive then date/time, and came up with the following (just an exerpt, of course). This took about 5 minutes. 4/24/01 15:30 102200 mounted rmt1 4/24/01 15:37 102200 dismountedrmt1 4/24/01 20:55 100702 mounted rmt1 4/24/01 21:17 100702 dismountedrmt1 4/24/01 15:28 102074 mounted rmt10 4/24/01 15:30 102074 dismountedrmt10 4/24/01 15:37 101222 mounted rmt11 4/24/01 15:38 101222 dismountedrmt11 If you need to automate it, this may be doable with SQL and it'd definitely be doable with AWK, and PERL. Maybe SED. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: paul baines [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 8:27 AM To: [EMAIL PROTECTED] Subject: Re: Anyone have any SQL ideas for these stats? This is cool. But only works in 4.1.x (4.1.2.0) and not in 3.7.3.0 for me. And most of my servers are still 3.7. This might get you some useful information from TSM about tape mounting activity: tsm select * from summary where activity='TAPE MOUNT' START_TIME: 2001-03-26 00:01:00.00 END_TIME: 2001-03-26 00:12:30.00 ACTIVITY: TAPE MOUNT NUMBER: 0 ENTITY: COMMMETH: ADDRESS: SCHEDULE_NAME: EXAMINED: 0 AFFECTED: 0 FAILED: 0 BYTES: 0 IDLE: 0 MEDIAW: 0 PROCESSES: 0 SUCCESSFUL: YES VOLUME_NAME: 065643 DRIVE_NAME: DRIVE33 (/dev/rmt/33st) LIBRARY_NAME: LIB22 LAST_USE: Data Richard Sims [EMAIL PROTECTED] on 04/25/2001 09:32:50 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Matthew Glanville/437358/EKC) Subject: Re: Anyone have any SQL ideas for these stats? I need to see if I can determine: - # of mounts per individual tape drive - drive useage - would like to be able to compare when all drives are in use, for how long, etc, Harold - I'm not aware that TSM tracks such information; but advanced tape drives like the 3590 themselves record such information, internally... You can use the 3590 front panel to get mount information from the Show Statistics menu. Refer to the 3590 Operator Guide. You can typically ask various types of tape drives for the counters that they maintain. For the 3590 you can get statistics such as Drive Lifetime Mounts, Drive Lifetime Megabytes Written or Read, from the Log Page X'3D' (Subsystem Statistics), via discrete programming or with the 'tapeutil' command, like: tapeutil Enter Selection: 1 Enter the device special file name (Example: /dev/rmt0): /dev/rmt3 Select mode (1=Read/Write, 2=Read Only, 3=Write Only, 4=Append): 2 Opening device... Enter Selection for /dev/rmt3: 9 Enter page code in hex: 3d Enter parameter pointer in hex or enter for all parameters: 40 Enter length (including header) or enter for entire parameter: Issuing log sense for page 0x3D... Log Sense Page 0x3D, Page Length 28, Data, Length 28 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF - 3D00 0018 0040 6004 066A 0041 6004 [=@`j.A`.] 0010 - 0015 63E3 0042 6004 0011 F9D6[..cc.B`...yV] Refer to the 3590 Hardware Reference manual for codes and byte positions. Here, we requested 40, being Drive Lifetime Mounts. That returned the 32-bit value 066A, or 1642 decimal. The parameter 41 Drive Lifetime Megabytes Written happens to be returned as well: 001563E3, or 1,401,827 MB. Richard Sims, BU _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Anyone have any SQL ideas for these stats?
Hi y'all I need to see if I can determine: - # of mounts per individual tape drive - drive useage - would like to be able to compare when all drives are in use, for how long, etc, thanks in advance... Harold Clitheroe Canadian Pacific Railway
TDP For Oracle Sun--No stats in the server log.
Hello, THe TDP oracle client has a nice log about what it sent to the server. On the server the only messages I get are about the TDP client connecting, nothing else I am used to seeing with backup clients like the backup stats. From the server side how can tell, except for an audit, how much data got transfered?? Mark Brown McGill University [EMAIL PROTECTED]