-
Title
xp_view_tsmcontents does not return all TSM backups -
Description
xp_view_tsmcontents does not return a list of all backups made. A list of backups is returned but it is not all the TSM objects.
-
Cause
Only TSM Backups are returned by default. Additional parameters must be included to return TSM Archives.
-
Resolution
In order to view the TSM Archives the following parameter must be included in the query: ,@tsmarchives=1
eg.
EXEC master.dbo.xp_view_tsmcontents
@tsmfilespace = 'DE00SRVORG023T1_QLS'
, @tsmarchive=1
, @tsmconfigfile = 'C:\Program Files\Tivoli\TSM\baclient\dsm.opt' -
Additional Information
The following parameter may be used to return a complete list of details, this the process may be lengthy, if the objects are on tape or very large:
@tsmbrieflist=0
EXEC master.dbo.xp_view_tsmcontents
@tsmfilespace = 'DE00SRVORG023T1_QLS'
, @tsmbrieflist=0
, @tsmarchive=1
, @tsmconfigfile = 'C:\Program Files\Tivoli\TSM\baclient\dsm.opt'