Migration step 20: Rebuild indexes: DSNTIJRI (optional)
During migration to DB2® 10, some indexes are put in the advisory rebuild-pending state when columns are added to the index.
If
you are migrating from Version 8, the
following indexes might be affected:
- DSNADX01
- DSNAGX01
- DSNAPX01
- DSNATX01
- DSNAUX02
- DSNKAX01
- DSNKAX02
- DSNOAX01
- DSNOFX01
- DSNOFX02
- DSNOFX07
- DSNSKX01
- DSNWCX02
- DSNWCX03
- DSNXRX01
If
you are migrating from DB2 9, the following
index might be affected:
- DSNXRX01
To rebuild these indexes, run job DSNTIJRI.