Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Move database to different platform

    I would like to move a DB2 UDB ESE V8 database on AIX to DB2 UDB ESE V8 on LINUX. Has anyone done this and is it via a db2 backup with
    a db2 redirected restore? Also does anyone have any benchmarks for DB2 on AIX vs DB2 on LINUX.
    Thank you ,
    Sandy

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Move database to different platform

    This is a very frequently asked question ...

    In www.db2click.com in the links page, search for FAQ and you will find a list ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    I am not , one platform DB backup with work other flatform.


    but you can use db2look & DB2 export & load utilities,

    but based on you DB size ,data volumns ( if any lob/clob)

    db2look -l -x -e -o outputfile

    above statement will take DDL from you DB ( before that check your APP_CTL_HEAP_SZ Db parm ,)

    generate

    export & load scripts from system catalogs , ftp .IXF file load scripts to target DB Server.


    -Lekharaju Ennam

Posting Permissions

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