check the volhist with :

      Q volhist type=backupset

Its there ....

BOY we finally solve the VOLHIST problems of DB Backups with DBSNAPSHOT
and now we're having similiar issues with BACKUPSETS!!!!!

... joe.f.


Joseph A Faracchio,  Systems Programmer, UC Berkeley


On Wed, 28 Feb 2001, Gill, Geoffrey L. wrote:

> I have one tape I tested creating a backupset. I've found the following:
>
> q libvol shows:
> 3494LIB        U00866        Private                   BackupSet
>
> q backupset
> ANR2034E QUERY BACKUPSET: No match found using this criteria.
>
> I wonder why this tape is still around when my test was only set to keep it
> for 5 days, it's been 2 weeks now since I created it. Do these expire
> automatically or do I need to do something else. Why did it ask how long to
> keep it if it didn't expire the tape automatically?
>
> My next question is how to get at the data in a backupset. When I created
> this backupset I was able to see it, but not as I expected. I used the gui
> and was expecting to be able to see the file/directory structure but could
> not. Isn't it possible to do this, what did I do wrong? If not what good is
> a backupset if I have to restore the whole thing when all I would probably
> want is a few files. I thought a backupset would be better on the database
> than an archive that's why the test.
>
> Thanks all for the help,
>
> Geoff Gill
> NT Systems Support Engineer
> SAIC
> Computer Systems Group
> E-Mail:   gillg AT saic DOT com
> Phone:  (858) 826-4062
> Pager:   (888) 997-9614
>