In V8 we support cross platform restoration, so you can take a full offline
DB backup from AIX and restore it on HP
regardsm
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager,
DB2 / LUW Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
"James Dey"
<[EMAIL PROTECTED]
.uk> To
Sent by: "Sunil Inchal"
[EMAIL PROTECTED] <[EMAIL PROTECTED]>,
ash.org <[EMAIL PROTECTED]>
cc
07/31/2003 12:30 Subject
PM RE: [DB2EUG] Migration from AIX to
HP
Please respond to
"James Dey"
<[EMAIL PROTECTED]
.uk>
Sunil,
1) You can use db2move to move the tables.
2) You can use "db2look -d <database> -e -o <output file>" to generate
database, tablespace, table, index etc definitions
I forget how to export and import the DB2 stored procedures. Anybody?
James
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Sunil Inchal
Sent: 31 July 2003 16:55
To: [EMAIL PROTECTED]
Subject: [DB2EUG] Migration from AIX to HP
Hi all,
Right now we have DB2 V8.1 installed on AIX 5.
We are planning to move all tdatabases on this instance to HP UX.
What's the best way of doing this?
I suppose db2move only moves tables, indexes etc. what about stored
procedures (SQL and JAVA) and other objects?
I think taking backup on AIX and restoring it on HP won't work.
In Informix we used to dbexport databases (which will export all databases
including tables, indexes, constriants, views, synonyms, stored procedures,
user privileges), I mean exact copy of database, with just two simple
statements, dbexport on source database and dbimport on target database.
How this can be done in DB2 environment in the easiest way?
Thanks and regards
Sunil
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
