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 magnifying glass on the AIX client)
Type in the name of the filesystem as "start path"
Type in the name of the file to 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 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
there :o) Anyone else with any advances on the above?
Rgds,
David McClelland
---------------------------
Tivoli Storage Management Team
IBM EMEA Technical Centre,
Internet: [EMAIL PROTECTED]
Henrik Ursin <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 30-08-2001 09:21:52
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: locate files in the tsm database
A filesystem on a tsm node contained a lot of different init.dat files
(all erased).
Is it possible to make a query in the tsm database to find out where these
files are positioned in the filesystem - some kind of select command?
Med venlig hilsen / Regards
Henrik Ursin Tlf./Phone +45 35878934
Fax +45 35878990
Email [EMAIL PROTECTED]
Mail: UNI-C
DTU, bygning 304
DK-2800 Lyngby
