Hallo Srikanth

I don't know, if somebody else already mentioned:

My be a  relief somehow:

Change server option :

ARCHLOGUSEDTHRESHOLD to 90  or 95 (default is 80)

rgds

Michael Malitz, MA
Project Manager, PMP® 
IBM/Tivoli Certified Instructor (TSM & ITM)
Power Administrator for TSM      www.tsmpoweradmin.com
+++++++++++++++++++++++++++++
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag von
Srikanth Kola23
Gesendet: Mittwoch, 28. Januar 2015 10:39
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: 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
>