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
(spr AT buffalo DOT edu | (716)645-3564)


---------- Forwarded message ----------
Date: Fri, 14 Feb 2003 11:59:48 -0500
From: "Jackson, Jay" <tksjwj AT acsu.buffalo DOT edu>
To: "Roder, Steve" <spr AT rexx.acsu.buffalo DOT edu>
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
tksjwj AT buffalo DOT edu