Do a "q status".  That will show the retention period for ACTLOG and SUMMARY.


At 12:21 PM 5/6/2005 -0400, you wrote:

I'm doing some lookups for amount of data being backed up.

Here's the statement:

select
nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as
decimal(6,2)))
as GB from nodes, summary
where (end_time between '2005-03-28' and '2005-03-31')
 and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or
activity='RETRIEVE')
and ((nodes.node_name=summary.entity))
group by domain_name,summary.activity order by activity,domain_name asc

'2005-04-04' and '2005-04-06' generates a list

'2005-03-28' and '2005-03-31' generates "no match"

DaveZ




                      "Thorneycroft,
                      Doug"                    To:       ADSM-L AT VM.MARIST 
DOT EDU
                      <dthorneycroft@LA        cc:
                      CSD.ORG>                 Subject:  Re: [ADSM-L]
Time limit on TSM DB?
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      05/06/2005 12:03
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Please be more specific, what is it that you
are looking for in the database?


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Dave Zarnoch
Sent: Friday, May 06, 2005 8:59 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Time limit on TSM DB?


Folks,

Sorry if this is a "FAQ"......

I'm trying to generate reports from our TSM database that are
older than 1 month old and I am not finding any info.

Is this the time retention on the DB?

How do I find out?

Thanks!

DaveZ

Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464