OLREORG (Reorganize a Database Online) › OLREORG › Sample Report

Sample Report

For sample REFGROUP reports, see Sample Report: REFGROUP Summary. An example of the summary report generated by executing the OLREORG function against a table containing 3,000 rows follows:

  Rows processed -                  3,000   Œ
 
  Rows moved -                        384   
 
  Blocks freed in reference group -   129   Ž
 
  Exclusive control conflicts -         0   

Œ

Rows processed is the total rows in the table, or if using FIRSTKEY or LASTKEY, the total rows within the specified key range.



Rows moved is the total rows moved from less heavily populated blocks within a reference group to more heavily populated blocks.

Ž

The number printed for the blocks freed in reference group is not an absolute number, but must be understood as being relative to the reference group concept. That is, at the start of processing each reference group uses the same number of blocks specified by the REFGROUP parameter. After the OLREORG is run, the same set of rows for each REFGROUP may be in fewer blocks. A block freed in a reference group represents the difference in the number of blocks required to hold each reference group. Because each actual physical block may contain rows from multiple REFGROUPs, the number printed in the report does not therefore necessarily represent completely empty blocks, that is, a block freed is not necessarily the same as an empty block.



Exclusive control conflicts refers to the following. Applications are allowed to maintain rows in the specified table while OLREORG is running. The number printed in the report represents rows that OLREORG chose for movement but skipped because some other task currently had either primary or secondary exclusive control on the row. These rows are skipped for performance reasons.