EXAMPLE file for DB migration from Oracle to DB2

THIS File is at use at your own risk
Please ensure that paths to the correct SCRIPTS, DB DRIVERS, PASSWORDS etc. are changed before attempted to use this example

These steps worked for me, but may not be correct for you - CHECK with IBM and the PMR that you have before running

Sharon Bellamy James - 25th November 2016


== People/ Profiles ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\profiles\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\people.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\profiles\db2

db2 -td@ -vf postdbxfer50.sql

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql



== Dogear ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\dogear\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\dogear.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V55\connections.sql\dogear\db2

db2 -td@ -vf postdbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\dogear\db2

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql



== Forum ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\forum\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

cd C:\InstallTemp\Connections\V5\CR3\50cr3-database-updates\50cr3-database-updates\From-50\db2\

db2 -td@ -vf 50-CR1-forums-db2.sql

cd C:\InstallTemp\Connections\V55\connections.sql\forum\db2

db2 -tvf predbxfer50CR1.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\forum.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V55\connections.sql\forum\db2

db2 -tvf postdbxfer50CR1.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\forum\db2

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql




== Metrics ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\metrics\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

cd C:\InstallTemp\Connections\V55\connections.sql\metrics\db2

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\metrics.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V55\connections.sql\metrics\db2

db2 -td@ -vf postdbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\metrics\db2

db2 -td@ -vf reorg.sql
db2 -td@ -vf updateStats.sql


== Mobile ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\mobile\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\mobile.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\mobile\db2

db2 -td@ -vf postdbxfer50.sql

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql


== Communities / Calendar ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\communities\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf calendar-dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql
db2 -td@ -vf calendar-createDb.sql
db2 -td@ -vf calendar-appGrants.sql

cd C:\InstallTemp\Connections\V5\CR3\50cr3-database-updates\50cr3-database-updates\From-50\db2\

db2 -td@ -vf 50-CR1-calendar-db2.sql
db2 -td@ -vf 50CR1-50CR2-communities-db2.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\communities\db2

db2 -td@ -vf predbxfer50.sql

db2 -td@ -vf calendar-predbxfer50.sql


cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\sncomm.xml -sourcepassword sourcepassword -targetpassword targetpassword

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\sncommcal.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\communities\db2

db2 -td@ -vf postdbxfer50.sql
db2 -td@ -vf calendar-postdbxfer50.sql

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql

db2 -td@ -vf calendar-reorg.sql
db2 -td@ -vf calendar-runstats.sql


== Activities ==

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\activities\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

cd C:\InstallTemp\Connections\V5\CR3\50cr3-database-updates\50cr3-database-updates\From-50\db2\

db2 -td@ -vf 50-CR1-activities-db2.sql

cd C:\InstallTemp\Connections\V55\connections.sql\activities\db2

db2 -tvf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\activities.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V55\connections.sql\activities\db2

db2 -tvf postdbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\activities\db2

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql

DONE


== HOMEPAGE == 

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\homepage\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql
db2 -td@ -vf initData.sql

db2 -td@ -vf reorg.sql
db2 -td@ -vf updateStats.sql

cd C:\InstallTemp\Connections\V5\CR3\50cr3-database-updates\50cr3-database-updates\From-50\db2\

db2 -td@ -vf 50-CR1-homepage-db2.sql
db2 -td@ -vf 50-CR1-homepage-appGrants-db2.sql
db2 -td@ -vf 50CR1-50CR2-homepage-db2.sql
db2 -td@ -vf 50CR2-50CR3-homepage-db2.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\homepage\db2

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\homepage.xml -sourcepassword sourcepassword -targetpassword targetpassword


cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\homepage\db2

db2 -td@ -vf postdbxfer50.sql


db2 -td@ -vf reorg.sql
db2 -td@ -vf updateStats.sql




== Wikis == 

db2 force application all

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\wikis\db2

db2 -td@ -vf dropDb.sql 
db2 -td@ -vf createDb.sql 
db2 -td@ -vf appGrants.sql

db2 -td@ -vf predbxfer50.sql 

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\wikis.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\wikis\db2

db2 -td@ -vf WikisFixup.sql 
db2 -td@ -vf postdbxfer50.sql 

db2 -td@ -vf reorg.sql
db2 -td@ -vf updateStats.sql

== Blogs ==  

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\blogs\db2

db2 -td@ -vf dropDb.sql
db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql

cd C:\InstallTemp\Connections\V5\CR3\50cr3-database-updates\50cr3-database-updates\From-50\db2\

db2 -td@ -vf 50-CR1-blogs-db2.sql
db2 -td@ -vf 50CR1-50CR2-blogs-db2.sql 

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\blogs\db2

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\blogs.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\blogs\db2

db2 -td@ -vf BlogsFixup.sql
db2 -td@ -vf postdbxfer50.sql

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql


== Files == 

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\files\db2

db2 -td@ -vf pns-dropDb.sql
db2 -td@ -vf dropDb.sql

db2 -td@ -vf createDb.sql
db2 -td@ -vf appGrants.sql
db2 -td@ -vf pns-createDb.sql
db2 -td@ -vf pns-appGrants.sql

cd C:\InstallTemp\Connections\V5\CR3\50cr3-database-updates\50cr3-database-updates\From-50\db2\

db2 -td@ -vf 50-CR1-files-db2.sql

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\files\db2

db2 -td@ -vf predbxfer50.sql

cd C:\InstallTemp\Connections\V5\Wizards\jvm\win\jre\bin

java -cp D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\dbt.jar;D:\IBM\Oracle\ojdbc6.jar;D:\IBM\SQLLIB\java\db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\logs -xmlfile D:\IBM\Connections\ConfigEngine\lib\DBT_HOME\files\files.xml -sourcepassword sourcepassword -targetpassword targetpassword

cd C:\InstallTemp\Connections\V5\Wizards\connections.sql\files\db2

db2 -td@ -vf FilesFixup.sql

cd C:\InstallTemp\Connections\V55\connections.sql\files\db2

db2 -td@ -vf postdbxfer50.sql

db2 -td@ -vf reorg.sql
db2 -td@ -vf updateStats.sql