Restore Questions (32 vs 64 bit)

[haganahtrainer@gmail.com]

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...

[Mark A]

Re: Restore Questions (32 vs 64 bit)

<haganahtrainer @gmail.comwrote in message
news:b04de03c-495e-48dc-8951-140a697c8662@i7 6g2000hsf.googl egroups.com...

>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...

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.

[kschlamb@ca.ibm.com]

Re: Restore Questions (32 vs 64 bit)

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
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...

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 <dbcomprlib ~/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

[w.l.fischer@googlemail.com]

Re: Restore Questions (32 vs 64 bit)

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.

[Mark A]

Re: Restore Questions (32 vs 64 bit)

<w.l.fischer@go oglemail.comwro te in message
news:ea8a0ab6-7564-4996-8ce9-9cfab4396ad2@k3 7g2000hsf.googl egroups.com...

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.

[kschlamb@ca.ibm.com]

Re: Restore Questions (32 vs 64 bit)

On Oct 26, 6:54 pm, "Mark A" <some...@someon e.comwrote:

<w.l.fisc...@go oglemail.comwro te in message
>
news:ea8a0ab6-7564-4996-8ce9-9cfab4396ad2@k3 7g2000hsf.googl egroups.com...
>

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.

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.db2.luw.admin.ha.doc/doc/c0005960.html

Regards,
Kelly