when i try to restore a compressed image of v8.2.7 ,32 bit to v9.1.2 ,64 bit it fails giving SQL2570N Reason-code: "2".
however using a uncompressed image does the trick , but doing a uncompressed image and moving them accross servers is a burden

i was just going through
http://www-1.ibm.com/support/docview...id=swg1IY71307
and it said of
Local fix
Override the compression library stored in the backup image
using the COMPRLIB option of RESTORE.

i was just wondering how to use COMPRLIB in a restore command and
from where i will get COMPRLIB value ?

db2 "? restore" will give you where the COMPRESSION LIBRARY statement should go; when backing up, OS compression routine is used and the library containing the routine(32bit) is saved in the backup;while restoring, by using " COMPRESSION LIBRARY " you are telling the restore to use the current OS compression(or uncompression) library(64bit) and not the ONE saved in the backup.

thanks...
finally it worked
db2 restore db <dbname> from <location> replace existing COMPRLIB D:\PROGRA~3\IBM\SQLLIB\BIN\db2compr.dll without rolling forward