Not sure if this is what you're looking to keep - take a look at the SET SUMMARYRETENTION and SET EVENTRETENTION commands:
http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/topic/com.ibm.itsmmsm unn.doc/b_adminref_solaris396.htm#dqx2r_cmd_summaryretention_set http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/topic/com.ibm.itsmmsm unn.doc/b_adminref_solaris375.htm#dqx2r_cmd_eventretention_set You can keep stuff for up to 9,999 days should you wish. Cheers, /David Mc London, UK -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Roger Deschner Sent: 20 February 2010 18:49 To: [email protected] Subject: Re: [ADSM-L] Incrasing the amount of system data stored in the TSM database I believe it only keeps 30 days worth of summary data. I'm not sure you can change this - or that you'd want to. Your database will grow. However, the data in the summary table is very valuable for later analysis. What I do is every day, shortly after midnight, run a SQL SELECT to extract the previous day's summary table entries, and save that in a plain flat tab-delimited disk file. I use a separate file for each day, keep them forever, and combine them into a temporary file only when I want to analyze data across a number of days. Then I analyze this data afterwards using the SPSS statistical package (an IBM product) which produces much, much nicer reports and charts than you could possibly do with even the most ingenious SQL SELECT syntax. Any other general-purpose statistical package that you happen to have such as SAS would also work. This also removes the processing load of data analysis from the TSM server and its all-important database, onto another system such as my desktop PC. Roger Deschner University of Illinois at Chicago [email protected] Academic Computing & Communications Center ======I have not lost my mind -- it is backed up on tape somewhere.===== On Fri, 19 Feb 2010, Erwin Zavala wrote: >I would like store more data the system produces for the summary table ... >say from 90 days to 180 days... where would I change that setting? > No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2696 - Release Date: 02/18/10 19:34:00
