Is it required to regenerate the reorg scripts after upgrading?
When a new release of Space Manager is distributed, the suggested practice should be to re-create reorg scripts. Because the space and size checks occur at script generation time, it is always suggested that reorg scripts be generated as close to (shortly before) reorg time as appropriate. This practice is also suggested to avoid issues with DDL changes.
There were a couple of scripting changes implemented in 6.2 - how indexes are handled [CR 206469] and quoting of certain reserved words [CR 207639]. Also, standard reorg “Alter Table Move” scripts from 6.0.1 should be recreated [CR 211684] due to a correction in handling of security policies.
While we do not prevent scripts generated with SPC 6.0.1 from running in QSA 6.2 and it is not required to regenerate the reorg scripts, recreating them is suggested, especially if the changes listed above effect your database.
