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
<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 the9.5 status
folder for the run-history-drop task ishistory_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 the9.5 status
folder for the run-transaction-drop task istransaction_ant_drops.xml.done.