Running DB2 version 8.1.1 on AIX 5.1.1

The table (employee) is being reorged and has a clustering index (empid).

Is there any different between these two commands?

db2 reorg table employee index empid allow no access indexscan

db2 reorg table employee index empid allow no access

Thanks
Gerry

There is no functional difference in the result. If you use "indexscan", DB2 will use the index to retrieve the rows and avoid an external sort of the data.