Re: del volhist problem
2005-03-25 15:34:33
Alexander,
TSM won't let you delete those volumes since they are all part of the
most recent DB backup set.
It appears that you are doing incremental DB backups at random times
which indicates that the DB backup trigger is causing these backups.
The DB backup trigger happens when the log space starts to be over
committed. Therefore there are several suggestions I can make to you.
1. Increase the size of your log file, This should cut down on the
number of triggered DB backups.
2. Consider changing your strategy for DB backups. I recommend that
your "on site" DB backups should be full/incremental and should be
done to a device type of file. Typically I do a full once a week
and do incremental the rest of the week. There is no performance
hit since it is to a device of type file. Also, set your DB
backup trigger to use this device and set the number of
incremental to the max. BTW, with a DB of 15GB using 1 full and
six incremental plus keeping the full previous set (i.e. the
previous weeks) you should need less than 50GB of disk space.
3. For off site DB backups use a snapshot backup to tape. Only run
this on the days that you take tapes off site.
I have given you the basic concepts of what I would do. If you need
more specific commands on how to implement this please feel free to ask.
--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.
===============================================================================
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===============================================================================
Alexander Lazarevich wrote:
HEre's the output:
tsm: TSM>q volh t=dbb
Date/Time: 03/21/2005 11:00:48
Volume Type: BACKUPFULL
Backup Series: 112
Backup Operation: 0
Volume Seq: 1
Device Class: LTOCLASS1
Volume Name: ITG044L2
Volume Location:
Command:
Date/Time: 03/24/2005 18:16:08
Volume Type: BACKUPINCR
Backup Series: 112
Backup Operation: 1
Volume Seq: 1
Device Class: LTOCLASS1
Volume Name: ITG010L2
Volume Location:
Command:
Date/Time: 03/25/2005 06:01:13
Volume Type: BACKUPINCR
Backup Series: 112
Backup Operation: 2
Volume Seq: 1
Device Class: LTOCLASS1
Volume Name: ITG033L2
Volume Location:
Command:
My issue with that idea is the database is only 13-14GB, so how could it
need 3 tapes for the DB backup? I've been backing up the DB for 2 years,
and it never needed more than 1 tape for it:
tsm: TSM>q db
Available Assigned Maximum Maximum Page Total Used Pct
Max.
Space Capacity Extension Reduction Size Usable Pages Util
Pct
(MB) (MB) (MB) (MB) (bytes) Pages
Util
--------- -------- --------- --------- ------- --------- --------- -----
-----
32,000 32,000 0 18,028 4,096 8,192,000 2,846,578 34.7
43.
Thanks!
On Fri, 25 Mar 2005, Mark D. Rodriguez wrote:
It would help if we could see the output of the following command:
q volh t=dbb
It might be that this is the most recent DB backup in which case it
won't let you delete it.
--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.
===============================================================================
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===============================================================================
Alexander Lazarevich wrote:
TSM 5.1.9.0 on win2K server.
I'm failing to delete the volume histories on the following volumes
(LTO-2 tapes):
tsm: TSM>q libv
Library Name Volume Name Status Owner Last Use Home
------------ ----------- ---------- ---------- --------- ----
LB6.0.0.3 ITG010L2 Private DbBackup 41
LB6.0.0.3 ITG033L2 Private DbBackup 64
LB6.0.0.3 ITG044L2 Private DbBackup 48
The command I run is:
tsm: TSM>del volhist type=dbbackup todate=today
Do you wish to proceed? (Yes (Y)/No (N)) yes
ANR2467I DELETE VOLHISTORY: 0 sequential volume history entries were
successfully deleted.
None of the dbbackup volumes are deleted though. Why? This has always
worked in the past. Anyone have any idea? Logs don't give any error:
ANR2017I Administrator DUDE issued command: DELETE VOLHISTORY
type=dbbackup todate=today
ANR2467I DELETE VOLHISTORY: 0 sequential volume history entries were
successfully deleted.
I need an answer fast as I've only got 1 scratch tape left because the
dbbackups keep stealing tapes. The database is only 14MB so it
should fit
on one tape easy. Thanks in advance,
Alex
|
|
|