Robert,
Check the below for your question for unix to linux.
------------------------------------------------------------------------
--------
Backup and restore operations between different operating systems and
hardware platforms
DB2(r) database systems support some backup and restore operations
between different operating systems and hardware platforms.
The supported platforms for DB2 backup and restore operations can be
grouped into one of three families:
Big-endian Linux(r) and UNIX(r)
Little-endian Linux and UNIX
Windows(r)
A database backup from one platform family can be restored on any system
within the same platform family. For Windows operating systems, you can
restore a database created on DB2 UDB V8 on a DB2 Version 9 database
system. For Linux and UNIX operating systems, as long as the endianness
(big endian or little endian) of the backup and restore platforms is the
same, you can restore backups that were produced on DB2 UDB V8 on DB2
Version 9.
The following table shows each of the Linux and UNIX platforms DB2
supports and indicates whether the platforms are big endian or little
endian:
Table 1. Endianness of supported Linux and UNIX operating systems DB2
supports Platform Endianness
AIX(r) big endian
HP-UX big endian
HP on IPF big endian
Solaris x86-64 little endian
Solaris SPARC big endian
Linux on zSeries big endian
Linux on Power PC big endian
Linux on IA-64 little endian
Linux on AMD64 and Intel(r) EM64T little endian
32-bit Linux on x86 little endian
The target system must have the same (or later) version of the DB2
database product as the source system. You cannot restore a backup
created on one version of the database product to a system running an
earlier version of the database product. For example, you can restore a
V8 backup on a V9 database system, but you cannot restore a V9 backup on
a V8 database system.
In situations where certain backup and restore combinations are not
allowed, you can move tables between DB2 databases using other methods:
db2move command
Export utility followed by the import or the load utilities
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: Robert Johnson
[mailto:db2udbdba-ezmlmshield-x47464134.[Email address protected]
Sent: Tuesday, April 15, 2008 10:25 AM
To: LazyDBA Discussion
Subject: RE: can i restore AIX db backup in WINTEL....
I wonder if LINUX is 'similar' enough to any other flavor of UNIX that
you could go from, say, AIX to LINUX and vice versa? Clearly you can't
go from UNIX to Windows or vice versa, but what about LINUX?
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x66010950.[Email address protected]
Sent: Tuesday, April 15, 2008 9: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
---------------------------------------------------------------------
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