Step 9: Drop unused history columns while upgrading

You can optionally drop unused history columns while upgrading between releases.

About this task

Note: If you set the yfs.apply.sql.manually property to Y in the <INSTALL_DIR>/Migration/9.5/buildmigration.properties file, you must manually apply the following DDLs before running the run-history-drop target and the run-transaction-drop target:
  • <INSTALL_DIR>/Migration/<previous version directory>/database/scripts/<dbtype>/history/drops.sql
  • <INSTALL_DIR>/Migration/<previous version directory>/database/scripts/<dbtype>/transaction/drops.sql
where <previous version directory> corresponds to the location of the previous version directory and <dbtype> corresponds to the database type (Db2 or Oracle).
  • To optionally drop the unused history columns while upgrading from 9.3, 9.4, or 9.5 to 10.0, run the following command:
    
    ${ANT_HOME}/bin/ant -Druntime=<INSTALL_DIR> -Druntime.old=<INSTALL_DIR_OLD>
     -f buildmigration.xml -logfile <logfile> -Dtarget=run-history-drop migrate
    

    The *.done file created in the 9.5 status folder for the run-history-drop task is history_ant_drops.xml.done.

  • To optionally drop the unused transaction columns while upgrading from 9.3, 9.4, or 9.5 to 10.0, run the following command:
    
    ${ANT_HOME}/bin/ant -Druntime=<INSTALL_DIR> -Druntime.old=<INSTALL_DIR_OLD>
     -f buildmigration.xml -logfile <logfile> -Dtarget=run-transaction-drop migrate
    

    The *.done file created in the 9.5 status folder for the run-transaction-drop task is transaction_ant_drops.xml.done.