Tivoli Decision Support for Storage Management Analysis
Anyone have experience using Tivoli Decision Support for Storage Management Analysis? Thanks, Bill Sherrill
Re: Tivoli Decision Support for Storage Management Analysis
Hi Bill! I have! Well... sort of... I tried configuring it some time ago. After a day or two I gave up. This is some complex piece of software! I call this implementation software piling. You have to install several components (the rather expensive Oracle client is one of them) on the client and you will also have to create an Oracle data repository somewhere in your environment. My advice: don't bother. Just wait for the release of TSM Operation Reporting. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: William Sherrill [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 15:57 To: [EMAIL PROTECTED] Subject: Tivoli Decision Support for Storage Management Analysis Anyone have experience using Tivoli Decision Support for Storage Management Analysis? Thanks, Bill Sherrill ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Tivoli Decision Support for Storage Management Analysis
I would say it is not correct statement. TDS is product for creating OLAP reports over management information collected by diverse Tivoli management products while TSM Operational Reporting is for only for TSM daily operational reports (Oh, how I hate to repeat the same words twice). TDS for Storage management Analysis is the TSM plug-in for TDS (TDS was base OLAP and each Tivoli product was carrying its plug-in). More than year ago the *paid* TDS product was replaced by Tivoli Enterprise Data Warehouse which is freely included in all Tivoli products enabled for it (Tivoli Enterprise; see more info on tme10 list). In the light of the war between IBM and Oracle the database behind TEDW obviously is DB2 with its OLAP Data Warehouse. Exempt from ITSM v5.2 Announcement (EMEA Letter ZP03-0215): IBM TIVOLI STORAGE MANAGEMENT WAREHOUSE ENABLEMENT PACK (available September 26, 2003) IBM Tivoli Storage Manager integrates with IBM Tivoli Data Warehouse V1.2, which provides a centralized database to store historical data from Tivoli applications. This integration can be leveraged via the IBM Tivoli Storage Management Warehouse Enablement Pack (warehouse pack), a component of IBM Tivoli Storage Manager. Bottom line: if TDS is not already widely deployed in your enterprise, forget about it. Use TEDW, it is really better and much easier to install (though is not a piece of cake). Zlatko Krastev IT Consultant Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 02.09.2003 17:20 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:Re: Tivoli Decision Support for Storage Management Analysis Hi Bill! I have! Well... sort of... I tried configuring it some time ago. After a day or two I gave up. This is some complex piece of software! I call this implementation software piling. You have to install several components (the rather expensive Oracle client is one of them) on the client and you will also have to create an Oracle data repository somewhere in your environment. My advice: don't bother. Just wait for the release of TSM Operation Reporting. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: William Sherrill [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 15:57 To: [EMAIL PROTECTED] Subject: Tivoli Decision Support for Storage Management Analysis Anyone have experience using Tivoli Decision Support for Storage Management Analysis? Thanks, Bill Sherrill ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Tivoli Decision Support
We have started to collect data from two systems. One has a 52GB db that is 85.3% full and the other has a 52GB db that is 45.3% full. We had a problem at the first of the year where our timesource was wrong and both systems got set to the year 2021. We did clean up the summary table but found that the actlog still has some year 2021 entries left in it. So that is causing a problem and two of the cubes still don't have current data in them. While I don't run the actual loader job or build the cubes I know that we have seen erratic run times. Right know I'm attributing it the records with the 2021 timestamp although I don't have any proof of that. On the list of things to do this week is to clean up those records. For the summary table there were only six records and with level2's help it was pretty simple to edit the database using some commands they walked me through. For the actlog there are a couple of hundred and it will be more of a pain. Most of the records in the actlog are messages complaining about the date. Even though we didn't accept the data change by the time I got in there were quite of few of these messages logged: 08/18/2021 00:01:21 ANR0110E An unexpected system date has been detected; the server is disabled. Use the ACCEPT DATE command to establish the current date as valid. The loader creates the following select statement and never finds any current data: 04/29/2002 06:27:56 ANR2017I Administrator ISMBATCH issued command: DEFINE CURSOR C34b480c SQL=SELECT DATE_TIME, MSGNO, MESSAGE, SEVERITY from ACTLOG where ORIGINATOR = 'SERVER' and DATE_TIME= '2021-08-18 06:02:43' and (SEVERITY = 'E' OR SEVERITY = 'S' OR SEVERITY = 'D' OR SEVERITY = 'W') Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Hart, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 5:52 PM To: [EMAIL PROTECTED] Subject: Tivoli Decision Support Is anyone running TDS for TSM that has a 50GB TSM DB? Regards, Charles Hart Medtronic Storage Team
Tivoli Decision Support
Is anyone running TDS for TSM that has a 50GB TSM DB? Regards, Charles Hart Medtronic Storage Team
Re: Tivoli Decision Support and TSM server
Christo, Can you teel what sql query is running? I know some queries are really terrible, especially 'select * from volumeusage. Is there some options in the TDSSMA to limit what queries are done? I run a large tsm erver on OS/390 also. I can do a select of all the occupancy data in 9 minutes elapsed time. I can't compare the performance with w2k or aix because I don't run those servers, but I am happy with the perfromance on os/390. But I agree with you about TDSSMA - if it drives the server crazy it isn't a good product. At 12:53 PM 1/23/2002 +0200, you wrote: Hi, Are there any of you guys/gals that are running TDS for SMA? If you are - what kind of TSM server are you running: Platform and size of database being the ones I'll be interested in. We are busy evaluating the TDSSMA modules and are experiencing bad performance on our biggest TSM server - for those of you that are familiar with the product - when the TDS Loader runs it consumes about 24% of our OS/390 CPU for 28hours - the load is still not finished. This makes the whole TDS product useless to us. It is fine for our smaller TSM environments but it does not help getting different products for the smaller and bigger environments. To me it seems like the usefullness of this product or any other product that will be running SQL queries into your TSM db is severly impacted by the size of your TSM environment - coming back to the scalability of TSM's proprietary black box DB! Have any of you noticed this or do we need to look at other things. My opinion of TSM on OS/390 is that it performs worse on OS/390 than AIX or I'll even be as bold to say Win2K ;-) Thanks for any input. Regards Christo Heuer -- Bill Colwell C. S. Draper Lab Cambridge Ma.
Re: Tivoli Decision Support and TSM server
Hi Bill, What would you call a large Tsm server on OS/390? Can you perhaps give me some detail as to Tsm db size and what physical box you are running your TSM environment on? To answer your question about running only selective queries - yes the product can do that - when you run the loader you can specify what areas you want to query - but the problem is that the TDSSMA product builds it's own database in which the results of the loader queries are stored - now here comes the fun part - it builds it's own relationship in this new database about the queries that was done on your TSM server. (This enables the product to build what they call 3 dimensional views of your TSM data). It is not documented what queries the loader combines to create this 3d view - so you don't know which of the resource intensive queries could be run on a less frequent basis. I'm currently waiting on our local IBM support to get me more info as to which parts of the loader queries could be run seperate from the rest. Still does not look very good to me. Thanks for the reply. Regards Christo == Christo, Can you teel what sql query is running? I know some queries are really terrible, especially 'select * from volumeusage. Is there some options in the TDSSMA to limit what queries are done? I run a large tsm erver on OS/390 also. I can do a select of all the occupancy data in 9 minutes elapsed time. I can't compare the performance with w2k or aix because I don't run those servers, but I am happy with the perfromance on os/390. But I agree with you about TDSSMA - if it drives the server crazy it isn't a good product. At 12:53 PM 1/23/2002 +0200, you wrote: Hi, Are there any of you guys/gals that are running TDS for SMA? If you are - what kind of TSM server are you running: Platform and size of database being the ones I'll be interested in. We are busy evaluating the TDSSMA modules and are experiencing bad performance on our biggest TSM server - for those of you that are familiar with the product - when the TDS Loader runs it consumes about 24% of our OS/390 CPU for 28hours - the load is still not finished. This makes the whole TDS product useless to us. It is fine for our smaller TSM environments but it does not help getting different products for the smaller and bigger environments. To me it seems like the usefullness of this product or any other product that will be running SQL queries into your TSM db is severly impacted by the size of your TSM environment - coming back to the scalability of TSM's proprietary black box DB! Have any of you noticed this or do we need to look at other things. My opinion of TSM on OS/390 is that it performs worse on OS/390 than AIX or I'll even be as bold to say Win2K ;-) Thanks for any input. Regards Christo Heuer -- Bill Colwell C. S. Draper Lab Cambridge Ma. __ The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Absa is neither liable for the proper, complete transmission of the information contained in this communication, any delay in its receipt or that the mail is virus-free.
Re: Tivoli Decision Support
On Mon, 19 Nov 2001 12:39:43 -0800, it was written: Anyone using Tivoli Decision Support and how do you like it? *I* like it. The installation is non-trivial (have your dba handy), but once set up properly, it's a joy to get nicely formatted reports that you can upload to your web server and have available first thing in the morning. Warning warning. RTFM. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Tivoli Decision Support
Servergraph/TSM (www.servergraph.com) goes TDS one better, I think, because it not only REPORTS things, it can also AUTOMATE a lot of chores for you. And it's all web based anyway, so there's no uploading needed. I'd love to chat with you offline about pros and cons... call or write, Mark. Thanks. - Mr. Lindsay Morris Principal Applied System Design [EMAIL PROTECTED] Office: 859-253-8000 Fax: 425-988-8478 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Stapleton Sent: Wednesday, November 21, 2001 1:37 PM To: [EMAIL PROTECTED] Subject: Re: Tivoli Decision Support On Mon, 19 Nov 2001 12:39:43 -0800, it was written: Anyone using Tivoli Decision Support and how do you like it? *I* like it. The installation is non-trivial (have your dba handy), but once set up properly, it's a joy to get nicely formatted reports that you can upload to your web server and have available first thing in the morning. Warning warning. RTFM. -- Mark Stapleton ([EMAIL PROTECTED])
Tivoli Decision Support
Hi all, Anyone using Tivoli Decision Support and how do you like it? -Original Message- From: Dearman, Richard [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 8:57 AM To: [EMAIL PROTECTED] Subject: Reporting Statistics Does anyone know of any reporting tools that works well with TSM. I know Tivoli has a Decision Support module for TSM but the price is pretty high. We don't have the entire Tivoli Framework enviornment implemented so I don't think it would be best used here. We just use TSM and I'm looking for a tool that can forecast future needs has well has show some good reports. Thanks ***EMAIL DISCLAIMER** This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management (312) 996-3941.
Re: Tivoli Decision Support
Not sure about a third party tool, but you can use SQL with Tivoli databases. It is a pretty effective way of getting reports. Tony Jules [EMAIL PROTECTED] 06/15/01 11:28AM I am looking into generating reports for my backups. Decision support sounds a little bit expensive! Is there any third party tool out there that can do a similar job? Thank you Tony Jules ITS / Olympus America Inc. 631-844-5887 [EMAIL PROTECTED] Lindsay Morris lmorris@SERVERTo: [EMAIL PROTECTED] GRAPH.COM cc: Sent by: ADSM:Subject: Re: Tivoli Decision Support Dist Stor Manager [EMAIL PROTECTED] ST.EDU 06/14/2001 02:31 PM Please respond to lmorris Must buy. TDS is a generic reporter; the various TDSfthisandthat packages target TDS to a specific application. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Levitan Sent: Thursday, June 14, 2001 1:37 PM To: [EMAIL PROTECTED] Subject: Re: Tivoli Decision Support Can you elaborate as to what the difference is... Are you able to do anything with the free TDSfSMA? or MUST you buy the TDS? Thanks! Marc Lindsay Morris lmorris@serverTo: [EMAIL PROTECTED] graph.com cc: Sent by: ADSM:Subject: Re: Tivoli Decision Support Dist Stor Manager [EMAIL PROTECTED] ST.EDU 06/14/2001 12:02 PM Please respond to lmorris TDSfSMA is bundled with TSM 4.1 for free -- but --- it requires Tivoli Decision Support, which retails at $21,000 or so. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Pitur Ey~srsson Sent: Thursday, June 14, 2001 11:43 AM To: [EMAIL PROTECTED] Subject: Tivoli Decision Support Hi only one short question Does TDSfSMA (Tivoli Decision Support for Storage Management Analysis) cost anything? does it come with the TSM Server or does it come with software like Tivoli Disaster Recovery. Kvedja/Regards Petur Eythorsson Taeknimapur/Technician Kerfisfrfpingur IR Microsoft Certified System Engineer Nyherji HfSimi TEL: +354-569-7700 Borgartun 37 105 Iceland URL:http://www.nyherji.is
Re: Tivoli Decision Support
I am looking into generating reports for my backups. Decision support sounds a little bit expensive! Is there any third party tool out there that can do a similar job? Thank you Tony Jules ITS / Olympus America Inc. 631-844-5887 [EMAIL PROTECTED] Lindsay Morris lmorris@SERVERTo: [EMAIL PROTECTED] GRAPH.COM cc: Sent by: ADSM:Subject: Re: Tivoli Decision Support Dist Stor Manager [EMAIL PROTECTED] ST.EDU 06/14/2001 02:31 PM Please respond to lmorris Must buy. TDS is a generic reporter; the various TDSfthisandthat packages target TDS to a specific application. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Levitan Sent: Thursday, June 14, 2001 1:37 PM To: [EMAIL PROTECTED] Subject: Re: Tivoli Decision Support Can you elaborate as to what the difference is... Are you able to do anything with the free TDSfSMA? or MUST you buy the TDS? Thanks! Marc Lindsay Morris lmorris@serverTo: [EMAIL PROTECTED] graph.com cc: Sent by: ADSM:Subject: Re: Tivoli Decision Support Dist Stor Manager [EMAIL PROTECTED] ST.EDU 06/14/2001 12:02 PM Please respond to lmorris TDSfSMA is bundled with TSM 4.1 for free -- but --- it requires Tivoli Decision Support, which retails at $21,000 or so. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Pitur Ey~srsson Sent: Thursday, June 14, 2001 11:43 AM To: [EMAIL PROTECTED] Subject: Tivoli Decision Support Hi only one short question Does TDSfSMA (Tivoli Decision Support for Storage Management Analysis) cost anything? does it come with the TSM Server or does it come with software like Tivoli Disaster Recovery. Kvedja/Regards Petur Eythorsson Taeknimapur/Technician Kerfisfrfpingur IR Microsoft Certified System Engineer Nyherji HfSimi TEL: +354-569-7700 Borgartun 37 105 Iceland URL:http://www.nyherji.is
Tivoli Decision Support
Hi only one short question Does TDSfSMA (Tivoli Decision Support for Storage Management Analysis) cost anything? does it come with the TSM Server or does it come with software like Tivoli Disaster Recovery. Kvedja/Regards Petur Eythorsson Taeknimaður/Technician Kerfisfræðingur IR Microsoft Certified System Engineer Nyherji HfSimi TEL: +354-569-7700 Borgartun 37 105 Iceland URL:http://www.nyherji.is
Re: Tivoli Decision Support
TDSfSMA is bundled with TSM 4.1 for free -- but --- it requires Tivoli Decision Support, which retails at $21,000 or so. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Pitur Ey~srsson Sent: Thursday, June 14, 2001 11:43 AM To: [EMAIL PROTECTED] Subject: Tivoli Decision Support Hi only one short question Does TDSfSMA (Tivoli Decision Support for Storage Management Analysis) cost anything? does it come with the TSM Server or does it come with software like Tivoli Disaster Recovery. Kvedja/Regards Petur Eythorsson Taeknimapur/Technician Kerfisfrfpingur IR Microsoft Certified System Engineer Nyherji HfSimi TEL: +354-569-7700 Borgartun 37 105 Iceland URL:http://www.nyherji.is
Re: Tivoli Decision Support
Can you elaborate as to what the difference is... Are you able to do anything with the free TDSfSMA? or MUST you buy the TDS? Thanks! Marc Lindsay Morris lmorris@serverTo: [EMAIL PROTECTED] graph.com cc: Sent by: ADSM:Subject: Re: Tivoli Decision Support Dist Stor Manager [EMAIL PROTECTED] ST.EDU 06/14/2001 12:02 PM Please respond to lmorris TDSfSMA is bundled with TSM 4.1 for free -- but --- it requires Tivoli Decision Support, which retails at $21,000 or so. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Pitur Ey~srsson Sent: Thursday, June 14, 2001 11:43 AM To: [EMAIL PROTECTED] Subject: Tivoli Decision Support Hi only one short question Does TDSfSMA (Tivoli Decision Support for Storage Management Analysis) cost anything? does it come with the TSM Server or does it come with software like Tivoli Disaster Recovery. Kvedja/Regards Petur Eythorsson Taeknimapur/Technician Kerfisfrfpingur IR Microsoft Certified System Engineer Nyherji HfSimi TEL: +354-569-7700 Borgartun 37 105 Iceland URL:http://www.nyherji.is
Re: Tivoli Decision Support
Must buy. TDS is a generic reporter; the various TDSfthisandthat packages target TDS to a specific application. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Levitan Sent: Thursday, June 14, 2001 1:37 PM To: [EMAIL PROTECTED] Subject: Re: Tivoli Decision Support Can you elaborate as to what the difference is... Are you able to do anything with the free TDSfSMA? or MUST you buy the TDS? Thanks! Marc Lindsay Morris lmorris@serverTo: [EMAIL PROTECTED] graph.com cc: Sent by: ADSM:Subject: Re: Tivoli Decision Support Dist Stor Manager [EMAIL PROTECTED] ST.EDU 06/14/2001 12:02 PM Please respond to lmorris TDSfSMA is bundled with TSM 4.1 for free -- but --- it requires Tivoli Decision Support, which retails at $21,000 or so. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Pitur Ey~srsson Sent: Thursday, June 14, 2001 11:43 AM To: [EMAIL PROTECTED] Subject: Tivoli Decision Support Hi only one short question Does TDSfSMA (Tivoli Decision Support for Storage Management Analysis) cost anything? does it come with the TSM Server or does it come with software like Tivoli Disaster Recovery. Kvedja/Regards Petur Eythorsson Taeknimapur/Technician Kerfisfrfpingur IR Microsoft Certified System Engineer Nyherji HfSimi TEL: +354-569-7700 Borgartun 37 105 Iceland URL:http://www.nyherji.is
Tivoli Decision Support for Storage Management Analysis
Hi All 1) Has anybody used Tivoli Decision Support for Storage Management Analysis with TSM 4.1 yet ? Is it released / anyone have any idea when ? For months the Tivoli web site has stated it "will" be incorporated as below: "Available as a separate product with the Tivoli Storage Manager Version 3.7 product. Planned to be integrated as part of the Tivoli Storage Manager Version 4.1 product " 2) Has anyone that has used previous incarnations had good / bad experiences of this product ? have fun Shaun
Re: Tivoli Decision Support for Storage Management Analysis
"Leake, Shaun" wrote: 1) Has anybody used Tivoli Decision Support for Storage Management Analysis with TSM 4.1 yet ? Is it released / anyone have any idea when ? Yes, the Storage Management module for TDS has been out for over a year at the 4.1.x level. For months the Tivoli web site has stated it "will" be incorporated as below: "Available as a separate product with the Tivoli Storage Manager Version 3.7 product. Planned to be integrated as part of the Tivoli Storage Manager Version 4.1 product " It is not yet integrated. Keep in mind that TDS is a standalone product. The module for TSM that runs within TDS is generally shipped with TSM. 2) Has anyone that has used previous incarnations had good / bad experiences of this product ? Yes. I rather like the product: 1. The product works as advertised. 2. The information it produces can be helpful, particularly when charting trends. 3. Since the modules works with a prebuilt collection of SQL select statements, it is easy for the TDS admin to create additional statements. The problem with the product is that it is a mother-bear to install. It does not work right out of the shrinkwrap. -- Mark Stapleton ([EMAIL PROTECTED])
Tivoli Decision Support for Storage Management Analysis
Can anyone attest to the value of the information provided by TDS4SMA? Also, the Tivoli web site indicates that TDS4SMA is "Planned to be integrated as part of the Tivoli Storage Manager Version 4.1 product". Is it? John G. Talafous IS Technical Principal The Timken CompanyGlobal Software Support P.O. Box 6927 Data Management 1835 Dueber Ave. S.W. Phone: (330)-471-3390 Canton, Ohio USA 44706-0927 Fax : (330)-471-4034 [EMAIL PROTECTED] http://www.timken.com