It handles expiration like Oracle RMAN (in general). The expiration is done by the client, not the normal "versioning" of TSM. The SQL-BT setup and config should have info on setting up Management Class on TSM for this. I have SQL-BT version 4.2 on AIX Sybase Client. The config on SQL-BT allows you to specify how many versions you want to keep, and SQL-BT "expires" old version each day when it does a backup.
Whether the data went to TSM disk pool first and then to tape or directly to tape has no bearing at all on the expiration. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax: 321.434.5509 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 01/21/04 10:39AM >>> Hello all, How does TSM handle the expiration of SQL Backtrack filespaces if the data was originally written directly to tape, thus never existing on hard disk? We have a situation where these filespaces are not expiring and are not even being marked as inactive yet they are in a MC that is set to retain only ten versions. TSM Server: 5.1.5.5 OS Version: AIX 5.1 SQL BT Version: 3.4.10 TIA, Rob ############################################################## This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ##############################################################