If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2diag automatic Maintenance error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-27-07, 03:24
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
db2diag automatic Maintenance error

DB2 8.2.7
Win 2000

I Have automatic Maintenance on my DB
However i get a lot of failed reorg evaluation likes

2007-03-26-02.12.17.635000+330 I11830H458 LEVEL: Error
PID : 1704 TID : 3316 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.070325204221
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:515
MESSAGE : Failed to evaluate table "EONE "."TSDE_CNSS_PPLS_TEMP". Probe 400
DATA #1 : Hexdump, 4 bytes
0x0A0AF884 : FEF6 FFFF ....

2007-03-26-02.12.19.479000+330 I12290H458 LEVEL: Error
PID : 1704 TID : 3316 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.070325204221
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:515
MESSAGE : Failed to evaluate table "EONE "."TCOP_TMTBLE_PRD_TPE". Probe 400
DATA #1 : Hexdump, 4 bytes
0x0A0AF884 : FEF6 FFFF ....

2007-03-26-02.12.23.010000+330 I12750H454 LEVEL: Error
PID : 1704 TID : 3316 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.070325204221
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:515
MESSAGE : Failed to evaluate table "EONE "."TDB_BKP_TBL_LST". Probe 400
DATA #1 : Hexdump, 4 bytes
0x0A0AF884 : FEF6 FFFF

What could be the reason and Solution ??
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #2 (permalink)  
Old 03-12-10, 03:09
michael.mest michael.mest is offline
Registered User
 
Join Date: Jun 2009
Posts: 8
Hi, we've got the same Problem on DB/2 Version 9.7 FP1

System is SuSE Linux Enterprise Server Edition 11
on a 64-Bit PPC

Is there any solution for that?
Reply With Quote
  #3 (permalink)  
Old 03-12-10, 09:11
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Looks the same as what's described here:
IBM IZ01198: CUSTOMER IS GETTING TABLE EVALUATION FAILED FOR SOME TABLES - United States

Not sure why you're getting this error on v9.7 fp1.


Try executing runstats manually to see if it stops the error.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On