Running reorg rebuild indexname on a large table may take a long time. Periodic status messages appear; starting and ending messages are written to the error log and to the client process that is executing reorg. In-progress messages appear only on the client.
A status reporting interval is calculated as either 10 percent of the pages to be processed or 10,000 pages, whichever is larger. When this number of pages is processed, a status message prints. Therefore, no more than 10 messages are printed, regardless of the size of the index. Status messages for existing reorg commands print more frequently.