Hi All,
I am posting this on behalf of my colleague.
Thanks,
Steve Roder, University at Buffalo
HOD Service Coordinator
VM Systems Programmer
UNIX Systems Administrator (Solaris and AIX)
TSM/ADSM Administrator
([EMAIL PROTECTED] | (716)645-3564)
---------- Forwarded message ----------
Date: Fri, 14 Feb 2003 11:59:48 -0500
From: "Jackson, Jay" <[EMAIL PROTECTED]>
To: "Roder, Steve" <[EMAIL PROTECTED]>
Subject: Listserv question
We're attempting to extract file name and size information from the
database with SELECT. It appears the data we want is in the CONTENTS
table. The SELECT command takes an excessive amount of time to return when
not using the table key, VOLUME_NAME.
Is it possible to add an index to a TSM database table? How does the
client (eg Windows) return active file information so quickly?
thanks!
Jay Jackson
University of Buffalo
[EMAIL PROTECTED]