On 18 Dec, 15:20, ar...@ca.ibm.com wrote:
On Dec 17, 5:49 am, A...@sharaz.info wrote:
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
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/infoce...pic/com.ibm.db...
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 platformshttp://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db...
Hope this helps,
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