RE: can i restore AIX db backup in WINTEL....

RE: can i restore AIX db backup in WINTEL....

 

  

It is not possible. DB2 backup can NOT be restored across the platforms
like Aix to Windows.

Mac



"Robert Johnson "
<db2udbdba-ezmlmshield-x97231663.[Email address protected]
15/04/2008 15:01

To
"LazyDBA Discussion" <[Email address protected]
cc

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





http://www.rac.co.uk
http://www.rac.co.uk/business
http://www.bsm.co.uk

Any opinions expressed in this e-mail are those of the individual and not necessarily the company. This e-mail and any attachments are confidential to RAC and/or BSM and are solely for use by the intended recipient.

If you are not the intended recipient you must not disclose, copy or distribute its contents to any other person nor use its contents in any way.
If you have received this e-mail in error please forward a copy of this e-mail to "[Email address protected]

RAC Motoring Services: Registered England 1424399
VAT Reg No. GB 238640945
British School of Motoring Limited: Registered England 291902
VAT Reg No. GB 239505847
RAC Financial Services Limited: Registered England & Wales 5171817
VAT Reg No. GB 238640945
Registered Office(s): 8 Surrey Street, Norwich, NR1 3NG

RAC Motoring Services and RAC Financial Services Limited are authorised and regulated by the Financial Services Authority, both companies are members of the Aviva group.

This e-mail and any attachments has been scanned for the presence of computer viruses. RAC/BSM accept no responsibility for computer viruses once this e-mail has been transmitted.

DB2 & UDB email list listserv db2-l LazyDBA home page