Thanks guys. Lots of stuff there to get my teeth into.

-----Original Message-----
From: Len Boyle [mailto:Len.Boyle AT SAS DOT COM]
Sent: 21 September 2006 16:46
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Total newbie question about DB Backups


Angus,

Look at help query volhist

This will show you the db tapes and other special tapes

Query volhist type=dbb

len

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Angus Macdonald
Sent: Thursday, September 21, 2006 11:36 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Total newbie question about DB Backups

Okay, I may rely on mirroring then. If I do a DB backup every 4 hours it'll
cost 6 tapes a day and each one will only have a few MB of data.

For some reason, the tapes used for DB Backup aren't listed when I execute a
Q VOL. Something else to investigate.

Thanks again.

-----Original Message-----
From: PAC Brion Arnaud [mailto:Arnaud.Brion AT PANALPINA DOT COM]
Sent: 21 September 2006 16:28
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Total newbie question about DB Backups


Hi Angus !

You'll probably get somehow disapointed, but there's no way to do what
you're asking !
TSM wants a new tape for each DB backup, and the only way to spare your
precious scratch volumes would be to use some form of disk storage, thru
the mean of a sequential-on-disk device class ...

HTH.

Cheers

Arnaud

************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland,
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Angus Macdonald
Sent: Thursday, 21 September, 2006 17:11
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Total newbie question about DB Backups

I'm just in the process of implementing TSM 5.3 for the first time in
our environment and I'm following the TSM Implementation Guide (June
2006
edition) redbook very closely ;-) Things are going pretty well so far
but I have a bit of an issue with my database backups. Every DB backup
seems to use another scratch tape so my 3582 is going to run out of
tapes very quickly. My backup command is

Backup DB type=full devc=lto2-dc

lifted directly from the redbook. How can I limit the number of tapes
used for DB backups? I tried limiting the backup to a particular tape
volume but the tape is apparently in use after the first backup and
cannot be reused.

Angus