Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005

    Unanswered: Used space increasing during reorg


    I am on DB29.7, fp6 using AIX 6.1, non dpf environment.
    History data has been loaded in a new database. The largest table is 800GB in size and is partitioned at table level. I am running a reorg on this table and all indexes from last 10 hours using resetdictionary. This has increased the used space from 72% before reorg to 97% till now. In db2diag, I see that 102
    Resetdictionary was tried because the data was not getting compressed though the Row compression was on. Probably the compression dictionary didn't built during data LOAD operation.

    I am worried that I will run out of space soon. Please advise on what is causing the usedspace to increase. Is it going to decrease once the operation is over? Is there any way to avoid the increase in usedspace?

    Current situation is, out of 141 partitions, 102 are done. Total 11 indexes on
    Commands used:
    Reorg table <tableName> resetdictionary;
    Reorg indexes all for table <tableName>;


  2. #2
    Join Date
    Nov 2011
    if you dont specific a temporary tablespace when reorging the table, db2 will use the tablespace which the old table locates in to build the new table , That will increase the tablespace used space.
    and if table is too large, you can reorg it once a data partition using “on data partition clause"。

  3. #3
    Join Date
    Jan 2009
    Zoetermeer, Holland
    Quote Originally Posted by praveen.db2 View Post
    Commands used:
    Reorg table <tableName> resetdictionary;
    Reorg indexes all for table <tableName>;
    The 2nd line is not required because you are already reorg-ing the table offline. This will take care of the indexes as well.
    And yes, LOAD compresses as well. During load you should see a message in db2diag that compression in starting. Did you verify that compression is set for that table by examing your db2look output?
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts