Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2015

    Unanswered: how to export database(schemas) from one server to another

    Hi All ,

    Datbase : IBM DB2 v.9.7
    Tools : Control Center
    I am new to db admin,and we need to move all database contents(of 2 schemas) to another server.

    Please suggets me best and easy and safe way to do the same.
    I am using db2 9.7 and know only control center tool.

    The source and target db2 version are same(v9.7)

    Many thanks in advance!

  2. #2
    Join Date
    May 2012
    Canberra, Australia
    Provided Answers: 6
    You can use db2look from the command line. Haven't used Control Center in years so can't comment on that. And Control Center is deprecated in favour of Data Studio anyway. Suggest you get the DBA to run db2look for you

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    db2move can also help
    or declare cursor database....
    load from cursor....
    see infocenter for detail
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  4. #4
    Join Date
    Jun 2015
    Hi All ,
    I could see backup and restore utility in control center tool.(db2 v.9.7)

    Any idea about that?

  5. #5
    Join Date
    Nov 2004
    Backup and restore is the easiest way for me.

Posting Permissions

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