Hello all,
I am in the process of finding out why some of the DATA on my tapes
are not expiring. I have been learning a lot doing this but it is time
consuming (surprised right?). Anyway to just correct some past injustices I
deleted most of the tapes that I know should not hold valid DATA based on
their date last written to. The DELETE VOL=xxxxxxx DISCARD=YES appeared to
work well. It brought me back the tapes from 6 months ago, and sent all the
COPYPOOL tapes that were associated with the discarded data to the desired
PENDING status. All seems well so far. I start focusing on tapes that I
know should not have data that I did not delete. I did a
SELECT * from backups where backup_date < '2001-04-02' . The results
should have shown data that was backed up on
2001-04-01. BUT THERE IS A LOT OF DATA THAT WAS BACKED UP ALL THE WAY BACK
TO 2000-12-xx.
What is going on here? Why is the data there? Shouldn't it have been
expired and the DB cleaned up? Is there a process I should be running to
clean this UP?
Any help would greatly be appreciated.
Matt
