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
