Well you can look it up in the manual or just take my word
for this.  A tape can only hold one database backup.  That's
the way *sm works.  Even if your Tape can hold 20,000 gig and your
database backup is 8 meg, you can only have one database backup on
that tape.  The manual you want is the Administrators Guide.
In order to free up tapes that are used for database backups,
you have to use the 'DELETE VOLHIST TYPE=DBB' with the date parameter to
specify that tapes older than that date be freed up.  Warning if you use the
command above as is, you will delete all but your last full database backup.
 *sm prevents you from deleting the last(newest) database backup.

Regards,

James Thompson

From: Chris W Knox <Chris.W.Knox AT AEXP DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: ADSM newbie seeks guidance on database backups
Date: Wed, 15 Mar 2000 14:13:10 -0700

I've inherited a half-installed instance of ADSM and just connected an ADIC
Scalar 1000.  As part of the installation I did a BACKUP DATABASE command
last week.  It used volume 000101 to do the backup which had been defined
as
scratch.  Today I came in after a 4 day weekend and discovered that the
database doesn't get automatically backed up, so I issued the BACKUP DB
command
as shown below.  The system then proceeded to examine and reject every tape
in
the system.  Why couldn't it use the same tape where the database was
originally stored?  RTFM answers welcome as long as they contain a pointer
to
the FM.

cwk

==========================================================================




03/15/00   13:38:33  ANR2017I Administrator ADMIN issued command: BACKUP DB
                      devclass=dlt-drives
03/15/00   13:38:33  ANR0984I Process 25 for DATABASE BACKUP started in the
                      BACKGROUND at 13:38:33.
03/15/00   13:38:33  ANR2281I Incremental database backup started as
process
                      25.
03/15/00   13:38:43  ANR2017I Administrator ADMIN issued command: QUERY
ACTLOG
03/15/00   13:41:01  ANR8337I DLT volume 000104 mounted in drive TOPRIGHT
                      (/dev/rmt/7mt).
03/15/00   13:41:01  ANR8448E Scratch volume 000104 from library ADIC
rejected
                      - volume name is already in use.
03/15/00   13:41:01  ANR8336I Verifying label of DLT volume 000104 in drive
                      TOPRIGHT (/dev/rmt/7mt).
03/15/00   13:41:55  ANR8468I DLT volume 000104 dismounted from drive
TOPRIGHT
                      (/dev/rmt/7mt) in library ADIC.
03/15/00   13:42:16  ANR8337I DLT volume 000105 mounted in drive BOTTOMLEFT
                      (/dev/rmt/10mt).
03/15/00   13:42:16  ANR8448E Scratch volume 000105 from library ADIC
rejected
                      - volume name is already in use.
03/15/00   13:42:16  ANR8336I Verifying label of DLT volume 000105 in drive
                      BOTTOMLEFT (/dev/rmt/10mt).
03/15/00   13:43:04  ANR8468I DLT volume 000105 dismounted from drive
                      BOTTOMLEFT (/dev/rmt/10mt) in library ADIC.
03/15/00   13:43:30  ANR8337I DLT volume 000106 mounted in drive
BOTTOMRIGHT
                      (/dev/rmt/11mt).
03/15/00   13:43:30  ANR8448E Scratch volume 000106 from library ADIC
rejected
                      - volume name is already in use.
03/15/00   13:43:30  ANR8336I Verifying label of DLT volume 000106 in drive
                      BOTTOMRIGHT (/dev/rmt/11mt).
03/15/00   13:44:09  ANR8468I DLT volume 000106 dismounted from drive
                      BOTTOMRIGHT (/dev/rmt/11mt) in library ADIC.
03/15/00   13:44:36  ANR8337I DLT volume 006040 mounted in drive CENTERLEFT
                      (/dev/rmt/2mt).
03/15/00   13:44:36  ANR8448E Scratch volume 006040 from library ADIC
rejected
                      - volume name is already in use.
03/15/00   13:44:36  ANR8336I Verifying label of DLT volume 006040 in drive
                      CENTERLEFT (/dev/rmt/2mt).
03/15/00   13:45:15  ANR8468I DLT volume 006040 dismounted from drive
                      CENTERLEFT (/dev/rmt/2mt) in library ADIC.
03/15/00   13:45:42  ANR8337I DLT volume 006048 mounted in drive
CENTERRIGHT
                      (/dev/rmt/3mt).
03/15/00   13:45:42  ANR8448E Scratch volume 006048 from library ADIC
rejected
                      - volume name is already in use.
03/15/00   13:45:42  ANR8336I Verifying label of DLT volume 006048 in drive
                      CENTERRIGHT (/dev/rmt/3mt).
03/15/00   13:46:21  ANR8468I DLT volume 006048 dismounted from drive
                      CENTERRIGHT (/dev/rmt/3mt) in library ADIC.
03/15/00   13:47:38  ANR8337I DLT volume 006051 mounted in drive TOPLEFT
                      (/dev/rmt/6mt).
03/15/00   13:47:38  ANR8448E Scratch volume 006051 from library ADIC
rejected
                      - volume name is already in use.
03/15/00   13:47:38  ANR8336I Verifying label of DLT volume 006051 in drive
                      TOPLEFT (/dev/rmt/6mt).
03/15/00   13:47:39  ANR1405W Scratch volume mount request denied - no
scratch
                      volume available.
03/15/00   13:47:39  ANR4578E Database backup/restore terminated - required
                      volume was not mounted.
03/15/00   13:47:39  ANR0985I Process 25 for DATABASE BACKUP running in the
                      BACKGROUND completed with completion state FAILURE
at
                      13:47:39.
03/15/00   13:48:20  ANR8468I DLT volume 006051 dismounted from drive
TOPLEFT
                      (/dev/rmt/6mt) in library ADIC.

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com