One may mot backup-restore across different OS.
You will have to use db2move.
You'll have to:
1) Use db2look with -e to extract the ddl.
2) Edit that so that container defs. are compatible with proper os defs.
3) Change whatever else you'll need.
4) Go to the target system and just do: Create db dbname on path
5) You could redefine the default tablespaces in the create db command if you
need.
6) Run the output of db2look on the target. This will create all objects.
7) Run db2move export on the source
8) Run db2move import or load on the target.
9) Cross your fingers and connect to target.
HTH, Pierre.
kishore lingamallu wrote:
> Hi
>
> I want to move the databases from NT to AIX, what is the best process?
>
> Can database backup image from NT is restorable on AIX with tablespace
> redirect option?
>
> Do I have to go with db2move utility?
>
> Does any body have hands on experience with this kind of situation, please
> share.
> Thank You.
>
> Kish
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
