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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Roger Deschner
Sent: 20 February 2010 18:49
To: ADSM-L AT VM.MARIST DOT EDU
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     rogerd AT uic DOT edu
               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