How to migrate a AIX db2 database to NT?

[pichi]

hi everybody, is there a way that i can migrate mi db2 database running in a AIX Risc server to a NT 4.0 server??
that's because i'm working on my thesis and i need a copy of these database so i can work at home. can i make a copy of these database and put it on the Nt server??

thanks in advance

pichi

 

[Crox]

Hi,

I guess you can make an unload, take the data with you and reload it on the other platform.

Regards,

Crox

 

[fmshire]

Or you can simply catalog the database into your Win NT machine... that's if you will maintain access to the aix machine.

 

[whegge]

I am not sure what commands you have available to you on the AS/400 but this is what I did to move from NT to Linux. First command was given to me by IBM but it has a problem with LOB's. THe command is db2move. It will copy the stucture and data for you. There will be alot of files with this command and possibly warning messages, but IBM tech told me to ignore them.

The other possible way is to do a backup of the tables. Use db2's backup function. This will only get you the data I believe though. This also creates a file (BIG!).

Then all you have to do is ftp the files off and then use db2move to restore or do a restore if you use backup.

Hope this helps.