Skip to main content
Solved

DB2 backup on AIX very slow


Did this answer your question?
Show first post

29 replies

Mike Struening
Vaulter
Forum|alt.badge.img+23

Ok, appreciate the details!!!  will keep an eye for your update.


Mike Struening
Vaulter
Forum|alt.badge.img+23

@Marcel Huisman , following up before I close this thread off.  Were there any other database changes that helped this issue?


Forum|alt.badge.img+4

Database parameters helped very much in speeding up the backup. Finally we rebalanced the volumegroups on this AIX server and created separate log volumes for each logical volume. At the end there was a defective drive library which was the greatest bottleneck. Still I think we can win extra speed by rebalancing the tablespaces, but we will probably do this the next time when we do a refresh.
Thanks for all of your help.


Mike Struening
Vaulter
Forum|alt.badge.img+23

That’s great news, @Marcel Huisman !  I’ll go ahead and mark this as the Best Answer, though feel free to add more info after your next refresh!


Reply


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