Re: Time limit on TSM DB?
2005-05-06 12:23:26
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
|
|
|