- 论坛徽章:
- 0
|
大侠们帮我分析一下,我的DB2数据库在线全量备份时,为什么 db2diag.log 日志中总会有 Error的错误信息
备份脚本:- #!/bin/sh
- #采用的是在线全量备份
- #加载DB2环境变量
- . /home/db2inst1/sqllib/db2profile
- #数据库文件备份路径
- bakpath=/amfe/amfedb_bak
- #获取上一日期(YYYYMMDD)
- deldate=$(date +"%Y%m%d" -d yesterday)
- #备份日志路径及名称
- logDir=$bakpath
- logFile=db2backup_history.log
- #记录备份日志文件
- echo "" | tee -a ${logDir}/${logFile}
- echo "" | tee -a ${logDir}/${logFile}
- echo "==============================[ `date +\"%Y-%m-%d %T\"` ]==============================" | tee -a ${logDir}/${logFile}
- #开始备份DB2数据库
- echo "begin backup,date: "$(date +"%Y%m%d %T") | tee -a ${logDir}/${logFile}
- db2 backup db AMFEDB online to $bakpath compress include logs
- if [ $? != 0 ]; then
- echo "backup failed !" | tee -a ${logDir}/${logFile}
- else
- #备份成功删除上次全量备份文件
- echo "backup success !" | tee -a ${logDir}/${logFile}
- rm -f ${bakpath}/AMFEDB*${deldate}*
- echo "delete old backup file success !" | tee -a ${logDir}/${logFile}
-
- #备份成功删除归档文件
- filetimestamp=`ls -t ${bakpath}/AMFEDB* | head -1 | awk -F"." '{print $6}'`
- echo "filetimestamp:" $filetimestamp | tee -a ${logDir}/${logFile}
- db2 connect to amfedb
- db2 prune history $filetimestamp and delete
- echo "delete archivelog success !" | tee -a ${logDir}/${logFile}
- db2 connect reset
-
- #备份成功后把备份文件上次至AMFE备份服务
- filename=`ls -t ${bakpath}/AMFEDB* | head -1`
- sftp db2inst1@SFTPHOSTS <<EOF
- cd ${bakpath}
- lcd ${bakpath}
- put $filename
- quit
- EOF
- fi
复制代码 db2diag.log 具体报错信息如下:- 2015-12-22-01.30.03.028361+480 E8019776E491 LEVEL: Info
- PID : 4041 TID : 140514032609024PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000 DB : AMFEDB
- APPHDL : 0-1147 APPID: *LOCAL.db2inst1.151221173003
- AUTHID : DB2INST1
- EDUID : 28 EDUNAME: db2agent (AMFEDB)
- FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:507
- DATA #1 : <preformatted>
- Autonomic backup/restore - using parallelism = 8.
- 2015-12-22-01.30.03.038382+480 E8020268E517 LEVEL: Info
- PID : 4041 TID : 140514032609024PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000 DB : AMFEDB
- APPHDL : 0-1147 APPID: *LOCAL.db2inst1.151221173003
- AUTHID : DB2INST1
- EDUID : 28 EDUNAME: db2agent (AMFEDB)
- FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:618
- DATA #1 : <preformatted>
- Autonomic BAR - heap consumption.
- Targetting (50%) - 13088 of 26176 pages.
- 2015-12-22-01.30.03.038468+480 E8020786E505 LEVEL: Info
- PID : 4041 TID : 140514032609024PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000 DB : AMFEDB
- APPHDL : 0-1147 APPID: *LOCAL.db2inst1.151221173003
- AUTHID : DB2INST1
- EDUID : 28 EDUNAME: db2agent (AMFEDB)
- FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:869
- DATA #1 : <preformatted>
- Autonomic backup - tuning enabled.
- Using buffer size = 512, number = 16.
- 2015-12-22-01.30.03.063404+480 E8021292E452 LEVEL: Info
- PID : 4041 TID : 140514032609024PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000 DB : AMFEDB
- APPHDL : 0-1147 APPID: *LOCAL.db2inst1.151221173003
- AUTHID : DB2INST1
- EDUID : 28 EDUNAME: db2agent (AMFEDB)
- FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1533
- MESSAGE : Starting an online db backup.
- 2015-12-22-01.30.06.190350+480 E8021745E426 LEVEL: Info
- PID : 4041 TID : 140514032609024PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000 DB : AMFEDB
- APPHDL : 0-1147 APPID: *LOCAL.db2inst1.151221173003
- AUTHID : DB2INST1
- EDUID : 28 EDUNAME: db2agent (AMFEDB)
- FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:838
- MESSAGE : Backup complete.
- 2015-12-22-01.30.06.369583+480 E8022172E520 LEVEL: Info
- PID : 4041 TID : 140514024220416PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000 DB : AMFEDB
- APPHDL : 0-1148 APPID: *LOCAL.db2inst1.151221173006
- AUTHID : DB2INST1
- EDUID : 30 EDUNAME: db2agent (AMFEDB)
- FUNCTION: DB2 UDB, database utilities, sqluhDeletionReport, probe:381
- MESSAGE : ADM8506I Successfully deleted the following database logs "327 -
- 357" in log chain "0".
- 2015-12-22-01.30.06.480547+480 I8022693E365 LEVEL: Warning
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
- MESSAGE : Started archive for log file S0000357.LOG.
- 2015-12-22-01.30.06.480662+480 I8023059E448 LEVEL: Error
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogDisk, probe:2500
- RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
- DIA8411C A file "/amfe/dblog/S0000357.LOG" could not be found.
- 2015-12-22-01.30.06.480740+480 E8023508E473 LEVEL: Warning
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
- MESSAGE : ADM1848W Failed to archive log file "S0000357.LOG" to
- "/amfe/dbarchlog/db2inst1/AMFEDB/NODE0000/C0000000/" from
- "/amfe/dblog/".
- 2015-12-22-01.30.06.480857+480 E8023982E562 LEVEL: Error
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
- MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
- DIA8411C A file "" could not be found.
- DATA #1 : <preformatted>
- Failed to archive log file S0000357.LOG to /amfe/dbarchlog/db2inst1/AMFEDB/NODE0000/C0000000/ from /amfe/dblog/.
- 2015-12-22-01.30.06.480922+480 I8024545E381 LEVEL: Error
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchivePendingLogs, probe:1500
- MESSAGE : Log archive failed with rc -2045837302 for LOGARCHMETH1.
- 2015-12-22-01.30.27.480090+480 I8024927E365 LEVEL: Warning
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
- MESSAGE : Started archive for log file S0000357.LOG.
- 2015-12-22-01.30.27.480205+480 I8025293E448 LEVEL: Error
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogDisk, probe:2500
- RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
- DIA8411C A file "/amfe/dblog/S0000357.LOG" could not be found.
- 2015-12-22-01.30.27.480284+480 E8025742E473 LEVEL: Warning
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
- MESSAGE : ADM1848W Failed to archive log file "S0000357.LOG" to
- "/amfe/dbarchlog/db2inst1/AMFEDB/NODE0000/C0000000/" from
- "/amfe/dblog/".
- 2015-12-22-01.30.27.480390+480 E8026216E562 LEVEL: Error
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
- MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
- DIA8411C A file "" could not be found.
- DATA #1 : <preformatted>
- Failed to archive log file S0000357.LOG to /amfe/dbarchlog/db2inst1/AMFEDB/NODE0000/C0000000/ from /amfe/dblog/.
- 2015-12-22-01.30.27.480439+480 I8026779E510 LEVEL: Warning
- PID : 4041 TID : 140513583818496PROC : db2sysc
- INSTANCE: db2inst1 NODE : 000
- EDUID : 140 EDUNAME: db2logmgr (AMFEDB)
- FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4760
- MESSAGE : Unable to find log file 357 for LOGARCHMETH1 using method 1 and
- target /amfe/dbarchlog/db2inst1/AMFEDB/NODE0000/C0000000/. Assume
- log was archived and continue.
复制代码 |
|