backup/restore from 32bit linux db2 9.1 to 64bit linux 9.7

[alexs]

Hi,
I'm trying to migrate a database from a Linux-IA32 V9.1 server onto a
Linux-x86-64 server running 9.7

What I get is

SQL2570N An attempt to retore on target OS "Linux-x86-64" from a
backup created on source OS "Linux-IA32" failed due to the
incompatibility of operating systems or an incorrect specifcatino of
the restore command Reason-Code: 2

Guess I was on a high from doing the same thing from a V9.5 server and
forgot that the 9.5 was 64bit as well :-((

Any magical commands to get the restore to work?
TIA
Alex

[Lennart]

[lelle@c-83-219-209-129 2008]$ db2 "? SQL2570N"

SQL2570N An attempt to restore on target OS "<target-OS>" from a
backup
created on source OS "<source-OS>" failed due to the

incompatibility of operating systems or an incorrect

specification
of the restore command. Reason-code: "<reason-code>".

Explanation:

Possible reason codes are:

1 "<target-OS>" and "<source-OS>" are not compatible systems.

2 A cross-platform restore of a compressed backup was attempted
and no decompression library was specified. By default the
library in the backup image from "<source-OS>" is used. This
library is not suitable for a restore on "<target-OS>".

What you need to do is to specify what compression library to use.
Since I don't know how your restore command looked like I'll give an
example. Assume you did:

db2 restore db YOURDB taken at .... redirect without rolling forward
without prompting

try:

db2 restore db YOURDB taken at ... redirect comprlib /opt/IBM/db2/V9.5/
lib64/libdb2compr.so without rolling forward without prompting

You should be able to:

#> locate libdb2compr.so

to get the path.

HTH
/Lennart

[Lennart]

I should add that this worked for me with 9.5, haven't tried 9.7

/Lennart