New hardware, copy databases?

[Roger Eriksson]

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

[shenanwei]

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

[johnl]

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

[Roger Eriksson]

"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

[Roger Eriksson]

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

[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 :-)