How to restore a 64-bit database into a 32-bit instance using a compressed backup

Posted by

This one seems to baffle some, though like redirected restores, it’s something that is only tough the first few times. If you attempt to restore a 64-bit database on a 32-bit instance using a compressed backup image, you get this scary error message:

SQL2570N  A database cannot be restored on a platform that does not match the
platform on which the backup image was created.

Usually you then scratch your head and double check the versions of the OS and maybe go confuse a Sysadmin or two.

Many people give up at this point, and just go take an uncompressed backup, but the solution is well documented and simple. All you have to do is to add the comprlib option on your restore command with the right library listed. Where do you find the right library? Well, I do this so infrequently, I generally google it, but here’s the link to a good source:

https://www-304.ibm.com/support/docview.wss?uid=swg21226230

It really is as simple as adding that one option on your restore command. However, if you receive this error when you really are trying to restore from say Linux to Windows, I can’t help you there – cross platform restores for DB2 have limited support: http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.ha.doc/doc/c0005960.html

Lead Db2 Database Engineer and Service Delivery Manager , XTIVIA
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 17 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home for XTIVIA, leading a team of Db2 DBAs.

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.