;I/O, I/O, It's all about I/O" -(me)
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Tuesday, June 21, 2005 2:56 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Need backup dates of files on a specific tape...
On Jun 21, 20
I think you meant to select from the BACKUPS table... the CONTENTS table
doesn't have BACKUP_DATE, HL_NAME, or LL_NAME columns. But even then, if
there are multiple versions, you can't easily distinguish which one is on
a given volume.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage
On Jun 21, 2005, at 2:41 PM, Richard Sims wrote:
SELECT * FROM CONTENTS WHERE NODE_NAME='' AND
FILESPACE_NAME='' AND HL_NAME='' AND LL_NAME=''
Duh... that should have said:
SELECT * FROM BACKUPS WHERE NODE_NAME='' AND
FILESPACE_NAME='' AND HL_NAME='' AND LL_NAME=
you a good
probability.
Ben
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard
Sims
Sent: Tuesday, June 21, 2005 12:42 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Need backup dates of files on a specific tape...
On Jun 21, 2005, at 1:59 PM, George, Jas
On Jun 21, 2005, at 1:59 PM, George, Jason wrote:
Hello All-
My team lead posted this question to ADSM.org with no results- so I'll
warn you now, it's a stumper!
I have a situation where a tape has been destroyed and cannot be
restored from offsite tapes. I need to know the backup date of the
There's no such query that I can think of, since the CONTENTS table does
not include the object ID of the files in that table, so you can't tie
anything directly to the BACKUPS table.
However, another possible approach: Assuming you know the file name you
are looking for (and it sounds like you do
Hello All-
My team lead posted this question to ADSM.org with no results- so I'll
warn you now, it's a stumper!
I have a situation where a tape has been destroyed and cannot be
restored from offsite tapes. I need to know the backup date of the file
on the tape. Does anyone have a select statement