Results 1 to 5 of 5

Thread: Urgent

  1. #1
    Join Date
    Oct 2009
    Posts
    6

    Unanswered: Urgent

    Is it possible to restore the backup of DB2 Ver 9.5 in to DB2 Ver 9.1

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    No, you can't:
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows


    "The target system must have the same (or later) version of the DB2 database product as the source system. You cannot restore a backup created on one version of the database product to a system running an earlier version of the database product. For example, you can restore a DB2 UDB V8 backup on a DB2 V9 database system, but you cannot restore a DB2 V9 backup on a DB2 UDB V8 database system."

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    db2move is the option left
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    other way is
    1) db2 -x "select 'EXPORT TO SCHNAME.'||TABNAME||'.IXF OF IXF SELECT * FROM SCHNAME.'||TABNAME||';' from syscat.tables where tabschema = 'SCHNAME' and TYPE = 'T' " > export.sql
    2) db2 -x "select 'IMPORT FROM SCHNAME.'||TABNAME||'.IXF OF IXF CREATE INTO SCHNAME.'||TABNAME||';' from syscat.tables where tabschema = 'SCHNAME' AND TYPE = 'T' " > import.sql

    export.sql > export.txt in the newer version of db
    import.sql > import.txt in the older version of db
    regds
    Paul

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Unless you have a small database, you better have a COMMITCOUNT in the those import statements.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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