migrating a database between machines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex@sharaz.info - 17 Dec 2007 10:49 GMT

Hi,

Probably a simple question :-)

I've got a few xml aware databases on a 9.1.2 db2 server running on
RHEL 4. As db2 V9.5 doesn't run on RHEL 4 I've set up a new server
running RHEL5.1 with db2 9.5 on it. ((64 bit version)

All I want to do is copy the database from 1 machine to another.
I thought I could just copy across my backup file and restore it on
the new machine, but that doesn't seem to work.

I tried performing a copy from te control centre but that seems to
object to the xml data column I've got in the database.

So, how am i supposed to migrate a database from 1 system to another?

Alex

Reply to this Message

arada@ca.ibm.com - 18 Dec 2007 15:20 GMT

On Dec 17, 5:49 am, A...@sharaz.info wrote:

> Hi,
>
[quoted text clipped - 14 lines]
>
> Alex

Hi Alex,

Have you look at the migration guide? We provide a task to migrate to
a new server which is exactly your case:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.qb.mi
gration.doc/doc/t0011368.html

The migration can be done by restoring a full offline database back up
as long as the operating systems are compatible:
Backup and restore operations between different operating systems and
hardware platforms
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin
.ha.doc/doc/c0005960.html

Hope this helps,

Amyris.

Reply to this Message

Alex@sharaz.info - 21 Dec 2007 12:54 GMT

On 18 Dec, 15:20, ar...@ca.ibm.com wrote:

> On Dec 17, 5:49 am, A...@sharaz.info wrote:
>
[quoted text clipped - 30 lines]
>
> Amyris.

o.k. so old machine is RHEL 4 DB2 V9.1.2
new machine is 64bit RHEL 5.1 DB2 V9.5

both machines have same instance names, passwords etc

Create a directory called backups in the db2inst1 home directory

ftp the offline backup file into the backups directory

from the root of the db2inst directory type

db2 restore database netdev from backups

and get
SQL30082N Security processing failed with reason "3" ("PASSWORD
MISSING").

so try again with " user db2inst1 using .... " added

db2 restore database netdev user db2inst1 using mysillypassword from
backups

Now get

SQL2036N The path for the file or device "backups" is not valid

Try
db2 restore database netdev user db2inst1 using mysillypassword from ./
backups

Same error
try
db2 restore database netdev user db2inst1 using mysillypassword from
"./backups"

Same error

try ..... "/home/db2inst1/backups"

Same errror

cd into the backups directory

type
db2
restore NETDEV user db2inst using xxxxx <cr>

Get SQL2036N The path for the file or device "/home/db2inst1/backups"
is not
valid.

filename is NETDEV.0.db2inst1.NODE0000.CATN0000.20071221122723.001

more help please if possible

alex

Reply to this Message