Skip to Content
Mar 05, 2015 at 08:05 AM

DB2 restore takes quite long time


Dear Experts,

We met a quite strange problem, DB2 restore for a 300GB database will take 40 hours to be finished...

We are running on DB2 9.7 FP10, database backup time is about 40 minutes (for offline backup) and 2.5 hours (for online backup with compress option), now we are restoring it to other servers, but the restore speed is quite unbearable, estimated to be finished in 2 days

We have tried both offline backup set and online backup set, and was on different servers, all will take 2 days...even slower than load based method.

Do you have any idea what's the root cause of it? I searched on the SCN but not satisfied answers...

Please help me out. Thank you very much.