[ADSM-L] Does a DB2 db ever shrink?
2015-11-17 10:56:56
Hi,
On one of our TSM v6.3.5 databases we deleted two nodes which totaled 65m
files. After doing this we haven't seen any shrinkage in the database size.
date #FilesInDb DbGB
11/01/2015 504786214 701785
11/08/2015 436723183 701676 <= -65m files gone!
11/17/2015 436456172 702185
The free db2 blocks (today) is 12,944.
By deleting the two nodes we dropped the number files by 65m files. But the
database itself hasn't changed in size (filesystem size) or free blocks inside
the db. The db2 is set to auto-reorg (the default).
Q) Why wouldn't our db2 db shrink, or, have gobs of free db2 blocks?
Thanks
Rick
-----------------------------------------
The information contained in this message is intended only for the personal and
confidential use of the recipient(s) named above. If the reader of this message
is not the intended recipient or an agent responsible for delivering it to the
intended recipient, you are hereby notified that you have received this
document in error and that any review, dissemination, distribution, or copying
of this message is strictly prohibited. If you have received this communication
in error, please notify us immediately, and delete the original message.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] Does a DB2 db ever shrink?,
Rhodes, Richard L. <=
|
|
|