Support #12828
[SCP ID :##6164##] : IBM DB2 Backup Taking longer than usual
| Status: | Work Completed-End life cycle | Start date: | February 28, 2022 | ||
|---|---|---|---|---|---|
| Priority: | Normal | Due date: | |||
| Assignee: |  Zahir Abd Latif | % Done: | 90% | ||
| Category: | Technical | Spent time: | - | ||
| Target version: | - |
Description
Hi,
Kindly attend below request:-
DB2 backup takes 40 mins instead of normal backup time 10 mins.
Related issues
History
#1
Updated by Nurul Athira Abdul Rahim over 2 years ago
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#2
Updated by Nurul Athira Abdul Rahim over 2 years ago
- Category set to Technical
#3
Updated by Najmi Pasarudin over 2 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 50
So far, nothing unusual found in the log during the slow backup.
Duration:- Normal = ~30 minutes
- Slow = ~50 minutes
Log info:
25 Feb - Normal
26 Feb - Slow
28 Feb - Slow
21 Mar - Normal
23 Mar - Slow
#4
Updated by Nurul Athira Abdul Rahim over 2 years ago
- Assignee changed from Najmi Pasarudin to Chun Feng Lim
Hi CF, DB2 takes extra time to back up. And the time consuming is unstable.
Kindly help to check the log on this issue.
#5
Updated by Nurul Athira Abdul Rahim over 2 years ago
Suggestion :-
1) To study on backup optimization
2) To adopt online backup instead of offline
#6
Updated by Nurul Syahirah Md Nawi over 2 years ago
- Status changed from Development / Work In Progress to Pending Review
- Assignee changed from Chun Feng Lim to Nurul Syahirah Md Nawi
- % Done changed from 50 to 90
Production deployed on 19/5/22
#7
Updated by Binti Marobi Athirah Umairah about 2 years ago
- Status changed from Pending Review to Work Completed-End life cycle
- Assignee changed from Nurul Syahirah Md Nawi to Zahir Abd Latif