Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    4

    Unanswered: A reorg on a table will also affect other tables in the tablespace? UNIX

    I am about to perform a reorg on a table which it is in a tablespace with several other tables.
    Will it affect the other tables in the tablespace?, or if I enter the command:

    db2 "reorg table DB2INST1.tab1"

    Does it affect other tables in the tablespace? or should be OK.

    ALso it has 1 index, it will also reorg the index?.

    I worked with Mainframe before, so UNIX is new to me on those commands. DB2 V9 Unix AIX64 9.7.5

    Help......

  2. #2
    Join Date
    Aug 2008
    Posts
    147
    It will only run the REORG on that table. There is a slight performance hit , while the reorg is running
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  3. #3
    Join Date
    Apr 2008
    Posts
    39
    if you are planning to reorg the table as you mentioned in the command then separate reorg for index is not require.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Quote Originally Posted by opcamp View Post
    db2 "reorg table DB2INST1.tab1"

    Does it affect other tables in the tablespace? or should be OK.
    Data and index (if different from data) / temporary (if used) tablespaces will be in reorg-in-progress state. It won't prevent you from accessing other tables in this tablespace. This state may conflict with some other utilities (online backup?) - InfoCenter seems be to unavailable at the moment - can't verify.

Posting Permissions

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