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]