Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    11

    Question Unanswered: Migration from oracle to db2?

    Happy New Year

    I have an application ready with db oracle but I also need this application to be set with db2. How to export tables & its data from oracle to db with ease? I surf the net but not written in easy way.

    Looking forward for a early reply

    Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    456
    Take a look at this link:

    http://www-128.ibm.com/developerwork...igrate/db.html

    and enjoy a happy new year!

    Paul

  3. #3
    Join Date
    Nov 2004
    Posts
    11
    Happy New Year Paul

    I tried IBM toolkit but looks like it doesn't support db2 ver 7.1 because can't get oracle connection mssg is displayed. where can I find toolkit on IBM site where it supports db2 ver 7.1.

    Looking forward for an early reply.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    DB2 V7 is no longer supported by IBM. V9 is due out in mid 2006, but V8.2 will still be supported for a few years.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2004
    Posts
    11
    Hello

    while migrating I got this exception.

    class com.ibm.db2.jcc.b.SqlException while getting the table names : DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSSH200

    What does it means?

  6. #6
    Join Date
    Apr 2005
    Posts
    41
    Sounds like either you have an issue with the Versions of DB2 (which you mentioned ealrier in the posting), or else you need to do some re-binds...as follows (assuming you are on v8.2):

    db2 bind @db2ubind.lst blocking all grant public
    db2 bind @db2cli.lst blocking all grant public
    db2 bind db2schema.bnd blocking all sqlerror continue messages cli.msg

    Graham Martin
    http://www.ibm.com/software/data/db2/migration/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •