DB2® : updating si_version table

About this task

The si_install_date column has been changed from a VARCHAR column to a timestamp. To update the si_version table, perform the following activities.

When migrating from 8.0 to 9.4, follow these steps:

Procedure

  1. Run the initupgrade task and then remove the alters generated for the si_version table from the following directory:
    <INSTALL_DIR>/Migration/9.3/database/scripts/db2/transaction/alters.sql
  2. Drop the si_version table from the database.
  3. After running the transaction alters, run the dbverify script. To prevent dbverify from generating "IndexAdds" SQLs for dropped indexes, ensure that the dropped indexes are listed in the <INSTALL_DIR>/extensions/schemagenerator/indexes_not_created.txt file. Or, if the INDEXES_NOT_CREATED property in the <INSTALL_DIR>/properties/sandbox.cfg file is configured, add the list of dropped indexes to the file referenced by the property.
  4. Execute the SQLs generated by the dbverify script in your database.