It's exactly like that. You need to keep the metadata on disk. In the TDP for SQL 6.4 book, search for the topic Metadata Considerations.
This may also help: http://www-01.ibm.com/support/docview.wss?uid=swg27035973 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Saravanan Sent: Friday, April 18, 2014 10:09 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for SQL While querying backups(active, inactive) during restore in version TDP SQL 6.4, its taking much time, some time more than 5 hours. Is there any parameters can set in .cfg or .opt file to get faster response? Like TOC in NAS By Sarav +65-82284384