Personal tools
You are here: Home → DB2 → How To's → How to restore a database compressed by DB2 in other system
Navigation
Log in


Forgot your password?
 
Document Actions

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
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls