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