Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    66

    Unanswered: Online Reorg And Write Access

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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:
    An online or inplace table reorganization allows users to access the table while it is being reorganized.
    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?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •