I have 0 scratch now ... if I load any scratch tapes then DB BC is using
those scratch tapes and completing with failure. from past 2 days DB BC
has taken more than 30 tapes.

Thanks & Regards,

Srikanth kola
Backup & Recovery
IBM India Pvt Ltd, Chennai
Mobile: +91 9885473450



From:   David Ehresman <david.ehresman AT LOUISVILLE DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   01/28/2015 06:48 PM
Subject:        Re: [ADSM-L] req: tsm db backup completed with failure and
taking all scratch tapes fro DB BC
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



 Try running:

select library_name, -
count(*) from libvolumes -
where lower(status)='scratch'   -
group by library_name

to make sure TSM thinks you have scratch tapes.

Does the actlog show any tape mounts after the start of the backup db
command?

David

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Srikanth Kola23
Sent: Wednesday, January 28, 2015 4:39 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] req: tsm db backup completed with failure and taking
all scratch tapes fro DB BC

Hello Roger,

daily 1 full DB backup i am keeping . and delete volhistory is also done
to get more scratch tapes. its a 3573 lto model library with 44 data
slots.

if i generate scratch  with in couple of minutes the scratch tapes  are
using for db bc and comleting with failure.


act log
=====

>01/27/2015 14:18:23      ANR0299I A full database backup will be started.
>The
>                          archive log space used is 82% and the archive
>log space
>                          used threshold is 80%. (PROCESS: 28)
>01/27/2015 14:18:23      ANR0984I Process 29 for Database Backup started
>in the
>                          BACKGROUND at 14:18:23. (PROCESS: 29)
>01/27/2015 14:18:23      ANR4559I Backup DB is in progress. (PROCESS: 29)
>
>01/27/2015 14:18:28      ANR1405W Scratch volume mount request denied -
no
>scratch
>                          volume available. (PROCESS: 29)

Thanks & Regards,

Srikanth kola
Backup & Recovery
IBM India Pvt Ltd, Chennai
Mobile: +91 9885473450



From:   Roger Deschner <rogerd AT UIC DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   01/28/2015 01:21 PM
Subject:        Re: [ADSM-L] req: tsm db backup completed with failure and
taking all scratch tapes fro DB BC
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



You've got to free up one or more scratch tape(s) somehow. Either that
or decide to write your TSM DB backups somewhere else, such as SAN.
There is no way around this.

How many Full DB backups are you keeping? Is that more than you need? If
so, see the DELETE VOLHISTORY command to get rid of old backups and
release scratch tapes. A typical thing is to run a scheduled DELETE
VOLHIST TODAY-8 or something like that after a successful rc=0 full
database backup. Always make sure you're keeping your most recent FULL
database backup and all the incremental backups after it.

Do your own inventory of tapes in your tape library, and make sure you
can identify what each of them is used for. They will either be VOLUMEs
or they'll be listed in the Volume History File for DB backups etc. You
may find some free tapes where you did not expect them. Or you may find
library slots taken up by defective tapes that can be replaced with good
new ones. Just be careful here, not to free a tape with needed data on
it.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
======I have not lost my mind -- it is backed up on tape somewhere.=====


On Wed, 28 Jan 2015, Srikanth Kola23 wrote:

>Hi Team,
>
>Can any one get me out of this problem.....
>
>tsm server - Version 7, Release 1, Level 1.0
>
>       Platform: WinNT (windows 2008)
>       Client OS Level: 6.01
>
>DESCRIPTION : DB Backup completing with failure and  all scratch volumes
>using for DB BC .
>
>act log
>======
>
>01/27/2015 14:08:26      ANR0985I Process 28 for Database Backup running
>in the      BACKGROUND completed with completion state FAILURE at
>14:08:26. (PROCESS: 28)
>01/27/2015 14:18:23      ANR0299I A full database backup will be started.
>The
>                          archive log space used is 82% and the archive
>log space
>                          used threshold is 80%. (PROCESS: 28)
>01/27/2015 14:18:23      ANR0984I Process 29 for Database Backup started
>in the
>                          BACKGROUND at 14:18:23. (PROCESS: 29)
>01/27/2015 14:18:23      ANR4559I Backup DB is in progress. (PROCESS: 29)
>
>01/27/2015 14:18:28      ANR1405W Scratch volume mount request denied -
no
>scratch
>                          volume available. (PROCESS: 29)
>01/27/2015 14:18:30      ANR1626I The previous message (message number
>1405) was
>                          repeated 1 times.
>01/27/2015 14:18:30      ANR4578E Database backup/restore terminated -
>required
>                          volume was not mounted. (PROCESS: 29)
>01/27/2015 14:18:30      ANR0985I Process 29 for Database Backup running
>in the
>                          BACKGROUND completed with completion state
>FAILURE at
>                          14:18:30. (PROCESS: 29)
>01/27/2015 14:18:30      ANR1893E Process 29 for Database Backup
completed
>with a
>                          completion state of FAILURE. (PROCESS: 29)
>01/27/2015 14:21:59      ANR1959I Status monitor collecting current data
>at
>                          14:21:59.
>01/27/2015 14:22:15      ANR1960I Status monitor finished collecting data
>at
>                          14:22:15 and will sleep for 15 minutes.
>01/27/2015 14:28:26      ANR0299I A full database backup will be started.
>The
>                          archive log space used is 82% and the archive
>log space
>                          used threshold is 80%. (PROCESS: 29)
>
>
>
>Thanks & Regards,
>
>Srikanth kola
>Backup & Recovery
>IBM India Pvt Ltd, Chennai
>Mobile: +91 9885473450
>