Results 1 to 15 of 15
  1. #1
    Join Date
    Oct 2013
    Posts
    39

    Unanswered: DB2 Database migration

    Hi
    I want take a backup of a DB in DB2 V9.1 LUW and wants to restore it in V9.7.5 LUW. Is it possible? if yes, then what could be the steps to fo it.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Oct 2013
    Posts
    39
    Hi przytula_guy, Am not able to find the solution of my problem in the link which you have mentioned.
    My Problem is:

    1.there is one server. one instance(say db2inst1) is running in DB2 v9.1 and other instance(say db2inst2) is running in DB2 v9.7.5.
    2. under both instance certain number of DB's are running.
    3. So i have to migrate one DB say 'abc' from db2inst1 to db2inst2.

    So could anyone suggest me a best way to do it?

    Thanks in advance.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    just : db2 restore db abc .....
    RESTORE DATABASE - IBM DB2 9.7 for Linux, UNIX, and Windows
    if you want me to come over to type the command.. nop
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    You need a redirected restore.
    You may start reading from here: IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  6. #6
    Join Date
    Oct 2013
    Posts
    39
    Thanks for your reply. But I didn't forced you to reply and never asked you to come over here to type the command, if you have more knowledge then me its good for you, so please keep your attitude with you. BTW i know where is restore command available in IBM site. Next time show your attitude when u share something helpful.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    "You need a redirected restore." : not always.. it depends....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  8. #8
    Join Date
    Oct 2013
    Posts
    39
    Quote Originally Posted by aflorin27 View Post
    You need a redirected restore.
    You may start reading from here: IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    Hi Aflorin/przytula_guy,
    I did the redirected restore..but while executing the below command(which is a part of redirect restore):

    RESTORE DATABASE <dbname> CONTINUE;

    I got the below error:

    restore was successful but db didn't upgraded to current release.

    Any suggestion y this error came.

  9. #9
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    db2 upgrade/Migrate db xxx
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  10. #10
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the message (sql2519n I presume) there should be an indication why not upgraded ..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  11. #11
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Quote Originally Posted by przytula_guy View Post
    "You need a redirected restore." : not always.. it depends....
    Now I'm curious.
    Are you refering to db2move and/or db2look + EXPORT&LOAD?
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  12. #12
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    to Florin Aparaschivei :
    if the same filesystems exist on target server and container/paths are not in use by other db and if this dbname does not exist in this instance, you could execute a simple restore without re-direct and create a new db
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  13. #13
    Join Date
    Oct 2013
    Posts
    39
    Hi Guys:-

    i have got restore script(which i got from the below command) for the v9.1 DB:
    db2 restore db test from /home/jseifert/backups taken at 20050304090733
    redirect generate script test_node0000.clp

    when i excuted that script i got the below error:

    SQL2519N The database was restored but the restored database was not upgraded
    to the current release. Error "-970" with tokens "*N" is returned.


    and when i tried to migrate the database using command:-
    db2 migrate database <dbname>

    i got below error:-

    SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009

    Please suggest?

  14. #14
    Join Date
    Oct 2013
    Posts
    39
    ******little correction

    Hi Guys:-

    i have got restore script(which i got from the below command) for the v9.1 DB:
    db2 restore db test from /home/jseifert/backups taken at 20050304090733
    redirect generate script test_node0000.clp

    when i excuted that script i got the below output:

    SQL1277W A redirected restore operation is being performed. Table space
    configuration can now be viewed and table spaces that do not use automatic
    storage can have their containers reconfigured.
    DB20000I The RESTORE DATABASE command completed successfully.

    RESTORE DATABASE DLSDB CONTINUE
    SQL2519N The database was restored but the restored database was not upgraded
    to the current release. Error "-970" with tokens "*N" is returned.



    and when i tried to migrate the database using command:-
    db2 migrate database <dbname>

    i got below error:-

    SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009

    Please suggest?

  15. #15
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated by message
    SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009
    details can be found in diaglog file
    probably some paths referenced in script for which you do not have proper chmod..
    or already in use
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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