Re: Reorg/Pct used Question

Michael R. Peterson wrote:
>
> I have a question/clarification regarding table reorgs and the storage
> clause Pct Used. When performing a table reorg, all extents are put into
> one extent. But do blocks that are still above the Pct Used get written
> to during the reorg? Or do the blocks remain the same and only the
> extents reorged into one?
>
> -Thanks
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Michael R. Peterson BASIS Support Team - UNIX
> mpeter_at_ecst.csuchico.edu College of Business SAP R/3
> http://www.ecst.csuchico.edu/~mpeter California State University, Chico
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

I know of no utility or method that would do a block to block copy. So with that in mind, you are doing row by row inserts into new datablocks
which will continue for a given block until the percent used value is reached.

                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo


"The secret to creativity is knowing how to hide your sources."
                       Albert Einstein