Re: Time limit on TSM DB? SOLVED

Folks,

Thanks!

That clears up some things......

     Activity Log Retention Period: 2 Day(s)
     Activity Summary Retention Period: 30 Day(s)

Thanks again!

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:34
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






You are searching the activity log, which has a user defined retention
period. You can set the retention using the command:
set actlogretention ##
Where ## is the number of days to retaining records.
You can see your current settings by issuing a "query status"
command.


Doug Thorneycroft
Systems Analyst
Computer Technology Section
County Sanitation Districts of Los Angeles County
(562) 699-7411 Ext. 1058
FAX (562) 699-6756
dthorneycroft AT lacsd DOT org



-----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 9:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Time limit on TSM DB?


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