论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-02-08 11:12 |只看该作者 |倒序浏览

请问数据库出现Backup pending 除了从活动日志到归档日志参数修改导致外，还有没有其他原因，最近数据库总是出现，而且我已经作过n次脱机全备份了。
db2diag.log里的信息如下：

007-02-07-13.57.03.348147-360 I721791C322       LEVEL: Event
PID    : 1380548             TID  : 1274       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:100
START : Automatic Runstats: evaluation has started on database TTCHIS

2007-02-07-13.57.03.649626-360 I722114C323       LEVEL: Event
PID    : 1380548             TID  : 1274       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:900
STOP : Automatic Runstats: evaluation has finished on database TTCHIS

2007-02-07-15.37.03.718258-360 I722438C317       LEVEL: Event
PID    : 1380548             TID  : 1275       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:10
START : Automatic reorg evaluation has started on database TTCHIS

2007-02-07-15.37.03.758508-360 I722756C331       LEVEL: Event
PID    : 1380548             TID  : 1275       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:20
START : Automatic reorg evaluation has finished successfully on database TTCHIS

2007-02-07-15.37.03.830990-360 I723088C322       LEVEL: Event
PID    : 1380548             TID  : 1276       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:260
STOP : Automatic Backup: evaluation has finished successfully on database TTCHIS

2007-02-07-16.02.03.500167-360 I723411C322       LEVEL: Event
PID    : 1380548             TID  : 1277       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:100
START : Automatic Runstats: evaluation has started on database TTCHIS

2007-02-07-16.02.03.801064-360 I723734C323       LEVEL: Event
PID    : 1380548             TID  : 1277       PROC : db2hmon 0
INSTANCE: ttchis1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:900
STOP : Automatic Runstats: evaluation has finished on database TTCHIS

2007-02-07-16.16.31.071573-360 I724058C514       LEVEL: Severe
PID    : 593960             TID  : 1          PROC : db2agent (TTCHIS) 0
INSTANCE: ttchis1             NODE : 000       DB : TTCHIS
APPHDL  : 0-1329             APPID: GA0AC821.A6E7.0A0AF7081641
FUNCTION: DB2 UDB, data protection, sqlpgint, probe:1230
RETCODE : ZRC=0x801000A1=-2146434911=SQLP_BACKPEND
      "Backup pending.  Database has been made recoverable.  Backup now required."
      DIA8168C Backup pending for database .