ADSM-L

Re: how to find out the date when a file became inactive??

2004-06-08 12:41:07
Subject: Re: how to find out the date when a file became inactive??
From: "Stapleton, Mark" <mark.stapleton AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 8 Jun 2004 11:36:12 -0500
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
Behalf Of Lisa Laughlin
>Thanks Richard-- I was hoping it wasn't one of THOSE select 
>statements-- I started
>
>tsm: TSM_HQ_2>select deactivate_date, filespace_name, type, ll_name,
>hl_name,dea
>ctivate_date, class_name, state, backup_date,node_name from 
>backups where
>NODE_N
>AME='GHDATA01DISKGROUP2' order by BACKUP_DATE

Also, try to limit the select by setting delimiters on the
filespace_name, type, and backup_date.

--
Mark Stapleton