Hi friends,

As far as i know no read access and no write access are allowed when we do a reorg online(inplace).

But I saw the following statement in a db2 book which contradicts the above statement

reorg table db2user.employee index db2user.idxemp inplace allow write access


Does db2 allow connections on the table if it is online reorg..If it does not allow what is the usage of online reorg,We can as well use offline reorgs.
Please clarify.

Why do you think that access is not allowed while a table is being reorganized? That's the whole point of online-reorg. First hit when searching for "reorg table" in the DB2 manual says:
http://publib.boulder.ibm.com/infoce...c/t0024775.htm

If you do a reorg with the INPLACE option, then the default is ALLOW WRITE ACCESS. You can change that to ALLOW READ ACCESS, which means that DB2 wouldn't have to worry about data changes during the reorg. http://publib.boulder.ibm.com/infoce...c/r0001966.htm

p.s: I guess you are working on DB2 for Linux, Unix, and Windows?