If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > After Reorg , More Space Utilized !!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-11-07, 02:23
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
After Reorg , More Space Utilized !!

i have done a backup on a databse 3 days ago and the size of the backup image was 4.93 GB. However yesteday i scheduled it for reorg on tables and indexes after the results of
reorgchk_tb_stats('S','EONE')
reorgchk_ix_stats('S','EONE')
i used following commands :

Reorg table eone.tabname;
Reorg indexes all for table eone.tabname;

However To my surprise the backup image of today is 6.14 GB. In the meantime no work was performed on that database.
How does reorg is increasing the size of image when the main purpose of reorg is to recover the wasted space.

--Rahul Singh
Reply With Quote
  #2 (permalink)  
Old 01-11-07, 11:44
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
One of the purposes of a reorg is reclaim wasted space, but there are other purposes also.

A reorg restores percent free on the table and indexes. The default is 10% free unless you change it.

The purpose of percent free is to allow space for maintaining the correct order in the rows in the table when an insert takes place, according to the clustering index. If you don't have a clustering index, or the table is defined with append option (to always insert new rows at the end) then you could set percent free to zero on the table.

Percent free on indexes is more complicated since indexes always need to be in the exact order specified. However, if you had an index on a timestamp column and the value always had the current timestamp on insert, then you might be better off with percent free zero on such an index.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 01-12-07, 09:41
dbamota dbamota is offline
Registered User
 
Join Date: Sep 2003
Posts: 237
A better measure of REORG is to see how many free pages and used pages there are before and after the REORG. I am guessing backup copies each tablespace upto the Highwater mark; since you used the same tablespace for reorg, I wonder if that pushed up the Highwater mark!
__________________
mota
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On