Restore database from v7.2 to v8.2

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • chow.justy@gmail.com
    #1

    Restore database from v7.2 to v8.2

    Dear all,

    I'm a new beginner of DB2. I face 2 question during restore the data.

    I have 2 DB2 servers on my company. Server A is running on V7.2 and
    Server B is running on v8.2 (Enterprise Server). I backup a database
    from Server A and restore it on Server B.

    Question 1)
    "SQL2542N database name is not match on the source file" error
    prompted. The date and time are entered correctly during restore
    command.

    Question 2)
    Somebody told me that V7.2 database can't restore on V8.2 directly. Is
    it true? If yes, how can I get the data on Server B.

    Thank you for your help.

    Best Regards,

    Justy

    Tags: None
    • m
      #2
      Re: Restore database from v7.2 to v8.2

      chow.justy@gmai l.com wrote:[color=blue]
      > Dear all,
      >
      > I'm a new beginner of DB2. I face 2 question during restore the data.
      >
      > I have 2 DB2 servers on my company. Server A is running on V7.2 and
      > Server B is running on v8.2 (Enterprise Server). I backup a database
      > from Server A and restore it on Server B.
      >
      > Question 1)
      > "SQL2542N database name is not match on the source file" error
      > prompted. The date and time are entered correctly during restore
      > command.
      >
      > Question 2)
      > Somebody told me that V7.2 database can't restore on V8.2 directly. Is
      > it true? If yes, how can I get the data on Server B.
      >
      > Thank you for your help.
      >
      > Best Regards,
      >
      > Justy
      >[/color]
      V7 will DEFINITELY restore to V8 - providing they are the same platform.
      Windows -> Windows, Unix -> Unix. What platform are you using? Are you
      trying to rename the DB?

        Comment

        • Michel Esber
          #3
          Re: Restore database from v7.2 to v8.2

          I have restored V7.2 offline backups to V8.2 and it works like a charm.

          You will have to convert your indexes to type-2 afterwards.

          Just wondering ? Is there anything else that should be performed in
          order to have a full complain V8.2 system, or do we only need to
          convert the indexes ?

          Thanks,

          [color=blue]
          > Dear all,
          >
          > I'm a new beginner of DB2. I face 2 question during restore the data.
          >
          > I have 2 DB2 servers on my company. Server A is running on V7.2 and
          > Server B is running on v8.2 (Enterprise Server). I backup a database
          > from Server A and restore it on Server B.
          >
          > Question 1)
          > "SQL2542N database name is not match on the source file" error
          > prompted. The date and time are entered correctly during restore
          > command.
          >
          > Question 2)
          > Somebody told me that V7.2 database can't restore on V8.2 directly. Is
          > it true? If yes, how can I get the data on Server B.
          >
          > Thank you for your help.
          >
          > Best Regards,
          >
          > Justy[/color]

            Comment

            • Pierre Saint-Jacques
              #4
              Re: Restore database from v7.2 to v8.2

              You don't even need to convert your indexes immediately after migrating
              (which the restore v7.2 to V8.2 does).
              V7.2 Type1 indexes can be converted with the V8.2 REORG command or when you
              do the first reorg of the table under V8.2.

              Here's the full text of your error msg.
              SQL2542N No match for a database image file was found based on
              the source database alias "<database-alias>" and
              timestamp "<timestamp >" provided.

              Explanation:

              The backup image file filename consists of a database alias and a
              timestamp component. A filename is constructed from the source
              database alias and timestamp parameters provided in the Database
              Restore call. No filename existed in the source directory that
              matched based on the source database alias and timestamp
              provided. If this error was received from an automatic
              incremental restore then a required image was not found based on
              the timestamp and location in the database history.

              Either the timestamp you provided is wrong or the path you specified to
              restore from is wrong
              Please provide the command and the path where your image to restore is.

              HTH, Pierre.

              --
              Pierre Saint-Jacques
              SES Consultants Inc.
              514-737-4515
              "Michel Esber" <michel@us.auto matos.com> a écrit dans le message de news:
              1149879951.0202 83.131670@i40g2 00...legr oups.com...[color=blue]
              >I have restored V7.2 offline backups to V8.2 and it works like a charm.
              >
              > You will have to convert your indexes to type-2 afterwards.
              >
              > Just wondering ? Is there anything else that should be performed in
              > order to have a full complain V8.2 system, or do we only need to
              > convert the indexes ?
              >
              > Thanks,
              >
              >[color=green]
              >> Dear all,
              >>
              >> I'm a new beginner of DB2. I face 2 question during restore the data.
              >>
              >> I have 2 DB2 servers on my company. Server A is running on V7.2 and
              >> Server B is running on v8.2 (Enterprise Server). I backup a database
              >> from Server A and restore it on Server B.
              >>
              >> Question 1)
              >> "SQL2542N database name is not match on the source file" error
              >> prompted. The date and time are entered correctly during restore
              >> command.
              >>
              >> Question 2)
              >> Somebody told me that V7.2 database can't restore on V8.2 directly. Is
              >> it true? If yes, how can I get the data on Server B.
              >>
              >> Thank you for your help.
              >>
              >> Best Regards,
              >>
              >> Justy[/color]
              >[/color]

                Comment

                • chow.justy@gmail.com
                  #5
                  Re: Restore database from v7.2 to v8.2

                  Dear all,

                  Thank you for your help and suggestion. I have try to rename the backup
                  name and make sure the path of backup. And, I use command "db2ckbkp" to
                  check the detail information of backup image file. But the problem
                  didn't solve.

                  Once, I compared 2 different backup image from v7.2 and v8.2.
                  "Instance" of databases are different. V7.2 database is "DB2", V8.2
                  database is "DB2CTLSV". Is it the different of instance name to cause
                  the problem? Do you any idea?

                  Thanks a lot !!

                  Best Regards,

                  Justy

                    Comment

                    • Sathyaram Sannasi
                      #6
                      Re: Restore database from v7.2 to v8.2

                      Instance name should not matter ...
                      If you want to restore the following image (of database OLTPDBP on
                      instance db2ip)

                      OLTPDBP.0.db2ip .NODE0000.CATN0 000.20060527114 855.001


                      To a database OLTPDBQ in instance db2iq, then use the command

                      Restore database OLTPDBP into OLTPDBQ


                      chow.justy@gmai l.com wrote:[color=blue]
                      > Dear all,
                      >
                      > Thank you for your help and suggestion. I have try to rename the backup
                      > name and make sure the path of backup. And, I use command "db2ckbkp" to
                      > check the detail information of backup image file. But the problem
                      > didn't solve.
                      >
                      > Once, I compared 2 different backup image from v7.2 and v8.2.
                      > "Instance" of databases are different. V7.2 database is "DB2", V8.2
                      > database is "DB2CTLSV". Is it the different of instance name to cause
                      > the problem? Do you any idea?
                      >
                      > Thanks a lot !!
                      >
                      > Best Regards,
                      >
                      > Justy[/color]

                        Comment

                        Previous template Next
                        Working...