I certainly go with daniel.
But you have an alternative.
Using DB2 utilities to clone databases across different platforms
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0403melnyk/
Regards,
Rajesh Chandramohan
Offshore UDB DBA Team
180-066-62388 x 13311/37/97
Please note that the ODC UDB Operations work on a shift rotation basis,
therefore any ongoing communication generated from this e-mail should
have #ODC UDB or #DBA-UDB included in order to maintain a prompt
response.
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x66010950.[Email address protected]
Sent: Tuesday, April 15, 2008 10:11 AM
To: LazyDBA Discussion
Subject: RE: can i restore AIX db backup in WINTEL....
You cant do it. You can from say aix - sun or sun- aix, but not from
unix to windows.
From:
"Robert Johnson "
<db2udbdba-ezmlmshield-x97231663.[Email address protected]
To:
"LazyDBA Discussion" <[Email address protected]
Date:
04/15/2008 10:04 AM
Subject:
RE: can i restore AIX db backup in WINTEL....
I nearly was going to write a letter where I would say, gee, all you'd
need to do is change any forward slash UNIX container statements to
typical C:\ windows types of statements in the "from" portion of the
restore, the set tablespace statements, etc.
However, as I thought about it, even for something like a tablespace
backup, you're backing up an object whose very essence relies on
containers which have a different structure in UNIX versus windows. So
I'm beginning to doubt that you can do a restore on Windows using a UNIX
backup.
I've never actually tried it. What are other folks' thoughts?
-----Original Message-----
From: SHRINIVASAN MUTHU /EXT/INFOTECH/CDVL
[mailto:db2udbdba-ezmlmshield-x21209464.[Email address protected]
Sent: Tuesday, April 15, 2008 8:36 AM
To: LazyDBA Discussion
Subject: can i restore AIX db backup in WINTEL....
Hi Friends,
can i restore db2 backup taken from AIX 5.2 to Windows DB2
Please advice.
Regards,
Shrinivasan.
---
This e-mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient.If you have erroneously received this
message, please delete it immediately and notify the sender. The
recipient acknowledges that 3i Infotech or its subsidiaries and
associated companies, (collectively "3i Infotech"), are unable to
exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and
further acknowledges that any views expressed in this message are those
of the individual sender and no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.
--------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within this communication (including any attachments) is not intended or written to be used and cannot be used for the purpose of (i) avoiding U.S. tax related penalties or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein.
DB2 & UDB email list listserv db2-l LazyDBA home page