ADSM-L

Database shrinking

1996-01-03 08:48:49
Subject: Database shrinking
From: "Michel.Gaillard" <Michel.Gaillard AT VZ.CIT.ALCATEL DOT FR>
Date: Wed, 3 Jan 1996 14:48:49 +0100
Hello there,

Let me first wish you an happy new year 1996 ,

We are in the process of spliting our main ADSM server into
several ones to have smaller databases.

In fact we are encountering big problems in the database consistency
and the only "clean" way was to start again all the backup activity
from scratch.

We are reinstalling ADSM V1R1 Level 0.15 on VM in 5 ADSM servers per site
(we have 2 big sites).

An AUDITDB takes much too long to fit in one of our week-end period
and we split the servers in order to be able to do that kind of
special operation if needed (and recently we did need a lot).

So the problem is stated and we are hence faced with a problem
of shrinking the existing databases (need to reuse disk space ..)

We used the DELETE DBVOL command (at least this command sounds
like it should do something interesting for us) and we got the
following message on a test ADSM server...

adsm> delete dbvol b02
ANR2434E DELETE DBVOLUME: Insufficient space on other database volumes to 
delete volume 0B02.

Apparently this command is first looking at the physical size of the DB volume 
and finds out
that there's not enough space on the remaining volume !!! That's true but the 
%Util is
much smaller than 50 % !!



adsm> q db

Available     Assigned       Maximum       Maximum        Page         Total    
      Used     %Util      Max.
    Space     Capacity     Extension     Reduction        Size        Usable    
     Pages               %Util
     (MB)         (MB)          (MB)          (MB)     (bytes)         Pages
---------     --------     ---------     ---------     -------     ---------    
 ---------     -----     -----
       96           96             0            88       4,096        24,576    
     1,762       7.2       7.2
       96           96             0            88       4,096        24,576    
     1,762       7.2       7.2
adsm> q dbvol f=d

Volume Name        Copy     Volume Name        Copy     Volume Name        Copy 
    Available   Allocated       Free
(Copy 1)           Status   (Copy 2)           Status   (Copy 3)           
Status       Space       Space      Space
                                                                                
         (MB)        (MB)       (MB)
----------------   ------   ----------------   ------   ----------------   
------   ---------   ---------   --------
0B01               Sync'd                      Undef-                      
Undef-          48          48          0
0B01               Sync'd                      Undef-                      
Undef-          48          48          0
                                                ined                        ined
0B02               Sync'd                      Undef-                      
Undef-          48          48          0
                                                ined                        ined



Can someone explain the logic of the DELETE DBVOL command and eventually give 
me any trick to solve
my problem ?

TIA , Michel


--
Michel Gaillard
Michel Gaillard
DSI/DPI
Alcatel CIT Velizy France
E-Mail: Michel.Gaillard AT vz.cit.alcatel DOT fr
Voice : (33.1) 30 67 32 56
<Prev in Thread] Current Thread [Next in Thread>