DEL volhist don't remove old DBINC - tsm 6.1.3

[alexmartraze]

tsm: TSMSERVER>delete volhist type=dbb todate=today totime=now
Do you wish to proceed? (Yes (Y)/No (N)) y
ANR2467I DELETE VOLHISTORY: 0 sequential volume history entries were
successfully deleted.

tsm: TSMSERVER>select substr(date_time,1,16),type from volhistory where type='BACKUPFULL' or type='BACKUPINCR' order by date_time

Unnamed[1] TYPE
----------------- ------------
2010-04-28 12:00 BACKUPINCR
2010-04-28 12:00 BACKUPINCR
2010-04-29 06:00 BACKUPINCR
2010-04-29 06:00 BACKUPINCR
2010-04-29 06:00 BACKUPINCR
2010-04-29 06:00 BACKUPINCR
2010-04-29 12:00 BACKUPINCR
2010-04-29 12:00 BACKUPINCR
2010-04-29 12:00 BACKUPINCR
2010-04-29 12:00 BACKUPINCR
2010-04-29 12:00 BACKUPINCR
2010-04-29 12:00 BACKUPINCR
2010-04-29 21:00 BACKUPINCR
2010-04-29 21:00 BACKUPINCR
2010-04-29 21:00 BACKUPINCR
2010-04-29 21:00 BACKUPINCR
2010-04-29 21:00 BACKUPINCR
2010-04-29 21:00 BACKUPINCR
2010-04-30 09:00 BACKUPINCR
2010-04-30 09:00 BACKUPINCR
2010-04-30 09:00 BACKUPINCR
2010-04-30 09:00 BACKUPINCR
2010-04-30 09:00 BACKUPINCR
2010-05-03 15:00 BACKUPINCR
2010-05-03 15:00 BACKUPINCR
2010-05-03 15:00 BACKUPINCR
2010-05-03 18:00 BACKUPINCR
2010-05-03 18:00 BACKUPINCR
2010-05-03 18:00 BACKUPINCR
2010-05-04 00:00 BACKUPINCR
2010-05-04 00:00 BACKUPINCR
2010-05-04 00:00 BACKUPINCR
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 07:34 BACKUPFULL
2010-05-13 09:00 BACKUPINCR
2010-05-13 09:00 BACKUPINCR


Any idea why BACKUPINCR from 2010-04-28 to 2010-05-04 still exist in volhistory?

 

[JeanSeb]

Please post the result of "q dbb f=d".

 

[alexmartraze]

IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 6, Release 2, Level 0.1
(c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved.
Session established with server TSMSERVER: Windows
Server Version 6, Release 1, Level 3.3
Server date/time: 2010-05-13 12:03:33 Last access: 2010-05-13 11:30:47

tsm: TSMSERVER>q dbb f=d
ANR4856I Command QUERY DBBACKUPTRIGGER is no longer supported. The following
commands provide similar functions: SET DBRECOVERY, QUERY DB. See the Tivoli
Storage Manager Information Center for details on commands, or issue HELP
command for the replacement commands.
tsm: TSMSERVER>q db f=d
Database Name: TSMDB1
Total Size of File System (MB): 572,138
Space Used by Database(MB): 255,072
Free Space Available (MB): 294,904
Total Pages: 16,872,452
Usable Pages: 16,872,316
Used Pages: 16,865,116
Free Pages: 7,200
Buffer Pool Hit Ratio: 99.8
Total Buffer Requests: 14,707,046,009
Sort Overflows: 0
Lock Escalation: 0
Package Cache Hit Ratio: 100.0
Last Database Reorganization:
Full Device Class Name: CLASSFILE_BKP
Incrementals Since Last Full: 1
Last Complete Backup Date/Time: 2010-05-13 09:00:26

tsm: TSMSERVER>


Thanks for your attention

 

[JeanSeb]

q dbb not q db

Edit: oups you got me there. Anyone more familiar with TSM 6 incremental DB implementation ?