Ibm data movement tool

English

Sign in (or register)

Technical topics

Evaluation software

Community

Events

Search developerWorks

developerWorks

Information Management

Technical library

IBM Data Movement Tool
Move data from source databases to DB2 in an easy way
Vikram S. Khatri, Certified Consulting I/T Specialist, IBM Summary: This article presents a very simple and powerful tool tomove data from various sources easily. The tool allows enabling applications from Oracle and Sybase to run on IBM® DB2®, Version 9.7 for Linux®, UNIX®, and Windows® as is, with very little or no changes. The tool can also be used to move data from various other database management systems to DB2 for Linux, UNIX, and Windows and DB2 for z/OS®. The tool also supports moving data from a sourcedatabase to the DB2 in a pureScale environment. Tags for this article: application_and_information_integration, application_development, data, databases, databases_and_data_management, db2, db2_data_movement_tool, db2_for_linux_and_unix_and_windows, from, ibm... more tags Tag this! Update My dW interests (Log in | What's this?) Date: 22 Nov 2010 (Published 19 Jun 2009) Level: Intermediate PDF: A4 andLetter (508KB | 28 pages) Get Adobe® Reader® Also available in: Russian Portuguese Spanish Activity: 34801 views Comments: 14 ( View | Add comment - Sign in) Average rating (37 votes) Rate this article

Introduction
This tool can be used to move data from various data sources to the DB2 in a pureScale environment. Beginning with DB2 V9.7 for Linux, UNIX, and Windows, the Migration Toolkit(MTK) is not required in order to use applications from Oracle and Sybase (After Fixpack 3) on DB2 products. This tool replaces the MTK functionality with a greatly simplified workflow. For all other scenarios, for example, moving data from a database to DB2 for z/OS, this tool supports the MTK particularly in the area of the high speed data movement. Using this tool, as much as 4TB of data havebeen moved in just three days. AGUI provides an easy to use interface for the novice while the command line API is often preferred by the advanced user.

Table of contents Introduction Preparation Extracting objects and data Deploying objects and loading data Plan for very large data movement Support for the tool Frequently asked questions Acknowledgements Disclaimer Download Resources Aboutthe author Comments

Preparation
Download
First, download the tool from the Download section to your target DB2 server. Additional steps are required to move data to DB2 for z/OS. (Check for the latest available version of the tool.)

Installation
Once you have downloaded the IBMDataMovementTool.zip file, extract the files into a directory called IBMDataMovementTool on your target DB2server. Aserver side install (on DB2) is strongly recommended to achieve the best data movement performance.

Next steps from IBM

Prerequisites
DB2 V9.7 should be installed on your target server if you are enabling an Oracle application to be run on DB2 for Linux, UNIX, and Windows. Java™ version 1.5 or higher must be installed on your target server. To verify your current Java version, runjava version command. By default, Java is installed as part of DB2 for Linux, UNIX, and Windows in \SQLLIB\java\jdk (Windows) or /opt/ibm/db2/V9.7/java/jdk (Linux). Table 1. Location of JDBC drivers for your source database and DB2
Database Oracle SQL Server Sybase MySQL PostgreSQL DB2 for Linux, UNIX, and Windows DB2 for z DB2 for i Teradatra MS Access JDBC drivers ojdbc5.jar or ojdbc6.jar orojdbc14.jar, xdb.jar, xmlparserv2.jar or classes12.jar or classes111.jar for Oracle 7 or 8i sqljdbc5.jar or sqljdbc.jar jconn3.jar and antsjconn2.jar for DB2 SKIN feature mysql-connector-java-5.0.8-bin.jar or latest driver postgresql-8.1-405.jdbc3.jar or latest driver db2jcc.jar, db2jcc_license_cu.jar or db2jcc4.jar, db2jcc4_license_cu.jar db2jcc.jar, db2jcc_license_cisuz.jar or db2jcc4.jar,...