ADSM-L

Re: select statemant to find oldest file in diskpool

2006-12-29 12:24:17
Subject: Re: select statemant to find oldest file in diskpool
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 29 Dec 2006 11:51:35 -0500
I don't see any way to get that.
The TSM server stores the backup date of a file in the BACKUPS table.

But there is no pointer to tell you which storage pool volume that
particular file is in.

WHY are you trying to get the information?  Perhaps there is another
way.
If you have the file name, just pull it from the backups table... 
 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gary Osullivan
Sent: Friday, December 29, 2006 11:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statemant to find oldest file in diskpool

hi all
 
I'm trying to come up with an sql to select the file dates in a specific
stgpool
 
What I really need to find is the oldest date stamp of a file in a
specific onsite disk pool
 
any help would be great
 
Gary
 

<Prev in Thread] Current Thread [Next in Thread>