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
|