DB2 Basics: What is a Reorg?

You may also like...

10 Responses

  1. Great article Ember!! Thanks for sharing your insights on the topic. Here is one more good article on REORG with all of its phases and scope for tuning them.


  2. Stefano says:


    Altering a column to remove NOT NULL

    this also requires a Reorg!

  3. Rajesh says:

    TABLE A has 2 indexes.
    While doing offline reorg on TABLE A the 4th phase is “RECREATE ALL INDEXES”.
    Question : so “RECREATE ALL INDEXES” is same as “reorg indexes all for table A” ?
    Or do I need to to index reorg separately after the offline table reorg?

    • Ember Crooks says:

      Index reorgs are included in offline reorgs. You only need to explicitly do them after online reorgs.

  4. Robelis says:


    In case of a huge table that must need be reorganized, but is taking long time to complete, do you have a idea what to do or do another action enstead of perfrom the reorg?


    • Ember Crooks says:

      There are a couple of options. The table can be partitioned, and then the partitions reorganized independently. However, I believe that partition reorgs are only classic (offline) at this point. I think they’ve said that inplace partition reorgs are possible on DB2 11.1, which is coming out next week. You can also use admin_move_table (which has some restrictions on 9.7 and early fixpacks of 10.1) to move the table, thereby reorging it at the same time in a largely online manner. Also, classic(offline) reorgs that do not cluster on an index use the least time.

  1. June 2, 2014

    […] maintenance and maintaining how much disk space is used. In my first blog entry in this series, DB2 Basics: What is a Reorg, I talked about some purposes of reorgs. In this entry, I’m going to talk about how to […]

  2. April 7, 2017

    […] If you want a list of operations in DB2 that can cause REORG_PENDING state, please read: DB2 Basics: What is a Reorg. […]

Leave a Reply

Your email address will not be published. Required fields are marked *