ADSM-L

Reduce database size

1999-01-05 08:21:53
Subject: Reduce database size
From: Eric Tang <tangeric AT HK1.IBM DOT COM>
Date: Tue, 5 Jan 1999 21:21:53 +0800
Hi all,

To migrate some nodes to from a v2 server to a new v3 server, database is
backup from v2 server and restore to v3 server, and delete filespace on
those nodes on new server that are not going to be migrated.

Allocated database size in v2 server is 11092MB, and below is "q db" on the
new server after del filespace.

adsm> q db

Available Assigned   Maximum   Maximum    Page     Total      Used   Pct
Max.
    Space Capacity Extension Reduction    Size    Usable     Pages  Util
Pct
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages
Util
--------- -------- --------- --------- ------- --------- --------- ----- --
---
---
   13,284   11,092     2,192     2,060   4,096 2,839,552   215,244   7.6
   13,284   11,092     2,192     2,060   4,096 2,839,552   215,244   7.6
7.6


'Reduce db' can only reduce db size by 2060M, is there any other way to
reduce the db size?
I have tried backup, dsmserv install log & database then restore, but
result is the same.


Regards,
Eric Tang
<Prev in Thread] Current Thread [Next in Thread>