469,903 Members | 1,651 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

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
Oct 25 '06 #1
5 1238
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
Oct 25 '06 #2
you could also use db2move. especially if you need to change any of
the objects (like path) when going to the new server.

sh*******@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
Oct 25 '06 #3
"johnl" <jo*********@yahoo.comwrote in
news:11**********************@i3g2000cwc.googlegro ups.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
Oct 26 '06 #4
sh*******@gmail.com wrote in
news:11**********************@b28g2000cwb.googlegr oups.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
Oct 26 '06 #5
Ian
Roger Eriksson wrote:
sh*******@gmail.com wrote in
news:11**********************@b28g2000cwb.googlegr oups.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 :-)
Oct 26 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.