CODEWITHSUNDEEP
databasedb2data-migration
user1374266
user1374266

Reputation: 333

Db2 data movement across different linux machines

We are planning to move to a new server, and we have installed db2 9.7 on it.

Which is the best option to move all the data from the db in the old server to the new server.

Both the servers have linux as OS.

Upvotes: 1

Views: 1567

Answers (2)

Rizwan joo
Rizwan joo

Reputation: 1

it says SQL1051N The path "/data/home/db2inst1" does not exist or is not valid.

You need to do a redirected restore for destination Server with paths/mount points available on this server/machine.

Upvotes: 0

Wasi
Wasi

Reputation: 1246

Take an offline backup of the old server's db and scp it to the new server

In the new server, create a new database and restore the database with old server's backup

Upvotes: 2

Related Questions