Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    45

    Unanswered: REORG INDEX and TABLE

    Hi, all

    I'm currently exploring the REORG function in DB2. I know that REORG TABLE process will duplicate the table to SYS temporary tablespace or user-defined tablespace, before doing the reorganization, but I don't know what happens for index. Will there be index replication before the reorganization ???

    And, actually, does anyone knows how the reorganization works ? I mean, in the terms of data movement and such

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    what is your version of DB2 and operating system name and version? What kind of tablespaces are you using SMS or DMS? SMS is using "movement" and DMS does not.
    Regards,
    Grofaty

  3. #3
    Join Date
    Aug 2008
    Posts
    45
    Hi, thank you for the reply. I'm using Linux Redhat 4 and the current DB2 I'm using is DB2 UDB 8.2.

    And I'm actually using the default tablespace, I don't know which one, since DB2 UDB, I think probably SMS.

Posting Permissions

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