The following procedure describes how to use DBLoader to update the database tables for your upgraded version:
{INSTALL DIR}/DBLoader/_uninst/uninstall
{CD_ROM/MEDIA DIR}/DBLoader/setup*
Follow the guidelines below:
DB2
Run the following commands:
db2 -td! -f BCGUpgrade_420_421.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_420_421.log
db2 -td! -f BCGUpgrade_421_421FP1.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_421_421FP1.log
db2 -td! -f BCGUpgrade_421FP1_422.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_421FP1_422.log
db2 -td! -f BCGUpgrade_422_422FP2.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_422_422FP2.log
db2 -td! -f BCGUpgrade_422FP2_422FP3.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_422FP2_422FP3.log
db2 -td! -f BCGUpgrade_422FP3_422FP4.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_422FP3_422FP4.log
db2 -td! -f BCGUpgrade_422FP4_600.sql -z /tmp/bcgdbloader/logs/BCGUpgrade_422FP4_600.log
db2 -td! -f save_inputs.sql -z /tmp/bcgdbloader/logs/save_inputs.log
db2 -td! -vf Set_Grants.sql >/tmp/bcgdbloader/logs/Set_Grants.log
Oracle
Run the following commands:
sqlplus -L bcgapps/password @BCGUpgrade_421_421FP1.sql >/tmp/bcgdbloader/logs/BCGUpgrade_421_421FP1.log
sqlplus -L bcgapps/password @BCGUpgrade_421FP1_422.sql >/tmp/bcgdbloader/logs/BCGUpgrade_421FP1_422.log
sqlplus -L bcgapps/password @BCGUpgrade_422_422FP2.sql >/tmp/bcgdbloader/logs/BCGUpgrade_422_422FP2.log
sqlplus -L bcgapps/password @BCGUpgrade_422FP2_422FP3.sql >/tmp/bcgdbloader/logs/BCGUpgrade_422FP2_422FP3.log
sqlplus -L bcgapps/password @BCGUpgrade_422FP3_422FP4.sql >/tmp/bcgdbloader/logs/BCGUpgrade_422FP3_422FP4.log
sqlplus -L bcgapps/password @BCGUpgrade_422FP4_600.sql >/tmp/bcgdbloader/logs/BCGUpgrade_422FP4_600.log
sqlplus -L bcgapps/password @save_inputs.sql >/tmp/bcgdbloader/logs/save_inputs.log
sqlplus -L bcgapps/password @Grants_Syns.sql >/tmp/bcgdbloader/logs/ Grants_Syns.log