ADSM-L

Expiration of DbBackup, Volhist and Libvolume status.

2001-04-24 14:42:27
Subject: Expiration of DbBackup, Volhist and Libvolume status.
From: "Talafous, John G." <Talafous AT TIMKEN DOT COM>
Date: Tue, 24 Apr 2001 14:43:09 -0400
I have been keeping two weeks worth of FULL database backups. The Volhist
expiration command shows nothing unusual. The command I use is 'del volhist
todate=today-15 type=dbb'. However when I query the 3494 library volume I
find 31 cartridges used for DBBackup. My Database is just below 40GB. Q DB
shows:
tsm: FSPHNSM1>q db f=d

          Available Space (MB): 39,760
        Assigned Capacity (MB): 39,760
        Maximum Extension (MB): 0
        Maximum Reduction (MB): 16,812
             Page Size (bytes): 4,096
            Total Usable Pages: 10,178,560
                    Used Pages: 5,865,312
                      Pct Util: 57.6
                 Max. Pct Util: 57.8
              Physical Volumes: 12
             Buffer Pool Pages: 16,384
         Total Buffer Requests: 27,301,611
                Cache Hit Pct.: 98.47
               Cache Wait Pct.: 0.00
           Backup in Progress?: No
    Type of Backup In Progress:
  Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 781.95
            Percentage Changed: 3.41
Last Complete Backup Date/Time: 04/24/2001 10:00:24

We have 3590-E1A cartridges and looking in the VOLHIST file I do not see the
full database backup taking two tapes at any time.

Now, the SQL statement 'select status, last_use, count(*) from libvolumes
group by last_use, status' shows:

STATUS         LAST_USE        Unnamed[3]
----------     ----------     -----------
Scratch                                41
Scratch                                41
Private        Data                   528
Private        DbBackup                31

Why don't I see something like 15 tapes in the DbBackup category?

John G. Talafous              IS Technical Principal
The Timken Company            Global Software Support
P.O. Box 6927                 Data Management
1835 Dueber Ave. S.W.         Phone: (330)-471-3390
Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
talafous AT timken DOT com           http://www.timken.com