在浪潮的操作系统上安装的db2 10.5.0.5,本地压缩全库在线备份的时候很慢,要20多小时,数据库840G,有多个表空间,有一个表空就700多G,怎么提高备份效率???
操作系统:K-UX(浪潮)
etcser库844G,备份时间为21~24小时,压缩后文件为348G,压缩率为41%。
$db2 backup db ETCSER online to /etcspbackup/ETCSER compress include logs
日志:
Parallelism = 5
Number of buffers = 10
Buffer size = 16781312 (4097 4kB pages)
Compr
BM# Total I/O Compr MsgQ WaitQ Buffers MBytes MBytes
000 78232.40 319.69 1163.67 0.01 76382.37 672 15391 16461 1
001 78231.48 28.39 135.73 0.00 77705.29 47 1333 2464 0
002 78225.03 25225.93 52517.72 0.35 9.00 20740 814133 815266 14
003 78232.37 501.93 1330.11 0.01 76035.85 596 21385 22546 0
004 78225.03 18.33 104.45 0.00 77744.54 44 833 1953 0
TOT 391146.33 26094.30 55251.69 0.37 307877.08 22099 853076 858692
MC# Total I/O MsgQ WaitQ Buffers MBytes
000 78233.00 865.81 77365.49 0.01 22100 353654
TOT 78233.00 865.81 77365.49 0.01 22100 353654
$db2 backup db ETCSER online to /etcspbackup/ETCSER with 32 buffers parallelism 8 compress include logs
Parallelism = 8
Number of buffers = 32
Buffer size = 16781312 (4097 4kB pages)
Compr
BM# Total I/O Compr MsgQ WaitQ Buffers MBytes MBytes
000 91415.87 38759.33 52267.99 0.47 26.19 20775 815700 816525 14
001 91413.85 610.33 1298.85 0.01 89288.31 587 21415 22176 0
002 91412.85 1.25 63.41 0.00 91149.69 19 145 877 0
003 91415.86 17.19 150.43 0.00 91055.11 38 1334 2054 0
004 91414.94 290.18 1163.50 0.01 89754.61 662 15398 16018 1
005 91413.85 2.47 78.43 0.00 91120.63 35 655 1415 0
006 91413.88 0.64 48.67 0.00 91156.04 19 32 792 0
007 91413.89 0.06 48.27 0.00 91157.74 19 0 760 0
TOT 731315.02 39681.48 55119.59 0.50 634708.36 22154 854683 860620
MC# Total I/O MsgQ WaitQ Buffers MBytes
000 91417.29 811.16 90603.61 0.00 22155 354534
TOT 91417.29 811.16 90603.61 0.00 22155 354534
收起