Re: select statemant to find oldest file in diskpool
2006-12-29 12:24:17
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
|
|
|