Re: TSM Operational Reporting - some answers... summary table
Hi, Ref: Date:Fri, 20 Feb 2004 09:27:04 - From: Warren, Matthew (Retail) [EMAIL PROTECTED] Does the Operational reporting tool actually work properly now? As far as I was aware it was 'broken' in that is used the TSM summary table to gather data, and this table is currently unreliable for client backups? TSMOR includes a set of canned sections in the default report. Some of them use the TSM summary table to obtain information. There have been problems with the summary table in older versions of the server. The officially supported versions of the TSM server (5.1.8+ for 5.1 and 5.2.2+ for 5.2) should not have these problems. If any are found then a PMR can be opened to get them fixed. By default TSMOR generates a file that corresponds with each report which ends with .in. You can look at this file to see the set of commands that TSMOR is sending to the server (to see if the summary table is involved for example). The corresponding .out file shows the results that the server returns. Also, all sections are all optional in TSMOR and you can easily add new sections to obtain information from any table and most queries. Regards, Mike Collins Tivoli Storage Product Architecture [EMAIL PROTECTED]
Re: TSM Operational Reporting - some answers... - Extensions
Hi, ref: Date:Fri, 20 Feb 2004 07:39:42 -0500 From:Rajesh Oak [EMAIL PROTECTED] The Operational Reporting seems to be working fine at my site. The only flaw is in the report for the Exchange Backup. Since we execute a batch file which kicks off the Exchange backup, the client summary shows successful everytime the batch file is executed successfully. After that it has no idea if the actual backup fails. Wierd thing is for SQL backups we do the same thing but it looks for errors in the actual SQL backups and reports it in the client schedule summary. Hope this is fixed ASAP because now I have to run a script which looks for the Exchange backup seperately. The administrative schedule section will display the actual return code but the client section will map return codes according to some rules described in the TSMOR 5.2.2. readme file (tsmrept_readme.txt) You can search for Result values for the Client Schedule section Currently the best way to display information on DP clients in TSMOR is to add one or more extension sections. You can do this by clicking the Add button in a report's property sheet and adding a section name and select statement or query. Here are some example extensions for Exchange. Extension: Exchange - Schedules Failed select - substr(char(actlog.date_time), 1, 16) as Date/Time, - actlog.message - from actlog - where actlog.date_time between '%s' and '%s' and - actlog.msgno=2579 and - (message like '%%_EXC%%') Extension: Exchange - Schedules Missed select - substr(char(actlog.date_time), 1, 16) as Date/Time, - actlog.message - from actlog - where actlog.date_time between '%s' and '%s' and - actlog.msgno=2578 and - (message like '%%_EXC%%') Extension: Exchange - Filespaces not Backed up in last 24 Hours select - filespaces.node_name as Node Name,- filespaces.filespace_name as Filespace Name,- filespaces.filespace_type as Filespace Type,- substr(char(filespaces.backup_start), 1, 16) as Backup Start,- substr(char(filespaces.backup_end), 1, 16) as Backup End - from filespaces - where filespaces.backup_end not between '%s' and '%s' and - filespaces.node_name like '%%_EXC%%' Extension: Exchange - Activity Summary select - node_name as Node Name, - platform_name as Platform, - activity as Activity,- number as Session,- substr(char(start_time),1,16) as Started,- substr(char(end_time),1,16) as Ended,- sum(bytes) as Bytes Transferred, - successful as Successful - from summary,nodes - where end_time between '%s' and '%s' and - platform_name = 'TDP MSExchg' - group by node_name, platform_name, activity,- number,bytes,start_time,end_time,successful - order by Started desc Some of these samples are set up to expect that DP for Exchange node names end in _exc. For example if you had exchange nodes named serverx_exc, servery_exc, and serverz_exc they would appear in the results. This type of filtering can be removed or updated to match any environment. For example you can look for other messages such as ANE4993E in the actlog as Bruce mentioned. For more information on the role of the % character in the select statements see the TSMOR 5.2.2 readme file and search for How to use variables in select statements TSMOR has a SQL select statement builder to help build select statements. For example, on the extension editor dialog you can click the Advanced button to get to it. Also some sections take longer to process than others and in part it depends on the complexity of the query and the load on the server. TSMOR provides a timing summary section which provides detailed per section timing information so that you can determine where time is spent producing a report. This helps determine if and where queries need to be optimized. Regards, Mike Collins Tivoli Storage Product Architecture [EMAIL PROTECTED]
Re: TSM Operational Reporting - some answers...
Does the Operational reporting tool actually work properly now? As far as I was aware it was 'broken' in that is used the TSM summary table to gather data, and this table is currently unreliable for client backups? -Original Message- From: David McClelland [EMAIL PROTECTED]@EME Sent: Thursday, February 19, 2004 6:46 PM To: [EMAIL PROTECTED] Subject: TSM Operational Reporting - some answers... Hi Lawrence, TSM Operational Reporting is, in itself, self-contained. No DB2/Oracle/obscure-COTS/Tivoli Framework required, all you need is a TSM Server somewhere to point it at. It's a doddle to install, no really, it is. From double clicking the install file to getting some genuinely useful reports in less than 15 minutes. In terms of limitations, I think I read somewhere that as of the GA release, you cannot actually install TSM Operational Reporting on a TSM Server - it has to be a separate box somewhere, and it has to be installed in a Windows 2000 or above server (i.e. not NT4). I have it running on a very low powered workstation at the moment, and it does its job just fine. What you refer to below is an 'extra', in that if you *want* you can output logs to a logfile, and have a Tivoli Logfile Adapter scrape the log and forward on any pertinent events (such as tape drives going offline, client schedules missed etc) onto a TEC console should you so wish. Certainly not a prerequisite. As for location, you can download the latest GA version (v. 5.2.2.0) from : ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/server/v5r2/WIN/LATEST/ where you'll see the, okay, slightly non-immediately-obviously-named file TSMCON5220_WIN.EXE which is about 10MB and is all you'll need. This file is also available on the Windows TSM Server CD, I just don't remember where or how off the top of my head. Hope that helps people - seems to have been a little confusion over the product in the past. I have it reporting on 8 TSM servers at the moment, one of it's main uses is to run some custom SQL reports and dump these out to a web server so that our TSM backup 'customers' can see for themselves that their precious servers did (or didn't...) backup up overnight. This product is *so* much better than TDS for SMA, which was, for me, a nightmare in so many senses. David McClelland Tivoli Certified Consultant Global Management Systems Reuters 85 Fleet Street London EC4P 4AJ E-mail [EMAIL PROTECTED] -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 14:02 To: [EMAIL PROTECTED] Subject: Re: TSM OPERATIONAL REPORTING You may not want to bother. Looking at the docs under the latest directory, it appears as though the TSM operational reporting tool is not self-contained. As in the previous tools offered, it requires another non-TSM Tivoli product to work. I may be wrong. Can someone clarify? Installation and configuration The following section goes through installation and configuration of the logfile adapter and configuration of TEC. To configure TEC alerting, the Tivoli Logfile adapter for Windows 2000 must be installed on the Windows Server where Operational Reporting is installed. This is not supplied with TSM and can be found on the TEC installation CDs. This should be installed as per the Tivoli installation instructions for a Tivoli managed host (if a Tivoli end-point is installed) or a non-TME managed host. The instructions included here assume that the Windows Server running Operational Reporting does not have a Tivoli End-Point installed. The sample files supplied are for the TEC 3.8 version of the logfile adapter and assume a TEC 3.8 console. [EMAIL PROTECTED] 2/19/2004 8:51:11 AM thanks, i know that but someone has said that it comes with TSM 5.2 ... where ? on CD's ? g. - Original Message
Re: TSM Operational Reporting - some answers...
The Operational Reporting seems to be working fine at my site. The only flaw is in the report for the Exchange Backup. Since we execute a batch file which kicks off the Exchange backup, the client summary shows successful everytime the batch file is executed successfully. After that it has no idea if the actual backup fails. Wierd thing is for SQL backups we do the same thing but it looks for errors in the actual SQL backups and reports it in the client schedule summary. Hope this is fixed ASAP because now I have to run a script which looks for the Exchange backup seperately. Rajesh Oak Blue Cross Blue Shield of Michigan -- - Original Message - DATE: Fri, 20 Feb 2004 09:27:04 From: Warren, Matthew (Retail) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Does the Operational reporting tool actually work properly now? As far as I was aware it was 'broken' in that is used the TSM summary table to gather data, and this table is currently unreliable for client backups? -Original Message- From: David McClelland [EMAIL PROTECTED]@EME Sent: Thursday, February 19, 2004 6:46 PM To: [EMAIL PROTECTED] Subject: TSM Operational Reporting - some answers... Hi Lawrence, TSM Operational Reporting is, in itself, self-contained. No DB2/Oracle/obscure-COTS/Tivoli Framework required, all you need is a TSM Server somewhere to point it at. It's a doddle to install, no really, it is. From double clicking the install file to getting some genuinely useful reports in less than 15 minutes. In terms of limitations, I think I read somewhere that as of the GA release, you cannot actually install TSM Operational Reporting on a TSM Server - it has to be a separate box somewhere, and it has to be installed in a Windows 2000 or above server (i.e. not NT4). I have it running on a very low powered workstation at the moment, and it does its job just fine. What you refer to below is an 'extra', in that if you *want* you can output logs to a logfile, and have a Tivoli Logfile Adapter scrape the log and forward on any pertinent events (such as tape drives going offline, client schedules missed etc) onto a TEC console should you so wish. Certainly not a prerequisite. As for location, you can download the latest GA version (v. 5.2.2.0) from : ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/server/v5r2/WIN/LATEST/ where you'll see the, okay, slightly non-immediately-obviously-named file TSMCON5220_WIN.EXE which is about 10MB and is all you'll need. This file is also available on the Windows TSM Server CD, I just don't remember where or how off the top of my head. Hope that helps people - seems to have been a little confusion over the product in the past. I have it reporting on 8 TSM servers at the moment, one of it's main uses is to run some custom SQL reports and dump these out to a web server so that our TSM backup 'customers' can see for themselves that their precious servers did (or didn't...) backup up overnight. This product is *so* much better than TDS for SMA, which was, for me, a nightmare in so many senses. David McClelland Tivoli Certified Consultant Global Management Systems Reuters 85 Fleet Street London EC4P 4AJ E-mail [EMAIL PROTECTED] -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 14:02 To: [EMAIL PROTECTED] Subject: Re: TSM OPERATIONAL REPORTING You may not want to bother. Looking at the docs under the latest directory, it appears as though the TSM operational reporting tool is not self-contained. As in the previous tools offered, it requires another non-TSM Tivoli product to work. I may be wrong. Can someone clarify? Installation and configuration The following section goes through installation and configuration of the logfile adapter and configuration of TEC. To configure TEC alerting, the Tivoli Logfile adapter for Windows 2000 must be installed on the Windows Server where Operational Reporting is installed. This is not supplied with TSM and can be found on the TEC
Re: TSM Operational Reporting - some answers...
Hi Rajesh, Maybe it's because TDP Exchange doesn't give the information to TSM. We have studied this for our own needs and finally abandoned. Syntax used by this TDP is always changing and sometimes incoherent. For SQL, the problem is different. It's an IBM product. In the same way, backint doesn't speak no longer to TSM (since a recent version). If somebody has informations about these things ... Best regards Christian Bagard [EMAIL PROTECTED] SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France From: Rajesh Oak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 20, 2004 1:39 PM Subject: Re: TSM Operational Reporting - some answers... The Operational Reporting seems to be working fine at my site. The only flaw is in the report for the Exchange Backup. Since we execute a batch file which kicks off the Exchange backup, the client summary shows successful everytime the batch file is executed successfully. After that it has no idea if the actual backup fails. Wierd thing is for SQL backups we do the same thing but it looks for errors in the actual SQL backups and reports it in the client schedule summary. Hope this is fixed ASAP because now I have to run a script which looks for the Exchange backup seperately. Rajesh Oak Blue Cross Blue Shield of Michigan --
TSM Operational Reporting - some answers...
Hi Lawrence, TSM Operational Reporting is, in itself, self-contained. No DB2/Oracle/obscure-COTS/Tivoli Framework required, all you need is a TSM Server somewhere to point it at. It's a doddle to install, no really, it is. From double clicking the install file to getting some genuinely useful reports in less than 15 minutes. In terms of limitations, I think I read somewhere that as of the GA release, you cannot actually install TSM Operational Reporting on a TSM Server - it has to be a separate box somewhere, and it has to be installed in a Windows 2000 or above server (i.e. not NT4). I have it running on a very low powered workstation at the moment, and it does its job just fine. What you refer to below is an 'extra', in that if you *want* you can output logs to a logfile, and have a Tivoli Logfile Adapter scrape the log and forward on any pertinent events (such as tape drives going offline, client schedules missed etc) onto a TEC console should you so wish. Certainly not a prerequisite. As for location, you can download the latest GA version (v. 5.2.2.0) from : ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/server/v5r2/WIN/LATEST/ where you'll see the, okay, slightly non-immediately-obviously-named file TSMCON5220_WIN.EXE which is about 10MB and is all you'll need. This file is also available on the Windows TSM Server CD, I just don't remember where or how off the top of my head. Hope that helps people - seems to have been a little confusion over the product in the past. I have it reporting on 8 TSM servers at the moment, one of it's main uses is to run some custom SQL reports and dump these out to a web server so that our TSM backup 'customers' can see for themselves that their precious servers did (or didn't...) backup up overnight. This product is *so* much better than TDS for SMA, which was, for me, a nightmare in so many senses. David McClelland Tivoli Certified Consultant Global Management Systems Reuters 85 Fleet Street London EC4P 4AJ E-mail [EMAIL PROTECTED] -Original Message- From: Lawrence Clark [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 14:02 To: [EMAIL PROTECTED] Subject: Re: TSM OPERATIONAL REPORTING You may not want to bother. Looking at the docs under the latest directory, it appears as though the TSM operational reporting tool is not self-contained. As in the previous tools offered, it requires another non-TSM Tivoli product to work. I may be wrong. Can someone clarify? Installation and configuration The following section goes through installation and configuration of the logfile adapter and configuration of TEC. To configure TEC alerting, the Tivoli Logfile adapter for Windows 2000 must be installed on the Windows Server where Operational Reporting is installed. This is not supplied with TSM and can be found on the TEC installation CDs. This should be installed as per the Tivoli installation instructions for a Tivoli managed host (if a Tivoli end-point is installed) or a non-TME managed host. The instructions included here assume that the Windows Server running Operational Reporting does not have a Tivoli End-Point installed. The sample files supplied are for the TEC 3.8 version of the logfile adapter and assume a TEC 3.8 console. [EMAIL PROTECTED] 2/19/2004 8:51:11 AM thanks, i know that but someone has said that it comes with TSM 5.2 ... where ? on CD's ? g. - Original Message - From: rh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 2:41 PM Subject: Re: TSM OPERATIONAL REPORTING ftp://ftp.software.ibm.com/storage/tivoli-storage-management/techprev/ts mopreport/latest/ --- goran [EMAIL PROTECTED] wrote: hi to all ... if someone can explain this to me, operational reporting comes with tsm 5.2 ? what means that comes with, where can i find it ? thanks __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools - Visit our Internet site at http://www.reuters.com Get closer to the financial markets with Reuters Messaging - for more information and to register, visit http://www.reuters.com/messaging Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
