How to restore a database compressed by DB2 in other system
COMPRLIB option
If you are restoring a database v8 to v9, example, and if database is
compressed, you have to restore the database with option comprlib, see
the example below:Database: SAMPLE
Database resides on DB2 V8, and I want to restore it in another system with db2 v9. So, first you have to perform a backup offline:
db2 backup db sample to /data/db2 compress
On system with DB2 V9, perform the restore with comprlib option:
db2 restore db sample from /datav9/db2 taken at 20090210030302
to /home/dinst2db into sample COMPRLIB libdb2compr.a WITHOUT ROLLING FORWARD
No comments:
Post a Comment