Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    5

    Smile Unanswered: how to transfer database from DB2 8.1 to DB2 7.1

    Because it have large capacity with 3G and 600 tables, it is difficult for me to transfer the data to a lower version datablase.
    How can I do?

  2. #2
    Join Date
    Apr 2003
    Location
    Florida
    Posts
    79
    Can DB2 v7.1 load or import IXF formatted files? If so, I was able to Export a 17g file (and several other smaller files) from mainframe and Import into DB2 v8...

    You may be able to use a query against the db2 v8 sys catalog to build all 600 export/Import statements (including commits after each).

    Logging may get you - not sure there.

    The best of luck to you in your endevour -
    Rick

  3. #3
    Join Date
    Apr 2003
    Posts
    5

    Talking

    thank u very much
    I succeeded in transfering data by db2move commond.

Posting Permissions

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