Migrating DB2 content side by side

<dbTransfer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database role="source" 
driver="JDBC_driver" 
url="JDBC_url" 
userId="database_admin
schema="application_db_schema_name"
dbType="dbType"/>
<database role="target"
driver="JDBC_driver"
url="JDBC_url"
userId="database_admin" 
schema="application_db_schema_name" 
dbType="dbType"/>
<table sourceName="TABLE_TO_SKIP" exclude="true"/> <!-- optional argument
 used to have dbtransfer skip a table -->
</dbTransfer>

Where

database_admin is the user ID of the database administrator.

• Use the JDBC driver on the target database server.

• Linux™:

  "JAVA_HOME/bin/java"

  -cp DBT_HOME/dbt.jar:

  DB2_HOME/java/db2jcc4.jar

  Where DB2_HOME is IBM\connections\IBM\SQLLIB\java\

  com.ibm.wps.config.db.transfer.CmdLineTransfer

  -logDir DBT_HOME/logs

  -xmlfile DBT_HOME/dbt_config_file_name

  -sourcepassword source_db_password

  -targetpassword target_db_password

  Where

  • JAVA_HOME is the path to the Java™ JDK:
    opt/IBM/WebSphere/AppServer/java/jre
  • dbt_config_file_name is the name of the XML configuration file you created for the dbt.jar file
  • logs is the directory where log files are stored. Create the logs directory before you run this file
  • DB2_HOME is the path to the DB2® installation directory.

  Run the command on a single line; do not add extra spaces. For example, multiple file names are entered as filename.jar:filename.jar without a space between the file names. The command looks similar to the following when run as a single command (edited to your specific configuration):

  JAVA_HOME/bin/java -cp DBT_HOME/dbt.jar:DB2_HOME/java/db2jcc4.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir DBT_HOME/logs -xmlfile DBT_HOME/dbt_config_file_name -sourcepassword password -targetpassword password

• Windows™:

  JAVA_HOME\bin\java

  -cp DBT_HOME\dbt.jar;

  DB2_HOME\java\db2jcc4.jar

  com.ibm.wps.config.db.transfer.CmdLineTransfer

  -logDir DBT_HOME\logs

  -xmlfile DBT_HOME/dbt_config_file_name

  -sourcepassword source_db_password

  -targetpassword target_db_password

  Where

  • JAVA_HOME is the path to the Java™ JDK.
    Wizards\jvm\win\jre\bin\java
  • dbt_config_file_name is the name of the XML configuration file you created for the dbt.jar file
  • logs is the directory where log files are stored. Create the logs directory before you run this file
  • DB2_HOME is the path to the DB2® installation directory.

  Run the command on a single line; do not add extra spaces. For example, multiple file names are entered as filename.jar;filename.jar without a space between the file names. The command looks similar to the following when run as a single command (edited to your specific configuration):

  JAVA_HOME\bin\java -cp c:\DBT_HOME\dbt.jar;DB2_HOME\db2jcc4.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir c:\DBT_HOME\logs -xmlfile c:\DBT_HOME\dbt_config_file_name -sourcepassword password -targetpassword password

When the transfer is complete, you can restart your 5.0 or 5.5 source deployment to minimize service downtime.