V9.5 and V9.7 on AIX. I dont see anything in Info center that
restricts inserting or deleting during online, inplace REORG WITH
WRITE ACCESS but want to makes sure I am not missing anything. I hit
an issue with some records that were just inserted into a table that
was in the middle of a reorg and there was an error when an update
come through to modify those records. So, I want to eliminate that as
a possible factor.

Thanks

"shorti" <lbryan21 (AT) juno (DOT) com> wrote

I don't know if this was a factor in the situation you encountered, but you
should look at using the NOTRUNCATE option to avoid lock contention during
inplace reorgs. This is not the default, but failure to use it can
definitely cause lock contention problems.