New hardware, copy databases?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Roger Eriksson
    #1

    New hardware, copy databases?

    They finally found some money to get (me) some new hardware fro the
    database server. At the same time I'm upgrading from DB2 v8 to v9. Still on
    Linux but on a 64 bit machine while the old one ran on 32 bit.

    Now I have the problem of copying the databases and all the user
    permissions to the new setup. Is there an easier way to do this than to
    export everything as ixf and manually fix the permissions?


    --
    /RE
    Tags: None
    • shenanwei@gmail.com
      #2
      Re: New hardware, copy databases?

      backup/restore/migrate will work.
      you dont need export data.
      Roger Eriksson wrote:
      They finally found some money to get (me) some new hardware fro the
      database server. At the same time I'm upgrading from DB2 v8 to v9. Still on
      Linux but on a 64 bit machine while the old one ran on 32 bit.
      >
      Now I have the problem of copying the databases and all the user
      permissions to the new setup. Is there an easier way to do this than to
      export everything as ixf and manually fix the permissions?
      >
      >
      --
      /RE

        Comment

        • johnl
          #3
          Re: New hardware, copy databases?

          you could also use db2move. especially if you need to change any of
          the objects (like path) when going to the new server.

          shenanwei@gmail .com wrote:
          backup/restore/migrate will work.
          you dont need export data.
          Roger Eriksson wrote:
          They finally found some money to get (me) some new hardware fro the
          database server. At the same time I'm upgrading from DB2 v8 to v9. Still on
          Linux but on a 64 bit machine while the old one ran on 32 bit.

          Now I have the problem of copying the databases and all the user
          permissions to the new setup. Is there an easier way to do this than to
          export everything as ixf and manually fix the permissions?


          --
          /RE

            Comment

            • Roger Eriksson
              #4
              Re: New hardware, copy databases?

              "johnl" <johnlantz69@ya hoo.comwrote in
              news:1161807387 .923475.251440@ i3g2000cwc.goog legroups.com:
              >Roger Eriksson wrote:
              They finally found some money to get (me) some new hardware fro the
              database server. At the same time I'm upgrading from DB2 v8 to v9.
              Still on Linux but on a 64 bit machine while the old one ran on 32
              bit.
              >
              Now I have the problem of copying the databases and all the user
              permissions to the new setup. Is there an easier way to do this
              than to export everything as ixf and manually fix the permissions?
              you could also use db2move. especially if you need to change any of
              the objects (like path) when going to the new server.
              Db2move was what I thought of when I wrote ixf since that is what it does.

              But when I last did that I had to set the user permissions and ownership on
              the tables manually and I would like to avoid that if it is possible.


              --

              Mvh

              /RE

                Comment

                • Roger Eriksson
                  #5
                  Re: New hardware, copy databases?

                  shenanwei@gmail .com wrote in
                  news:1161787999 .896043.167780@ b28g2000cwb.goo glegroups.com:
                  Roger Eriksson wrote:
                  >They finally found some money to get (me) some new hardware fro the
                  >database server. At the same time I'm upgrading from DB2 v8 to v9.
                  >Still on Linux but on a 64 bit machine while the old one ran on 32
                  >bit.
                  >>
                  >Now I have the problem of copying the databases and all the user
                  >permissions to the new setup. Is there an easier way to do this than
                  >to export everything as ixf and manually fix the permissions?
                  backup/restore/migrate will work.
                  you dont need export data.
                  I didn't think it would work between different architectures? But I'll
                  check it out again and see if I can figure something out.


                  --

                  Mvh

                  /RE

                    Comment

                    • Ian
                      #6
                      Re: New hardware, copy databases?

                      Roger Eriksson wrote:
                      shenanwei@gmail .com wrote in
                      news:1161787999 .896043.167780@ b28g2000cwb.goo glegroups.com:
                      >
                      >Roger Eriksson wrote:
                      >>They finally found some money to get (me) some new hardware fro the
                      >>database server. At the same time I'm upgrading from DB2 v8 to v9.
                      >>Still on Linux but on a 64 bit machine while the old one ran on 32
                      >>bit.
                      >>>
                      >>Now I have the problem of copying the databases and all the user
                      >>permissions to the new setup. Is there an easier way to do this than
                      >>to export everything as ixf and manually fix the permissions?
                      >
                      >backup/restore/migrate will work.
                      >you dont need export data.
                      >
                      I didn't think it would work between different architectures? But I'll
                      check it out again and see if I can figure something out.
                      >
                      >
                      You can restore a database in a 32-bit instance into a 64-bit instance.

                      The architectural differences have to do with "endian-ness" of the
                      systems, not "bit-ness". (Sorry for those highly technical terms :-)

                        Comment

                        Previous template Next
                        Working...