Actually, if you do a
select colname, index_keyseq from syscat.columns where tabname='BACKUPS'
you'll find that columns are indexed like so:
NODE_NAME 1
FILESPACE_NAME 2
STATE 3
TYPE 4
HL_NAME 5
LL_NAME 6
You can speed up the search significantly by specifying as many values as
you can. Note, once you break the 123456 chain, specifying values below the
break doesn't speed the search any.
Note, if you want both active and inactive, two selects runs really fast,
and I think something like
... filespace_name='whatever' and (state='ACTIVE_VERSION or
state='INACTIVE_VERSION') and type='FILE' ...
would actually use the keys also and run just as fast.
-----Original Message-----
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
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
"WorldSecure <Freightliner.com>" made the following
annotations on 08/30/01 09:40:23
------------------------------------------------------------------------------
[INFO] -- Content Manager:
The information contained in this communication is confidential and intended solely
for the use of the individual to whom it is addressed and others authorized to receive
it. If you are not the intended recipient, any disclosure, copying, distribution or
taking of any action in reliance on the contents of this information is prohibited. If
you have received this communication in error, please immediately notify the sender by
phone if possible or via email message.
==============================================================================
