ADSM-L

Re: Expiration of SQL BackTrack Filespaces

2004-01-21 11:33:48
Subject: Re: Expiration of SQL BackTrack Filespaces
From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 21 Jan 2004 11:33:04 -0500
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
david.longo AT health-first DOT org


>>> R.Hefty AT LABSAFETY DOT COM 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.
##############################################################

<Prev in Thread] Current Thread [Next in Thread>