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@VM.MARIST.EDU <[EMAIL PROTECTED] 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 [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 9:21 AM To: ADSM-L@VM.MARIST.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@VM.MARIST.EDU <[EMAIL PROTECTED] 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:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.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