Skip to main content
commvault.com commvault.com
Question

DB2 Restore Running Very Slow - Restore to Disk

O
Byte
Forum|alt.badge.img+2

Dear Experts

We are trying to Restore Db2 Database to different Server ( Restore to Disk ), Media Read Performance is very low and Opened case with Commvault 250310-318. Media management team checked and confirmed no issues from environment side as we are getting Good read/write throughput.  and CV tests are Passed. 

We tested FS restore, which gave Good throughput and DB2 Restore still having issues. 

Any Suggestions & inputs why Media Read performance is too low…, and why Slowness is occurring ? 

 

Logs :- 

CVPerfMgrRestore.log

Buffer allocation.   10               71598458808  [66.68 GB]  [Samples - 1000] [Avg - 0.010000] [24005.25 GBPH]
Restore READ....     46134            47919623679  [44.63 GB]  [Samples - 1000] [Avg - 46.134000] [3.48 GBPH]
Restore Write        37               67427635200  [62.80 GB]  [Samples - 3003125760] [Avg - 0.000000] [6109.97 GBPH]

 

Buffer allocation    12               77939519544  [72.59 GB]  [Samples - 1000] [Avg - 0.012000] [21776.05 GBPH]
Restore READ....     46147            51698188718  [48.15 GB]  [Samples - 1000] [Avg - 46.147000] [3.76 GBPH]
Restore Write        41               73399275520  [68.36 GB]  [Samples - 384831488] [Avg - 0.000000] [6002.20 GBPH]

 

Buffer allocation.   10               73196299224  [68.17 GB]  [Samples - 1000] [Avg - 0.010000] [24540.97 GBPH]
Restore READ.....    46171            48977345933  [45.61 GB]  [Samples - 1000] [Avg - 46.171000] [3.56 GBPH]
Restore Write.       39               68932370432  [64.20 GB]  [Samples - 212893696] [Avg - 0.000000] [5925.99 GBPH]

 

Buffer allocation    11               85637853888  [79.76 GB]  [Samples - 1000] [Avg - 0.011000] [26102.12 GBPH]
Restore READ....     49065            55488262220  [51.68 GB]  [Samples - 1000] [Avg - 49.065000] [3.79 GBPH]
Restore Write.       45               80649129984  [75.11 GB]  [Samples - 3339718656] [Avg - 0.000000] [6008.83 GBPH]

 

    4 replies

    CV_GK
    Vaulter
    Forum|alt.badge.img+5
    • CV_GKVaulter
    • Vaulter
    • 56 replies
    • March 18, 2025

    Hi ​@OP Team 

    Was DB2 restore and FS restore tested from same backup media?

    what’s the result of Cvdiskperf utility against mount path holding db2 backup data

    O
    Byte
    Forum|alt.badge.img+2
    • OP Team
    • Author
    • Byte
    • 3 replies
    • March 19, 2025

    ​@CV_GK  not from Same MEDIA but from same Storage Policy, Yes tested. 

     

    B
    Vaulter
    Forum|alt.badge.img+2
    • BdasVaulter
    • Vaulter
    • 7 replies
    • March 19, 2025

    Hi,

    From the log snippets and screen shots the most amount of time spent was while reading from the media which appears to be very slow indeed. As explained by CV_GK , you will need to first identify the media/mount path where the DB2 backups happened originally and then run the Mount path validation test (READ stats are important ) in order to determine the read speed you are getting from the test . Though the file system and DB2 backups are part of the same Storage policy , the actual backup of the FS and DB2 agents may have happened on different destinations/Mount paths . You will first need to figure out the actual media and run the tests and then determine the next course of action . 

     

    Thanks & Regards 

    O
    Byte
    Forum|alt.badge.img+2
    • OP Team
    • Author
    • Byte
    • 3 replies
    • March 24, 2025

    Thank you, we also Opened Support case with Commvault. 

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings