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.

Start of change
Begin DB2 Version 8 to DB2 10 migration information
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
End DB2 Version 8 to DB2 10 migration information
End of change
Start of change
Begin DB2 9 to DB2 10 migration information
If you are migrating from DB2 9, the following index might be affected:
  • DSNXRX01
End DB2 9 migration information
End of change

To rebuild these indexes, run job DSNTIJRI.