测试库db2diag.log中报错信息:2012-04-19-15.31.56.969685+480 I458477327A450 LEVEL: Error
PID : 708764 TID : 1081 PROC : db2acd 0
INSTANCE: db2instt NODE : 000
APPID : *LOCAL.db2instt.120419073203
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:515
MESSAGE : Failed to evaluate table "DB2INSTT"."PBCATCOL". Probe 400
DATA #1 : Hexdump, 4 bytes
0x0000000111963E4C : FFFF F6FE
http://www-01.ibm.com/support/docview.wss?uid=swg1IC65943官方说Problem Description:AUTO REORG FAILED TO EVALUATE TABLE,Problem is first fixed in Version 9.7 Fix Pack 2...
看了下该实例下的几个库,自动维护的配置参数大都配置成了如下,没有把auto_reorg打开的配置:
Auto restart enabled (AUTORESTART) = ON
Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ON
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
需要把auto_tbl_maint关了吗?这个应该都是默认值...
另外,有好几条类似错误,提示错误的表中也存在数据,求解原因
收起