Skip to main content
Question

DB2 Point in Time Restore

  • June 5, 2024
  • 1 reply
  • 38 views

Forum|alt.badge.img+1

Dear Community, 

 

anyone has experience with DB2 point in time restore of more than 1.5 TB Database if yes can you share me how long it takes … 

in my case almost 9 hours taken for restore. 

data restore taking 4 to 5 hours and roll forward taken 4 to 5 hours. 

 

 

1 reply

Forum|alt.badge.img+14

Hello @AMIR 

There are so many factors that can impact restore performance. Like read speed, network speed and Antivirus as just to name a few.

 

There is a log “CVPerfMgrRestore.log” on the media agent at the end of a job and it breaks down each operation and how long it took to help you understand your bottle necks. 

 

If not, raise a support ticket to help isolate the bottle neck to see what is the problem and if the performance can be improved. 


Kind regards

Albert Williams