SELECT FILESPACE_NAME, HL_NAME, LL_NAME \
FROM BACKUPS \
WHERE NODE_NAME = '' \
AND LL_NAME = 'init.dat'
Zlatko Krastev
IT Consultant
Henrik Ursin <[EMAIL PROTECTED]> on 30.08.2001 11:21:52
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject
--
From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 8:12 AM
To: [EMAIL PROTECTED]
Subject: Re: locate files in the tsm database
I think it's a lot faster to let the client find it.
Start the client (dsm on AIX)
Click RESTORE
Pull down VIEW, Active and Inactive
C
t Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: locate files in the tsm database
I think it's a lot faster to let the client find it.
Start the client (dsm on AIX)
Click RESTORE
Pull down VIEW, Active and Inactive
Click the SEARCH icon (the magnifyin
search for (you can search on partial names)
Click SEARCH
Let the client do the walking!
-Original Message-
From: David McClelland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 4:41 AM
To: [EMAIL PROTECTED]
Subject: Re: locate files in the tsm database
Hi Henrik,
Try somethi
select hl_name from backups where node_name='X' and filespace_name='\\X\c$' and
ll_name='init.dat'
Henrik Ursin <[EMAIL PROTECTED]> on 30-08-2001 10:21:52
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: Carsten Moldrup/SCA/CSC)
Subject: l
Hi Henrik,
Try something simple, like:
select NODE_NAME, FILESPACE_NAME, FILE_NAME, FILE_SIZE from CONTENTS
where FILE_NAME like '% init.dat'
This should find all instances of 'init.dat' whether backups or archives.
I'm sure you could probably format this better, but the bare bones are
th
