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

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

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.