Restore Questions (32 vs 64 bit)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

haganahtrainer@gmail.com - 24 Oct 2008 18:19 GMT

I have a database backup file that was created from an AIX 64 bit
instance - when I ry to restore this I get a message SQL2570N, A
database cannot be restored on a platform that does not match the
platform on which the backup image was created

The instance I need to restore to is 32 bit running on AIX (Same
version of DB2) - is there anyway to get a 64 bit backup file into a
32 bit instance...

Reply to this Message

Mark A - 24 Oct 2008 19:43 GMT

>I have a database backup file that was created from an AIX 64 bit
> instance - when I ry to restore this I get a message SQL2570N, A
[quoted text clipped - 4 lines]
> version of DB2) - is there anyway to get a 64 bit backup file into a
> 32 bit instance...

You cannot restore 64 bit to 32 bit. The reason is that the information on
data and index pages (other than the application data) is different on the
two different bit systems. For example, there is a limit of 255 rows per
page on 32 bit, but the limit is much higher in 64 bit and the restore is
not set up to make those adjustments that would be necessary.

Reply to this Message

w.l.fischer@googlemail.com - 26 Oct 2008 19:47 GMT

> You cannot restore 64 bit to 32 bit. The reason is that the information on
> data and index pages (other than the application data) is different on the
> two different bit systems. For example, there is a limit of 255 rows per
> page on 32 bit, but the limit is much higher in 64 bit and the restore is
> not set up to make those adjustments that would be necessary.

What you are talking about is LARGE vs. REGULAR tablespaces. The
format of 32bit vs. 64bit backup images is not changed, except for the
compression format (see other post).

Another problem that could surface is little endianess vs. big
endianess, which is why it's not possible to transfer the image
between unix and windows.

Reply to this Message

Mark A - 26 Oct 2008 23:54 GMT

> What you are talking about is LARGE vs. REGULAR tablespaces. The
> format of 32bit vs. 64bit backup images is not changed, except for the
> compression format (see other post).

Thanks for the clarification. In V9.5 LARGE is the default when creating a
DMS tablespace (not sure about previous releases) unless REGULAR is
specified. So that does mean that if a LARGE tablespace has been created in
64-bit, the database cannot be restored to 32-bit.

Reply to this Message

kschlamb@ca.ibm.com - 28 Oct 2008 15:37 GMT

> <w.l.fisc...@googlemail.com> wrote in message
>
[quoted text clipped - 8 lines]
> specified. So that does mean that if a LARGE tablespace has been created in
> 64-bit, the database cannot be restored to 32-bit.

Nope, that's not a problem at all. As was previously pointed out,
it's mainly an issue of the endianess. The following section of the
DB2 docs state that there are three platform families, and that you
can backup/restore within each family:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db
2.luw.admin.ha.doc/doc/c0005960.html

Regards,
Kelly

Reply to this Message

kschlamb@ca.ibm.com - 25 Oct 2008 02:19 GMT

On Oct 24, 1:19 pm, haganahtrai...@gmail.com wrote:

> I have a database backup file that was created from an AIX 64 bit
> instance - when I ry to restore this I get a message SQL2570N, A
[quoted text clipped - 4 lines]
> version of DB2) - is there anyway to get a 64 bit backup file into a
> 32 bit instance...

This is supported and should work. What version of DB2 are you using?

Any chance that you are dealing with a compressed backup image? If so
then the compression library stored with the backup is 64-bit and
can't be used during the restore to do the decompression (since the
instance is 32-bit). If this is the case and you used DB2's default
compression library then this command should hopefully work for you:

restore database <db> comprlib ~/sqllib/lib/libdb2compr.a

In this case, it's going to use the library specified for
decompression (which is the same bit-ness as the instance).

Hope that helps.
Kelly Schlamb

Reply to this Message