Not familiar with SQL BT for Oracle but I use (unfortunately) SQL BackTrack
for Informix. There is a $DTICATALOG directory (as database instance owner,
echo $DTICATALOG). Within the DTI Catalog directory, there is a file called
"dtoptions". One stanza from this file shows how a BMQ SQ BT "backup pool"
is bound to a TSM management class
& whether it is a backup or archive as well as the TSM filespace (remember
that the backup_pool=V35003DM is a
BMC reference:

begin backup_pool=V35003DM
  obsi=adsm
  dsmi_config=/usr/tivoli/tsm/client/api/bin/dsm.opt
  mount-wait=y
  filespace=/V35003DM
  management_class=32day
  storage-pool=archive
end backup_pool

This is the line in the backup script where the BMC "-to" option points the
backup to a BMC "backup_pool":

dtibackup -whole_system -quiet -noprompt -to V35003DM -debug -debugfile
/tmp/dbg.dmartbkup

and to add a bit more to this mess, there is an instance directory within
the $DTICATALOG path that contains the
default for any backups make by this instance user in case a "-to" option
is not specified. It contains defaults for
all dbspaces plus a default for logical logs. The name of the instance
directory is "dbcci" and there is another
instance directory called psinf_73uc1. In the case of an Informix database,
the place where the default BMC
"backup_pool" is set is called onbarconfig:

informix at afcprod1: /usr/bmc/IFX/data/dtcat $ ls
dbcci        dtoptions    dtseq        psinf_73uc1
informix at afcprod1: /usr/bmc/IFX/data/dtcat $ cd dbcci
informix at afcprod1: /usr/bmc/IFX/data/dtcat/dbcci $ ls
exportconfig   exporthistory  onbarconfig    onbarhistory   profile
schemahistory
informix at afcprod1: /usr/bmc/IFX/data/dtcat/dbcci $ more onbarconfig
begin object=@@default
  pool=V35003DM
end object
begin object=logical-log
  pool=V35003DM
end object

Hope all that mess helped... take this with a grain of salt as the BMC SQL
BT for Oracle product may work differently...

George Lesho
AFC Enterprises






                    "Reichmuth,
                    Michael R."          To:     ADSM-L AT VM.MARIST DOT EDU
                    <mrreich@NPPD.       cc:     (bcc: George 
Lesho/Partners/AFC)
                    COM>                 Subject:     how does TSM / sql 
backtrack use
                    Sent by:              management classes?
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MAR
                    IST.EDU>


                    03/04/02 03:20
                    PM
                    Please respond
                    to "ADSM: Dist
                    Stor Manager"






We're using SQL backtrack to backup our oracle database. If two backtrack
backup scripts are run using two different management classes against the
same database, (ie.. management class one has 3 version, 30 days and
management class two has 6 versions 60 days) how does TSM handle the
backup?
Will it in effect use the shortest management class. Or will it keep two
sets of the database, one for 3/30 and the other for 6/60?