About this task
Note: If you set the
yfs.apply.sql.manually property
to Y in the
<INSTALL_DIR>/Migration/9.3/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 8.0, 8.2, 8.5, 9.0, 9.1, 9.2, 9.2.1 or 9.3 to 9.4,
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.3 status folder for the run-history-drop
task is history_ant_drops.xml.done.
- To optionally drop the unused transaction columns
while upgrading from 8.0, 8.2, 8.5, 9.0, 9.1, 9.2, 9.2.1 or 9.3 to
9.4, 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.3 status folder for the run-transaction-drop
task is transaction_ant_drops.xml.done.